Create a source configuration for Oracle EBS in DCT
Complete these common steps before you use any of the method-specific procedures in the following sections.
Procedure
-
Open Infrastructure Connections.
-
Click View to open the environment where you want to add the source config (for example, Oracle EBS Staging Env).
-
Open the Data tab.
-
On the Data tab, expand the installation where you want to add the source config.
-
Scroll to the Data Sources section and click + Source Database. The Add Database dialog opens.
-
In the Add Database dialog, name your source config (for example, pg-src-config) and click Save.
-
Confirm the new source config appears in the Data Sources list with the following details:
-
Database User: None
-
Allow Linking: True
-
dSource: None
-
Tags: No tags added
-
Launch the Create and Link dSource Wizard
-
Launch the wizard in one of the following ways:
-
From your new source config entry, click + dSource.
-
Open Data Management > dSources and click + dSource.
-
-
Select the dSource type. On the dSource Type page, Always select Source Based dSource (dSource linked to a source database) and click Next.
-
Select the data source. On the Select Data Source page, select the available Oracle EBS source configuration from the list (for example, SRC-DBTIER-TX with platform ebs122-vsdk-db).