Importing the ODI Project

After running the configuration utility to create the data warehouse, and configuring an ETL home directory, complete the following steps to import the Data Warehouse Project into ODI

1. If you created an agent in ODI using the name "OracleDIAgent", delete the agent before running the initial ETL process (in Step 2) as outlined below. This will prevent the odiImport step from failing with the message, ODI-17591: Name "OracleDIAgent" is already used, and allow the Data Warehouse project to import successfully:
   1. Browse to the <ODI Home>\studio folder.
   2. Run odi.exe (with Windows) or odi.sh (with UNIX or Linux) to launch the ODI studio.
   3. Select the Topology tab.
   4. Select Connect to Repository....
   5. When prompted, enter the walled password you created to get access to your studio login credentials.
   6. Select the Oracle Data Integrator login you created, and connect with the SUPERVISOR user.
   7. Under Physical Architecture, expand Agents.
   8. Right-click OracleDIAgent and select Delete.
   9. Select Save.
   10. Close the ODI Studio.
2. Now run the STARETL process as follows:
   1. Browse to the <PDW Install Folder>\star\config\odi folder.
   2. To import the project and add initial data sources which were configured, run odiSetup.cmd (with Windows) or odiSetup.sh (with UNIX or Linux).

      or

   3. If you want to manually run the STARETL process for each data source:
      1. Run odiImport.cmd (with Windows) or odiImport.sh (with UNIX or Linux).
      2. Browse to the <PDW Install Folder>\star\etl_homes\<datasource_name> folder.
      3. Run odiAddDS.cmd (with Windows) or odiAddDS.sh (with UNIX or Linux).

Note: The time required for the ODI Import process depends on the amount of data brought over during the initial load.

Legal Notices | Your Privacy Rights
Copyright © 1999, 2020

Last Published Monday, December 14, 2020