Defining Source Adapter General Information

  To add a source adapter:

1. Select the Setup tab, and then under Register, select Source Adapter.

2. In Source Adapter, from the Source Adapter summary task bar, click Add.

   Blank entry rows are added to the Source Adapter summary section.

   Complete the following steps in the Source Adapter details section.

3. In Adapter Key, enter a user defined identifier for the adapter.

   For example for an Open Interface source adapter, enter OPENINT. The value in this field cannot be modified after it has been created.

4. In Adapter Name, enter a user defined name for the adapter.

   For example, enter Open Interface Adapter.

5. In ODI Object Name, enter the name of the package or scenario.

6. In ODI Object Type, select either Package or Scenario.

   • Package—A Package is made up of a sequence of steps organized into an execution diagram. Packages are the main objects used to generate scenarios for production. When you select Package as the ODI object type, then the source columns are shown, and you can specify maps in the import format in which the scenario is generated.

   • Scenario—ODI compiled code that must match exactly as specified in the ODI.

7. In ODI Object Project code, enter the template ODI project code.

8. In Source System Type, select the source application type.

9. Click Save.

  To delete a source adapter:

1. Select the Setup tab, and then under Register, select Source Adapter.

2. In the Source Adapter summary grid, select the source adapter and click Delete.

   The message: “This also deletes associated Parameters, Drill Down URLs and Source Columns. Delete Source Adapter?”

3. Click OK.

  To export a file:

1. Select the Setup tab, and then under Register, select Source Adapter.

2. In Source Adapter, on the Source Adapter summary task bar, select either Export Current or Export All from the Export drop-down.

   • Export Current—Exports a selected source adapter from the Source Adapter Summary list.

   • Export All—Exports all source adapters from the Source Adapter summary list.

3. To export a selected file, in Specify file location, navigate to the file to export, and then, click OK.

   You can enter the full path name and file name in the File Name field.

4. Optional: From Open File, save the file to a local directory on the desktop.

5. Optional: To browse for a file to export, select Upload, and then browse to the file to export. When the File Upload screen is displayed, navigate to the file to upload, and then, click Open.

6. Click OK.

  To import a source adapter:

1. Select the Setup tab, and then under Register, select Source Adapter.

2. In Source Adapter, on the Source Adapter summary task bar, select Import.

3. In Specify file to import, navigate to the file, and then, click OK.

4. in Open File, open the XML file or save it to a directory of your choice.

5. Optional: To browse to a file, select Upload. When the File Upload screen is displayed, navigate to the file, and click Open.

6. Click OK.

   The source adapter is added to the summary list.

  To copy a source adapter key:

1. Select the Setup tab, and then under Register, select Source Adapter.

2. In Source Adapter, on the Source Adapter summary task bar, select Copy.

3. In Copy, enter the name of the new adapter key, and then, click OK.

  To add an SAP BW source adapter:

1. Select the Setup tab, and then under Register, select Source Adapter.

2. In Source Adapter, on the Source Adapter summary task bar, click Add.

   Blank entry rows are added to the Source Adapter summary section.

3. In the Source Adapter details grid, in Adapter Key, enter a user defined identifier for the adapter.

   For example for an SAP BW source adapter, enter NK_SAP. The value in this field cannot be modified after it is created.

4. In *Adapter Name, enter a user defined name for the SAP BW adapter.

   For example, enter NK_SAP.

5. In *ODI Package Name, enter the name of the package.

   For example, enter NK_SAP.

6. In ODI Project Code, enter the template ODI project code name.

   The ODI Object Project code identifies an object within the project.

7. In Source System Type select the SAP BW source system.

8. In Cube Name, enter the predefined InfoCube name.

9. Click Import Cube Definition.

   The SAP BW cube information is imported into FDMEE, which creates the source columns in the Source Column tab.

10. In the Source Column grid, map each SAP BW cube column in the Column Name field to the type of data column in the Classification drop down.

    For example, for the IOPK_0FIGL_C101_0CO_AREA_PK_CO_AREA column, select the Fact classification.

    Classification types:

    • Fact

    • Year

    • Period

    • Period Number

11. In Display Name, enter the name to display for the column.

    This Display Name is shown on the Import Format screen and Data Load Workbench.

12. Select the Parameters tab, and specify any filter parameters.

    SeeDefining Parameters for more information.

13. In the Source Adapter summary grid, click Generate Template Package.

    The template package is used to generate the final scenario based on the import format mappings. If any customizations are required, you can customize the auto generated template package.

14. Click Save.

15. Define the import format and generate the process.