You can modify the Open Interface Adapter to meet your business needs, and then once fully tested, move the updated content to a different environment for further testing or use in production. The steps to perform the customization and migration are listed below.
Use ODI Studio to perform the following steps. Before performing these steps, backup you work repository, custom project, and model.
When exporting and importing objects, use the following options:
When exporting, select the Child Components Export option.
When importing, use Synonym Mode INSERT_UPDATE as the Import Type.
To modify the Open Interface Adapter:
In the FDMEE repository, export the Open Interface Adapter Model and ERPI Target Model folders.
In the FDMEE repository, export the Open Interface Adapter Project.
Create a new work repository with a new ID.
Use a repository ID of 900 or higher to avoid conflicts with Oracle shipped components. This is your development repository when performing customization. It is referred to as the “custom repository” in the following steps.
In the custom repository, import the model folders named: Open Interface Adapter Model and ERPI Target Model.
In the custom repository, import the Open Interface Adapter Project.
Perform any customizations in the custom repository.
When customizing objects, do not modify FDMEE seeded objects imported from the FDMEE repository. Instead, copy needed objects, use the“ Custom” suffix in names to identify them, and then modify them.
For example, copy the “Open Interface Balances” package as “Open Interface Balances Custom,” and make any edits to it.
Export customized objects (for example, Project, Packages, Interfaces) from the custom repository and import them into the FDMEE repository.
Using the FDMEE Source Adapter user interface, copy the Open Interface Adapter to a new adapter and complete the following:
For the new adapter, provide a new adapter key. The adapter key can be ten characters long. Once it has been created, it cannot be modified.
Make any necessary modifications to the Display Names. Display Name are shown in the Import Format and Data Load Workbench.
Specify the ODI Package Name and ODI Project Code as specified in the custom project.