Defining Source Adapter General Information

Use the Source Adapter Summary section to view, define, delete, export, import, and copy summary information about a source adapter.

Adding a Source Adapter

  To add a source adapter:

  1. On the Setup tab, 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. You cannot modify the value in this field 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 Package or Scenario.

    • Package—A Package is 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.

Deleting a Source Adapter

Deleting a source adapter removes the parameters, drill-down URLs and source columns associated with the source adapter.

  To delete a source adapter:

  1. On the Setup tab, under Register, select Source Adapter.

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

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

  3. Click OK.

Exporting a Source Adapter

Use the Export feature to migrate an adapter definition from one environment to another in the XML file format.

  To export a file:

  1. On the Setup tab, under Register, select Source Adapter.

  2. In Source Adapter, on the Source Adapter summary task bar, in Export, select Export Current or Export All.

    • 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.

Importing a Source Adapter

  To import a source adapter:

  1. On the Setup tab, 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 then click Open.

  6. Click OK.

    The source adapter is added to the summary list.

Copying a Source Adapter Key

You can copy a source adapter key and its associated detail to a new adapter key.

  To copy a source adapter key:

  1. On the Setup tab, 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.

Using the SAP BW Source Adapter

You can use an SAP Business Warehouse (BW) source adapter to extract metadata and data from an SAP BW source system. The SAP BW integration with FDMEE differs from the standard and prepackaged integration frameworks. SAP (BW) comes with many predefined InfoCubes, or you can define your own InfoCubes.

Dimensions and hierarchies can be extracted from the SAP BW cube. After selecting the Infocube from the Source Adapter screen, metadata rules can be created to bring over dimensions and hierarchies.

  To add an SAP BW source adapter:

  1. On the Setup tab, 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 Classification.

    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.

    The name is shown on the Import Format screen and Data Load Workbench.

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

    See Defining Parameters.

  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.