Use this procedure to register a source system and propagate the connection details to ODI.
Note:
If you want to register the Oracle Fusion Applications source, then follow the steps in Register the Fusion Applications Source.The Source Systems tab is displayed.
The Register Source dialog displays.
Property | Description |
---|---|
Product Line |
Select the source instance product line. For Oracle Fusion sources, select Oracle Fusion. |
Product Line Version |
Select the version number of the source instance product line. |
Source Instance Name |
Specify a name for the source instance. This is the name given by the Oracle BI Applications System Administrator to a transactional system that serves as a source of data for Oracle BI Applications data load. The source instance is important because functional setup tasks, and the setting of values for objects such as parameters and domain maps are performed in relation to a source instance. |
Description |
(Optional) Enter additional information about the source instance. |
Data Source Number |
Enter a unique number to identify the source instance. The Data Source Number value specifies a data source so that the data can be identified in the Oracle Business Analytics Warehouse. Each source instance must have a unique Data Source Number.* |
Data Server |
For all sources except PeopleSoft sources, a read-only list of data servers is displayed. For PeopleSoft Enterprise sources, in the Data Server Details window, select the appropriate data server for the source instance. |
Note:
*However, ensure that this value is same in all (dev/testing/production) environments, else import/export of data fails with errors.Click Next. The Register Source in ODI Topology page is active.
The Global value is required because the Oracle BI Applications interfaces are designed to use this value.
Property | Description |
---|---|
ODI Data Server Name |
Specify a name for the ODI Data Server that indicates the transactional OLTP database (source database). This ODI Data Server Name must be unique across all ODI data servers in the ODI Repository. |
JDBC Driver |
The name of the JDBC driver for the transactional OLTP database (source database) connection. For Oracle Fusion sources, this property indicates the name of the JDBC driver for the Oracle BI Server. For example: Data from the Fusion Applications transactional system is retrieved from the Oracle BI Server. Oracle recommends that you use the default value. |
JDBC URL |
Specify the JDBC URL for the transactional OLTP database (source database) connection. The format for the URL is:
If your source is Oracle Fusion Applications on-premises, specify the JDBC URL for the Oracle BI Server. The format is
For example:
|
Database Username |
Specify the database user name for the transactional OLTP database (source database). For Oracle Fusion sources, specify the user name of the ETL user. This is the user created in Creating a User for ETL. |
Database Password |
Specify the password for the transactional OLTP database (source database). For Oracle Fusion sources, specify the password for the ETL user. |
Test |
Use this button to test the connection to the transactional OLTP database (source database). |
Property | Description |
---|---|
ODI Data Server Name |
Specify a name for the file system data server. This ODI Data Server Name must be unique across all ODI data servers in the ODI Repository. |
Host Name |
Specify the name of the host system where the file system (source files used for ETL) resides. This is the system to which you copied the source files in the procedure Copying Source Files. |
Path To File |
Specify the directory where you copied the source files in Copying Source Files. The directory path must include the appropriate source-specific folder for your environment. The source-specific folders are located in For example, if your source system is Oracle EBS 12.1.1, the directory path would be: SOURCE_FILE_HOME/biapps/etl/data_ files/src_files/EBS_12_1_1 |
Array Fetch Size |
The number of rows requested by ODI on each communication with the data server. This column may be hidden. To view this column, click View, Columns, Show All. |
Batch Update Size |
The number of rows in a single INSERT command. This column may be hidden. To view this column, click View, Columns, Show All. |
JDBC Driver |
Oracle recommends that you use the default value. This column may be hidden. To view this column, click View, Columns, Show All. |
JDBC URL |
Oracle recommends that you use the default value. This column may be hidden. To view this column, click View, Columns, Show All. |
This information is passed to ODI where the connections are created.
Note:
The connection details are not propagated to the ODI Repository until you have entered and saved the information on both the Register Source in Configuration Manager page and the Register Source in ODI Topology page.