The Oracle BI Application Blogs provides the latest and tips and tricks on Oracle BI Applications Product (OBIA)

Try Oracle Cloud Platform For Free

SDS

EBS

Special use cases for Replication to SDS via OGG

Authors: "Guna Vasireddy - Oracle","Sai Rajendra Vadakattu - Oracle ", "Ankur Jain - Oracle" Replicating Table without Primary Key Replicating Views...

Authors: "Guna Vasireddy - Oracle","Sai Rajendra Vadakattu - Oracle ", "Ankur Jain - Oracle" Replicating Table without Primary Key Replicating Views Replicating OLTP Packages Replicating Table without Primary Key: Use Case: Customer is using Oracle Golden Gate (OGG) to replicate the Source to SDS and would like to configure BIAPPS to use the SDS instead of the Source. Note: The SDS table differs from the source table in primarily two things: BIAPPS expects CDC columns...

BIAPPS on PAAS

BICS-DataSync use steps for OBIA on PaaS

Contents Scope. 1 Business Needs and Overview.. 1 1. Create the place holder SDS schema using RCU.. 2 2. Run the python script to create datasource in WebLogic...

Contents Scope. 1 Business Needs and Overview.. 1 1. Create the place holder SDS schema using RCU.. 2 2. Run the python script to create datasource in WebLogic Server and wiring in ODI 2 3. Setup Source connection in BIACM... 2 4. Run the SDS DDL generate scenario to create SDS objects in SDS schema. 2 5. Datasync - Configure target-auto-columns.txt file. 3 6. Datasync - Create connections for target SDS schema and source OLTP in data sync tool. 4 7. Datasync - Import source...