ODI - Data Server (Data Source)

Card Puncher Data Processing

ODI - Data Server (Data Source)

About

Data servers describe connections to your actual physical application servers and databases. They can represent for example:

  • An Oracle Instance,
  • A File System,
  • An XML File,
  • A Desktop database such as Microsoft Excel Workbook,
  • an application such as SAP or Salesforce
  • JMS server instance,
  • a scripting engine

Under this data server, subdivisions called Physical Schemas are created.

Recommendation: if you have a single system (Oracle, …), only one data server must be created. Having 2 data servers defined pointing to a single physical data server may cause extra loading phases that are not needed

Creating a Data Server

Naming convention

Oracle recommand that you prefix any data server name with the technology it belongs to. The name should be a meaningful name such as the one used usually to reference this server. Put the name in uppercase.

_

Example:

  • TERADATA_EDW
  • ORACLE_CRM_DEV
  • DB2UDB_SFA_TST1
  • XML_CLIENT001
Connection user

Some privileges are required when you run knowledge module. You must refer to the requirement section of the description.

Example with a RKM Oracle

REQUIREMENTS
	Required privileges for the connection user: SELECT on any dictionnary view ALL_* (eg. ALL_TABLES)

Then you must give it:

 grant select any dictionary to ODI;
For Oracle

An Oracle Data Server corresponds to an Oracle Database Instance connected with a specific Oracle user account. This User will have access to several schemas in this instance, corresponding to the Physical Schemas in Oracle Data Integrator created under the data server.

Get your connection parameters and populate the windows with this values.

Odi Topology Create Data Server

You can test your connection using a pure JDBC client such as Squirrel-sql which is shipped and installed by default with ODI

The test button is only to test JDBC connections and will then fail for products like essbase/planning.

When you create a data server, the physical schema windows appear automatically.





Discover More
Odi Oracle Reverse Def
ODI - Reverse-engineering Oracle

for Oracle create a context create a physical data server and its physical schema create (if not define in the physical schema) a logical schema You have two type (two ways) to reverse...
Odi Topology Create Physical Schema
ODI - The physical schema

When you create a data server, the physical schema windows appear automatically or right click on a data server, insert a physical schema. Fill in: the schema the work schema. ODI Knowledge Modules...



Share this page:
Follow us:
Task Runner