In this procedure, you import source-specific metadata content into the new ODI Repository by running the command line utility.
Use these instructions to import source-specific metadata content into the new ODI Repository.
<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
.
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.bia-odi-util.jar
, which is stored in C:\<Middleware Home>\<BI_ORACLE_HOME>\biapps\biaodiutil\lib
.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
.
In the command, this directory is referred to as LOGDIR
.
In the command, this directory is referred to as ODI_HOME
.
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.
For potential performance enhancement, Oracle recommends running the command line utility on the database server machine.
To import metadata content by running the command line utility:
C:\<Middleware Home>\<BI_ORACLE_HOME>\biapps\biaodiutil\lib
directory.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
This table describes the parameters:
Parameter | Description |
---|---|
MODE |
(Mandatory) Possible values:
|
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:
|
PLV |
(Mandatory) The PLV code for the adaptor being imported. Possible values:
|
SRCTECH |
(Mandatory) The source technology for the adaptor being imported. Possible values:
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
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.