Configure an Oracle Cloud Application Data Source

This topic covers the Oracle Cloud Application-specific steps for creating a data source in the Management Console. The configuration steps in this topic apply to Oracle Fusion implementations. For general data source creation steps, see Create Source System in the Installer and Management Console Guide.

To configure connections

1. In the left navigation bar, select Data Sources.
2. To create a new data source, click Create. To update an existing one, click the more options button in the Actions column and select Edit.
3. Go to the Connection tab. The following connections are available:
   1. OCA: Connects to your Oracle Cloud Application (OCA) instance to extract financial transaction data.
   2. Azure Schema: Connects to the Azure staging database where the extracted data is loaded before replication to SAP Central Finance.
4. Expand the OCA Connection section and enter the following details:
   1. Connection URL: The URL of your OCA instance.
   2. Username: The username used to connect to OCA.
   3. Password: The password associated with the username.

   

5. Expand the Azure Schema Connection section and enter the following details:
   1. Username: The username used to connect to the Azure staging database.
   2. Password: The password associated with the username.
   3. Server: The server name of the Azure staging database.
   4. Core Database: The name of the core database in the Azure staging environment.
   5. Core Schema: The schema that contains the replicated OCA data.
   6. Source Database: The name of the source database in the Azure staging environment.
   7. Source Schema: The schema that contains the source data extracted from OCA.
   8. CDC Schema: The schema used to capture incremental changes from OCA.

   

6. Click Test Connection to verify both connections before proceeding.

To deploy objects

After configuring the connections, go to the Deployment tab and complete the following steps in order.

1. Select the None category and click Deploy. This deploys the PVO table metadata, including all core tables required for data extraction.
2. Enable CDC at the database level and then at the table level for the required extraction tables. Execute the following scripts in SQL Server Management Studio against the Azure staging database: To enable CDC at the database level:

   sql

   EXEC sys.sp_cdc_enable_db;

   GO

   To enable CDC at the table level, run the following script:

   sql

   EXEC sys.sp_cdc_enable_table

   @source_schema = N'dbo',

   @source_name = N'JOURNALHEADEREXTRACTPVO',

   @role_name = NULL,

   @supports_net_changes = 0;

   GO

   Once CDC is enabled successfully, the corresponding CDC capture and cleanup jobs start, and the CDC system tables are created under System Tables in the database.

3. Return to the Deployment tab, select the Transaction category, and click Deploy to deploy the remaining extraction objects.