1. Administrator's Guide
  2. Integrating Data
  3. Loading Data
  4. Loading Data Using a Universal Data Adapter
  5. Defining a Universal Data Adapter in Oracle Database Integrator (ODI)
  6. Create a Data Server and Physical Schema for the Universal Data Adapter Source

Create a Data Server and Physical Schema for the Universal Data Adapter Source

This section describes how to create a data server and a physical schema for universal data adapters provided by Oracle Hyperion Financial Data Quality Management, Enterprise Edition (Oracle, MSSQL Server, MySQL, Teradata, and DB2).

To create a data server and physical schema for the Universal Data Adapter source:

  1. Start the Oracle Data Integrator Studio (ODI).
  2. From Topology, then Physical Architecture, and then Technologies, select the technology of the data server.

    Image shows data servers listed in Physical Architecture.

    For example, select Oracle or Microsoft SQL Server.

  3. Right click the data server, and then select New.

    Image shows how to select a new data server
  4. Enter the JDBC details for the external database.
  5. Right click the data server created in step 3, and then select New Physical Schema.

    Image shows how to select a new physical schema.

    Image shows how the Physical Schema definition.
  6. From Topology, then Logical Architecture, and then Technologies, select the technology for the logical schema.

    Name each logical schema as shown below for each of the database technologies:

    • Universal Data (Oracle)—UDA_ORCL

    • Universal Data (SQL Server)—UDA_MSSQL

    • Universal Data (MySQL)—UDA_MYSQL

    • Universal Data (Teradata)—UDA_TD

    • Universal Data (DB2)—UDA_UDB

    • Universal Data (DB2 400)—UDA_DB2_400

    • Universal Data (SAP HANA)—UDA_HANA


    Image shows how to select the New Logical Schema option.

    Image shows how to select the logical schema for the database technology.