Creating SDS Schema Post Installation

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