Provision new SDS PLV types in ODI using the script provided in this topic. The script exists in the oracle home and can be used immediately.
-Component Values
This script creates the WLS datasource for the SDS type and provision the SDS Data server in ODI.
You need to create the SDS DB schema through the RCU before running this script as the script requires some schema details as input parameter.
Create new SDS schema types using the following -component
values:
SDS_EBS_12_1_3
SDS_EBS_12_2
SDS_FUSION_10
SDS_FUSION_9
SDS_PSFT_9_1_CS
SDS_PSFT_9_1_EP
SDS_PSFT_9_1_HR
SDS_PSFT_9_2_CS
SDS_PSFT_9_2_EP
SDS_PSFT_9_2_HR
SDS_SEBL_8_1_1
SDS_SEBL_8_2_2
SDS_TALEO_14A
SDS_TALEO_14B
SDS_TALEO_15A
SDS_RNCX_1_2_14_8
./rcu -createRepository command -component SDS_TALEO_15A" eg; ./rcu -createRepository -connectString slc01awp.us.oracle.com:17211:db5547.us.oracle.com -dbUser sys -dbRole SYSDBA -useSamePasswordForAllSchemaUsers true -selectDependentsForComponents true -schemaPrefix FA -silent -component SDS_TALEO_14A -component SDS_TALEO_14B -component SDS_TALEO_15A
Command
Script location is <ORACLE_HOME>/dwtools/scripts/install_cloud_replicator_component_SDS.py
Parameters
--DOMAIN_HOME_PATH - BI Domain Home path. eg; /scratch/aime1/work/mw1234/user_projects/domains/bifoundation_domain --BI_CLUSTER_NAME - BI Cluster name. Please use the value as is without quotes - "bi_cluster" --SDS_PROVISION_TYPE - The SDS PLV code. Please see the table below to use the PLV code to provision a specific SDS type. eg; TALEO_14_B --SDS_JDBC_URL - SDS PLV JDBC url string format: jdbc:oracle:thin:@<db_host>:<port>/<ServiceName> eg; jdbc:oracle:thin:@adc00zqz.us.oracle.com:11313/db7043.us.oracle.com --SDS_DB_SCHEMA - SDS PLV db schema user name eg; FA_SDS_TALEO_14B --ODI_JDBC_URL - ODI REPO JDBC url string format: jdbc:oracle:thin:@<db_host>:<port>/<ServiceName> eg; jdbc:oracle:thin:@adc00zqz.us.oracle.com:11313/db7043.us.oracle.com --ODI_DB_SCHEMA - ODI REPO schema user name. eg; FA_BIA_ODIREPO, --ODI_USER_NAME - ODI user name. eg; Administrator1, --ODI_HOME_PATH - ODI home path. eg; /scratch/aime1/work/mw1234/odi3898
SDS PLV Code to use in the command
FUSION_9_0
FUSION_10_0
TALEO_14_A
TALEO_14_B
TALEO_15_A
RNCX_12_14_8
EBS_12_1_3
EBS_12_2
PSFT_9_1_CS
PSFT_9_1_EP
PSFT_9_1_HR
PSFT_9_2_CS
PSFT_9_2_EP
PSFT_9_2_HR
SEBL_8_1_1
SEBL_8_2_2
Below example shows the SDS provisioning of Taleo 14 B. See the input param --SDS_PROVISION_TYPE TALEO_14_B
Run the following command:
Eg Usage Command: <ORACLE_HOME>/oracle_common/common/wlst.sh /scratch/aime1/work/mw1234/Oracle_BI1/dwtools/scripts/install_cloud_replicator_component_SDS.py --DOMAIN_HOME_PATH /scratch/aime1/work/mw1234/user_projects/domains/bifoundation_domain --BI_CLUSTER_NAME bi_cluster --SDS_PROVISION_TYPE TALEO_14_B --SDS_JDBC_URL jdbc:oracle:thin:@adc00zqz.us.oracle.com:11313/db7043.us.oracle.com --SDS_DB_SCHEMA FA_SDS_TALEO_14B --ODI_JDBC_URL jdbc:oracle:thin:@adc00zqz.us.oracle.com:11313/db7043.us.oracle.com --ODI_DB_SCHEMA FA_BIA_ODIREPO --ODI_USER_NAME Administrator1 --ODI_HOME_PATH /scratch/aime1/work/mw1234/odi3898