Importing Source Adaptor Metadata Content into the New ODI Repository

Use these instructions to import source-specific metadata content into the new ODI Repository.

1. Locate the directory <BI_ORACLE_HOME>\biapps\admin\provisioning\odi.

   The .zip files in this directory contain the source-specific metadata content that you will import into the new repository. The naming convention for the .zip files is <Source adapter>_<database technology>_ODI_Metadata.zip.

   
   Description of the illustration GUID-EEE5AA9B-3667-4C74-85AE-C9591586D89B-default.gif
2. Unzip ORACLE__BIA_11__ORACLE_ODI_Metadata.zip first and then unzip the appropriate metadata content file for your source adapter and database technology.

   Note:

   While unzipping files, do not unzip into a separate folder. Use Extract here option from unzipping tools to unzip all metadata zip files.

   For example, once you unzip files, you will be seeing the following folder structure:

   
   Description of the illustration GUID-B313E74B-E296-45D1-A4E5-8175B9AA1401-default.gif

   Inside ORACLE folder, you will see the following folders:

   
   Description of the illustration GUID-29F10078-3897-4ADC-AB00-13F40BDD6E52-default.gif
3. Locate the file bia-odi-util.jar, which is stored in C:\<Middleware Home>\<BI_ORACLE_HOME>\biapps\biaodiutil\lib.
4. Locate the file jps-config-jse.xml, which is stored in C:\<Middleware Home>\user_projects\domains\bifoundation_domain\odi-client-config\embedded.

   In the command, this file is referred to as JPSCONFIGFILE.

5. Create a logs directory to store the logs of the import process.

   In the command, this directory is referred to as LOGDIR.

6. Locate the ODI Home directory.

   In the command, this directory is referred to as ODI_HOME.

7. Obtain these ODI Repository connection details:

   • JDBC URL for the ODI Repository database

   • JDBC driver

   • Work Repository name

   • ODI Repository database user name and password

   • ODI user and password

   This connection information is displayed in ODI Studio in the Repository Connection Details dialog.

Use this procedure to import the metadata content files into the new ODI Repository. You will first import the metadata for Oracle BI Applications, after which you will import the metadata for the appropriate source adaptors.

1. Open a command line utility.
2. Navigate to the C:\<Middleware Home>\<BI_ORACLE_HOME>\biapps\biaodiutil\lib directory.
3. Run the following command to import the Oracle BI Applications metadata first, which is mandatory before importing any source specific metadata content.

   The PLV code for this adaptor is BIA_11.

   On Windows:

   <JAVA_HOME>\bin\java.exe \-client \-Xms32m \-Xmx1024m \-classpath <ODI_HOME>\oracledi.sdk\lib\*;<ODI_HOME>\inventory\Scripts\ext\jlib\*;<ODI_HOME>\modules\oracle.idm_11.1.1\*;<ODI_HOME>\modules\oracle.jps_11.1.1\*;<BI_ORACLE_HOME>\biapps\lib\*;<BI_ORACLE_HOME >\biapps\biaodiutil\lib\bia-odi-util.jar oracle.apps.biaodiutil.Import MODE=IMPORT FILEDIR=<EXP_FILE_DIR> PLV=<PLV_CODE> JPSCONFIGFILE=<JPS_CONFIG_FILE> LOGDIR=<LOG_DIR>
   

   For example:

   E:\app\oracle\MW_HOME\Oracle_BI1\jdk\bin\java.exe -client -Xms32m -Xmx1024m -classpath E:\app\oracle\MW_HOME\Oracle_ODI1\oracledi.sdk\lib\*;E:\app\oracle\MW_HOME\Oracle_ODI1\inventory\Scripts\ext\jlib\*;E:\app\oracle\MW_HOME\Oracle_ODI1\modules\oracle.idm_11.1.1\*;E:\app\oracle\MW_HOME\Oracle_ODI1\modules\oracle.jps_11.1.1\*;E:\app\oracle\MW_HOME\Oracle_BI1\biapps\lib\*;E:\app\oracle\MW_HOME\Oracle_BI1\biapps\biaodiutil\lib\bia-odi-util.jar oracle.apps.biaodiutil.Import MODE=IMPORT FILEDIR=E:\temp PLV=BIA_11 JPSCONFIGFILE=E:\app\oracle\MW_HOME\user_projects\domains\bifoundation_domain\odi-client-config\embedded LOGLEVEL=5 LOGDIR=E:/app/oracle/MW_HOME/logs/DB2SetupLog
   

   On UNIX/Linux:

   <JAVA_HOME>\bin\java.exe \-client \-Xms32m \-Xmx1024m \-classpath "<ODI_HOME>/oracledi.sdk/lib/*:<ODI_HOME>/inventory/Scripts/ext/jlib/*:<ODI_HOME>/modules/oracle.idm_11.1.1/*:<ODI_HOME>/modules/oracle.jps_11.1.1/*:<BI_ORACLE_HOME>/biapps/lib/*:<BI_ORACLE_HOME >/biapps/biaodiutil/lib/bia-odi-util.jar" oracle.apps.biaodiutil.Import MODE=IMPORT FILEDIR=<EXP_FILE_DIR> PLV=<PLV_CODE> JPSCONFIGFILE=<JPS_CONFIG_FILE> LOGDIR=<LOG_DIR>
   

   For example:

   /usr/bin/java -client -Xms32m -Xmx1024m -classpath "/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/oracledi.sdk/lib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/inventory/Scripts/ext/jlib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/modules/oracle.idm_11.1.1/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/modules/oracle.jps_11.1.1/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_BI1/biapps/lib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_BI1/biapps/biaodiutil/lib/bia-odi-util.jar" oracle.apps.biaodiutil.Import MODE=IMPORT FILEDIR=/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/vv/ PLV=BIA_11 JPSCONFIGFILE=user_projects/domains/bifoundation_domain/odi-client-config/embedded/jps-config-jse.xml LOGDIR=/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/vv/logs
   

4. Run the following command to import the source-specific metadata content. The PLV code and SRCTECH for the source-specific metadata content are given in the following parameters table.

   This table describes the parameters:

   Parameter	Description
   MODE	(Mandatory) Possible values: IMPREGEN - Use this mode to import the adaptor metadata content and generate scenarios for that adaptor. IMPORT — Use this mode to import metadata content only, without generating scenarios. A parameter file is generated that allows you to do the scenario generation at a later time. SCEREGEN — Use this mode to generate scenarios only. Before running this mode, you need to have imported content using the IMPORT mode so that the parameter file required for scenario generation is already present.
   FILEDIR	(Mandatory) The complete path for the export file directory files.
   CONNFILE	(Optional) The complete path of the file containing the Connection Details. If this parameter is not used, the utility will prompt for the connection details. An example of a connection file is as follows: # =============================== # ODI Connection Information # ================================ # Connection Information for Destination Oracle Data #Integrator Repository MasterJDBCDriver=oracle.jdbc.OracleDriver MasterJDBCUrl=jdbc:oracle:thin:@<host>:1521:orcl MasterJDBCUser=ODI_REP MasterJDBCPass=odirep WorkName=BIAPPS_WORKREP ODIUser=SUPERVISOR ODIPass=odipass
   LOGLEVEL	(Optional) Possible values are 1, 3, or 5. The default value is 1, with 5 being the most verbose.
   LOGDIR	The complete path for the log directory. The following log files are created: Summary — Contains high level log information. The naming convention is Summary_ImportUtility_<DATE_TIME><ADAPTOR><SRCTECH>_log. Import — Contains details about the import. Has a log and error file. The naming convention is BasicImport_<DATE_TIME>_<ADAPTOR>_log. Scenario Generation — Contains details about the scenario generation. Has a log and error file. The naming convention is RegenScen_<DATE_TIME>_<ADAPTOR_MAPPING_FOLDER>_log.
   PLV	(Mandatory) The PLV code for the adaptor being imported. Possible values: AGILE_PLM_9_3_1 AGPLM_9_3_2 AILE_GILE_PLM_PROC_6_1 EBS_11_5_10 EBS_12_0 EBS_12_1_1 EBS_12_1_2 EBS_12_1_3 EBS_12_2 JDE_9_0 JDE_9_1 PSFT_9_0 PSFT_9_1 PSFT_9_2 SEBL_8_1_1 SEBL_8_2_2
   SRCTECH	(Mandatory) The source technology for the adaptor being imported. Possible values: For IBM DB2/400: IBM_DB2_400 For IBM DB2 UDB: IBM_DB2_UDB For SQL Server: MICROSOFT_SQL_SERVER For ORACLE: ORACLE For Oracle Fusion (via BI Server): ORACLE_BI If you have multiple sources on both Oracle and non-Oracle databases, you need to import the PLV metadata for the Oracle database using ORACLE (or ORACLE_BI for Oracle Fusion sources) as the SRCTECH value.
   JPSCONFIGFILE	(Mandatory if the repository has already been enabled for external authentication.) The path and name of the JPSCONFIGFILE.
   SSOFILE	(Optional) The path and name of the SSO file.

   On Windows:

   For example:

   E:\app\oracle\MW_HOME\Oracle_BI1\jdk\bin\java.exe -client -Xms32m -Xmx1024m -classpath E:\app\oracle\MW_HOME\Oracle_ODI1\oracledi.sdk\lib\*;E:\app\oracle\MW_HOME\Oracle_ODI1\inventory\Scripts\ext\jlib\*;E:\app\oracle\MW_HOME\Oracle_ODI1\modules\oracle.idm_11.1.1\*;E:\app\oracle\MW_HOME\Oracle_ODI1\modules\oracle.jps_11.1.1\*;E:\app\oracle\MW_HOME\Oracle_BI1\biapps\lib\*;E:\app\oracle\MW_HOME\Oracle_BI1\biapps\biaodiutil\lib\bia-odi-util.jar oracle.apps.biaodiutil.Import MODE=IMPORT FILEDIR=E:\temp PLV=JDE_9_1 SRCTECH= MICROSOFT_SQL_SERVER JPSCONFIGFILE=E:\app\oracle\MW_HOME\user_projects\domains\bifoundation_domain\odi-client-config\embedded LOGLEVEL=5 LOGDIR=E:/app/oracle/MW_HOME/logs/DB2SetupLog
   

   On Linux:

   For example:

   /usr/bin/java -client -Xms32m -Xmx1024m -classpath "/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/oracledi.sdk/lib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/inventory/Scripts/ext/jlib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/modules/oracle.idm_11.1.1/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/modules/oracle.jps_11.1.1/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_BI1/biapps/lib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_BI1/biapps/biaodiutil/lib/bia-odi-util.jar" oracle.apps.biaodiutil.Import MODE=IMPORT FILEDIR=/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/vv/ PLV=JDE_9_1 JPSCONFIGFILE=user_projects/domains/bifoundation_domain/odi-client-config/embedded/jps-config-jse.xml LOGDIR=/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/vv/logs SRCTECH=MICROSOFT_SQL_SERVER
   

   Repeat Step 4 if you want to import any other source specific metadata content by choosing the appropriate PLV code and SRCTECH parameter.

   Following are few sample commands for importing other source specific metadata:

   JDE_9_0 for MSSQL:

   /usr/bin/java -client -Xms32m -Xmx1024m -classpath "/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/oracledi.sdk/lib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/inventory/Scripts/ext/jlib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/modules/oracle.idm_11.1.1/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/modules/oracle.jps_11.1.1/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_BI1/biapps/lib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_BI1/biapps/biaodiutil/lib/bia-odi-util.jar" oracle.apps.biaodiutil.Import MODE=IMPORT FILEDIR=/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/vv/ PLV=JDE_9_0 JPSCONFIGFILE=user_projects/domains/bifoundation_domain/odi-client-config/embedded/jps-config-jse.xml LOGDIR=/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/vv/logs SRCTECH=MICROSOFT_SQL_SERVER
   

   JDE_9_0 for DB2UDB:

   /usr/bin/java -client -Xms32m -Xmx1024m -classpath "/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/oracledi.sdk/lib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/inventory/Scripts/ext/jlib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/modules/oracle.idm_11.1.1/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/modules/oracle.jps_11.1.1/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_BI1/biapps/lib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_BI1/biapps/biaodiutil/lib/bia-odi-util.jar" oracle.apps.biaodiutil.Import MODE=IMPORT FILEDIR=/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/vv/ PLV=JDE_9_0 JPSCONFIGFILE=user_projects/domains/bifoundation_domain/odi-client-config/embedded/jps-config-jse.xml LOGDIR=/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/vv/logs SRCTECH=IBM_DB2_UDB
   

   JDE_9_0 for DB2400:

   /usr/bin/java -client -Xms32m -Xmx1024m -classpath "/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/oracledi.sdk/lib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/inventory/Scripts/ext/jlib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/modules/oracle.idm_11.1.1/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/modules/oracle.jps_11.1.1/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_BI1/biapps/lib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_BI1/biapps/biaodiutil/lib/bia-odi-util.jar" oracle.apps.biaodiutil.Import MODE=IMPORT FILEDIR=/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/vv/ PLV=JDE_9_0 JPSCONFIGFILE=user_projects/domains/bifoundation_domain/odi-client-config/embedded/jps-config-jse.xml LOGDIR=/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/vv/logs SRCTECH=IBM_DB2_400
   

   JDE_9_0 for ORACLE:

   /usr/bin/java -client -Xms32m -Xmx1024m -classpath "/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/oracledi.sdk/lib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/inventory/Scripts/ext/jlib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/modules/oracle.idm_11.1.1/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/modules/oracle.jps_11.1.1/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_BI1/biapps/lib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_BI1/biapps/biaodiutil/lib/bia-odi-util.jar" oracle.apps.biaodiutil.Import MODE=IMPORT FILEDIR=/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/vv/ PLV=JDE_9_0 JPSCONFIGFILE=user_projects/domains/bifoundation_domain/odi-client-config/embedded/jps-config-jse.xml LOGDIR=/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/vv/logs SRCTECH=ORACLE
   

   JDE_9_1 for MSSQL:

   /usr/bin/java -client -Xms32m -Xmx1024m -classpath "/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/oracledi.sdk/lib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/inventory/Scripts/ext/jlib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/modules/oracle.idm_11.1.1/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/modules/oracle.jps_11.1.1/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_BI1/biapps/lib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_BI1/biapps/biaodiutil/lib/bia-odi-util.jar" oracle.apps.biaodiutil.Import MODE=IMPORT FILEDIR=/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/vv/ PLV=JDE_9_1 JPSCONFIGFILE=user_projects/domains/bifoundation_domain/odi-client-config/embedded/jps-config-jse.xml LOGDIR=/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/vv/logs SRCTECH=MICROSOFT_SQL_SERVER
   

   JDE_9_1 for DB2UDB:

   /usr/bin/java -client -Xms32m -Xmx1024m -classpath "/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/oracledi.sdk/lib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/inventory/Scripts/ext/jlib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/modules/oracle.idm_11.1.1/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/modules/oracle.jps_11.1.1/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_BI1/biapps/lib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_BI1/biapps/biaodiutil/lib/bia-odi-util.jar" oracle.apps.biaodiutil.Import MODE=IMPORT FILEDIR=/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/vv/ PLV=JDE_9_1 JPSCONFIGFILE=user_projects/domains/bifoundation_domain/odi-client-config/embedded/jps-config-jse.xml LOGDIR=/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/vv/logs SRCTECH=IBM_DB2_UDB
   

   JDE_9_1 for DB2400:

   /usr/bin/java -client -Xms32m -Xmx1024m -classpath "/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/oracledi.sdk/lib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/inventory/Scripts/ext/jlib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/modules/oracle.idm_11.1.1/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/modules/oracle.jps_11.1.1/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_BI1/biapps/lib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_BI1/biapps/biaodiutil/lib/bia-odi-util.jar" oracle.apps.biaodiutil.Import MODE=IMPORT FILEDIR=/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/vv/ PLV=JDE_9_1 JPSCONFIGFILE=user_projects/domains/bifoundation_domain/odi-client-config/embedded/jps-config-jse.xml LOGDIR=/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/vv/logs SRCTECH=IBM_DB2_400
   

   JDE_9_1 for ORACLE:

   /usr/bin/java -client -Xms32m -Xmx1024m -classpath "/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/oracledi.sdk/lib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/inventory/Scripts/ext/jlib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/modules/oracle.idm_11.1.1/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/modules/oracle.jps_11.1.1/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_BI1/biapps/lib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_BI1/biapps/biaodiutil/lib/bia-odi-util.jar" oracle.apps.biaodiutil.Import MODE=IMPORT FILEDIR=/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/vv/ PLV=JDE_9_1 JPSCONFIGFILE=user_projects/domains/bifoundation_domain/odi-client-config/embedded/jps-config-jse.xml LOGDIR=/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/vv/logs SRCTECH=ORACLE
   

   PSFT_9_2 for MSSQL:

   /usr/bin/java -client -Xms32m -Xmx1024m -classpath "/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/oracledi.sdk/lib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/inventory/Scripts/ext/jlib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/modules/oracle.idm_11.1.1/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/modules/oracle.jps_11.1.1/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_BI1/biapps/lib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_BI1/biapps/biaodiutil/lib/bia-odi-util.jar" oracle.apps.biaodiutil.Import MODE=IMPORT FILEDIR=/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/vv/ PLV=PSFT_9_2 JPSCONFIGFILE=user_projects/domains/bifoundation_domain/odi-client-config/embedded/jps-config-jse.xml LOGDIR=/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/vv/logs SRCTECH=MICROSOFT_SQL_SERVER
   

   PSFT_9_2 for DB2UDB:

   /usr/bin/java -client -Xms32m -Xmx1024m -classpath "/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/oracledi.sdk/lib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/inventory/Scripts/ext/jlib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/modules/oracle.idm_11.1.1/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/modules/oracle.jps_11.1.1/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_BI1/biapps/lib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_BI1/biapps/biaodiutil/lib/bia-odi-util.jar" oracle.apps.biaodiutil.Import MODE=IMPORT FILEDIR=/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/vv/ PLV=PSFT_9_2 JPSCONFIGFILE=user_projects/domains/bifoundation_domain/odi-client-config/embedded/jps-config-jse.xml LOGDIR=/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/vv/logs SRCTECH=IBM_DB2_UDB
   

   PSFT_9_2 for DB2400:

   /usr/bin/java -client -Xms32m -Xmx1024m -classpath "/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/oracledi.sdk/lib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/inventory/Scripts/ext/jlib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/modules/oracle.idm_11.1.1/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/modules/oracle.jps_11.1.1/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_BI1/biapps/lib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_BI1/biapps/biaodiutil/lib/bia-odi-util.jar" oracle.apps.biaodiutil.Import MODE=IMPORT FILEDIR=/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/vv/ PLV=PSFT_9_2 JPSCONFIGFILE=user_projects/domains/bifoundation_domain/odi-client-config/embedded/jps-config-jse.xml LOGDIR=/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/vv/logs SRCTECH=IBM_DB2_400
   

   PSFT_9_2 for ORACLE:

   /usr/bin/java -client -Xms32m -Xmx1024m -classpath "/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/oracledi.sdk/lib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/inventory/Scripts/ext/jlib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/modules/oracle.idm_11.1.1/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/modules/oracle.jps_11.1.1/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_BI1/biapps/lib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_BI1/biapps/biaodiutil/lib/bia-odi-util.jar" oracle.apps.biaodiutil.Import MODE=IMPORT FILEDIR=/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/vv/ PLV=PSFT_9_2 JPSCONFIGFILE=user_projects/domains/bifoundation_domain/odi-client-config/embedded/jps-config-jse.xml LOGDIR=/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/vv/logs SRCTECH=ORACLE
   

   UNIVERSAL ADAPTOR :

   /usr/bin/java -client -Xms32m -Xmx1024m -classpath "/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/oracledi.sdk/lib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/inventory/Scripts/ext/jlib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/modules/oracle.idm_11.1.1/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/modules/oracle.jps_11.1.1/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_BI1/biapps/lib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_BI1/biapps/biaodiutil/lib/bia-odi-util.jar" oracle.apps.biaodiutil.Import MODE=IMPORT FILEDIR=/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/vv/ PLV=UNIVERSAL JPSCONFIGFILE=user_projects/domains/bifoundation_domain/odi-client-config/embedded/jps-config-jse.xml LOGDIR=/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/vv/logs SRCTECH=FILE
   

   DATA LINEAGE ADAPTOR :

   /usr/bin/java -client -Xms32m -Xmx1024m -classpath "/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/oracledi.sdk/lib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/inventory/Scripts/ext/jlib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/modules/oracle.idm_11.1.1/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/modules/oracle.jps_11.1.1/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_BI1/biapps/lib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_BI1/biapps/biaodiutil/lib/bia-odi-util.jar" oracle.apps.biaodiutil.Import MODE=IMPORT FILEDIR=/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/vv/ PLV=DATA_LIN JPSCONFIGFILE=user_projects/domains/bifoundation_domain/odi-client-config/embedded/jps-config-jse.xml LOGDIR=/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/vv/logs 
   

   Note:

   The following Tech switch adaptor metadata zip files are delivered along with the package scenarios, hence when you run the command line utility to import these files, ensure that you use import mode as IMPORT as seen in the above example:

   ORACLE__BIA_11__ORACLE_ODI_Metadata.zip
   ORACLE__JDE_9_0__DB2400_ODI_Metadata.zip
   ORACLE__JDE_9_0__DB2UDB_ODI_Metadata.zip
   ORACLE__JDE_9_0__MSSQL_ODI_Metadata.zip
   ORACLE__JDE_9_1__DB2400_ODI_Metadata.zip
   ORACLE__JDE_9_1__DB2UDB_ODI_Metadata.zip
   ORACLE__JDE_9_1__MSSQL_ODI_Metadata.zip
   ORACLE__PSFT_9_0__DB2UDB_ODI_Metadata.zip
   ORACLE__PSFT_9_0__MSSQL_ODI_Metadata.zip
   ORACLE__PSFT_9_1__DB2UDB_ODI_Metadata.zip
   ORACLE__PSFT_9_1__MSSQL_ODI_Metadata.zip
   ORACLE__PSFT_9_2__DB2UDB_ODI_Metadata.zip
   ORACLE__PSFT_9_2__MSSQL_ODI_Metadata.zip
   ORACLE__SEBL_8_1_1__DB2UDB_ODI_Metadata.zip
   ORACLE__SEBL_8_1_1__MSSQL_ODI_Metadata.zip
   ORACLE__SEBL_8_2_2__DB2UDB_ODI_Metadata.zip
   ORACLE__SEBL_8_2_2__MSSQL_ODI_Metadata.zip
   

   Apart from the above zip files, if you are importing any other adaptor metadata zip files into your repository, ensure that you use import mode as IMPREGEN which would import the adaptor metadata content and generate scenarios for that adaptor.

   For example:

   On Windows:
   
   E:\app\oracle\MW_HOME\Oracle_BI1\jdk\bin\java.exe -client -Xms32m -Xmx1024m -classpath E:\app\oracle\MW_HOME\Oracle_ODI1\oracledi.sdk\lib\*;E:\app\oracle\MW_HOME\Oracle_ODI1\inventory\Scripts\ext\jlib\*;E:\app\oracle\MW_HOME\Oracle_ODI1\modules\oracle.idm_11.1.1\*;E:\app\oracle\MW_HOME\Oracle_ODI1\modules\oracle.jps_11.1.1\*;E:\app\oracle\MW_HOME\Oracle_BI1\biapps\lib\*;E:\app\oracle\MW_HOME\Oracle_BI1\biapps\biaodiutil\lib\bia-odi-util.jar oracle.apps.biaodiutil.Import MODE=IMPREGEN FILEDIR=E:\temp PLV=EBS_12_2 JPSCONFIGFILE=E:\app\oracle\MW_HOME\user_projects\domains\bifoundation_domain\odi-client-config\embedded LOGLEVEL=5 LOGDIR=E:/app/oracle/MW_HOME/logs/DB2SetupLog SRCTECH=ORACLE
   
   On UNIX/Linux:
   
   /usr/bin/java -client -Xms32m -Xmx1024m -classpath "/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/oracledi.sdk/lib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/inventory/Scripts/ext/jlib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/modules/oracle.idm_11.1.1/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_ODI1/modules/oracle.jps_11.1.1/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_BI1/biapps/lib/*:/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/biapps8/middleware/Oracle_BI1/biapps/biaodiutil/lib/bia-odi-util.jar" oracle.apps.biaodiutil.Import MODE=IMPREGEN FILEDIR=/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/vv/ PLV=EBS_12_2 JPSCONFIGFILE=user_projects/domains/bifoundation_domain/odi-client-config/embedded/jps-config-jse.xml LOGDIR=/padred2ap/bi/padred2_usmtnecdbinap08/ipadred2/vv/logs SRCTECH=ORACLE
   

5. Enter the ODI Repository connection details when prompted.
6. Monitor the process by viewing the command line window or the log files being written to the logs directory.

   This process can be lengthy and can last from 45 minutes to three hours, depending on the number of adaptors for which you are importing metadata content.

7. When the import process is complete, log into ODI Studio and verify the data stores and mappings for the new adaptor are present.
8. Repeat steps 1 through 7 for each adaptor you need to import, substituting the appropriate PLV code.