Registering Source Systems and Propagating Connection Details to Oracle Data Integrator

Use this procedure to register a source system and propagate the connection details to Oracle Data Integrator.

To register a source system:

Note:

If you want to register the Fusion applications source, then follow the steps in Register the Fusion Applications Source.
  1. Launch Oracle BI Applications Configuration Manager using the URL http://<host>:<port>/biacm, and log in as the BI Applications Administrator user
    This user was created in the procedure Configuring Oracle BI Applications.
  2. In the navigation pane, select the Define Business Intelligence Applications Instance link, which appears under System Setups.

    The Source Systems tab is displayed.

  3. Click the Add icon.

    The Register Source dialog displays.

  4. Register the source in Configuration Manager, specify these properties.
    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 BI Applications System Administrator to a transactional system that serves as a source of data for 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.

    Note:

    However, ensure that this value is same in all (dev/testing/production) environments, else import/export of data fails with errors.

    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.

    Click Next. The Register Source in Oracle Data Integrator Topology page is active.

  5. Register the source in Oracle Data Integrator:
    1. Select Global from the Context drop-down list.

      The Global value is required because the Oracle BI Applications interfaces are designed to use this value.

    2. In the Technology: Oracle tab, specify these properties:
      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: oracle.bi.jdbc.AnaJdbcDriver.

      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:

      jdbc:oracle:thin:@<host>:<port>:<sid>

      If your source is Oracle Fusion Applications on-premises, specify the JDBC URL for the Oracle BI Server. The format is

      jdbc:oraclebi://<BI Server host>:<BI Server port>/PrimaryCcs=<Cluster Controller Host>;PrimaryCcsPort=<Cluster Controller Port>

      For example:

      jdbc:oraclebi://biserverHost:9703/PrimaryCcs=CCSHost;PrimaryCcsPort=9706

      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).

    3. In the Technology: File System tab, specify these properties:
      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 /biapps/etl/data_files/src_files.

      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.

    4. Click Save and Close.

      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 Oracle Data Integrator Topology page.