ODI TOPOLOGY: Hide unused Technologies video

ODI HIDDEN DATA STORES VIDEO

ODI SIMPLE PASS MAPPING: ODI INTERFACE VIDEO

Creating ODI Data server

Hi Guru,

Today Let us discuss how to create the data server in ODI.

Data servers describe connections to your actual physical application servers and databases.

They can represent for example:

• A Teradata System
• An Oracle Instance
• An IBM DB2 Database
• An IBM DB2 iSeries Instance
• A Microsoft SQL Server Instance
• A Sybase ASE Server
• A Websphere MQ router
• A File System
• An XML File
• A Microsoft Excel Workbook
• etc.

Below is the definition of an oracle data server

 
           To create a Data Server we need the following prerequsites
1. Admin user name and password for the database server
2. jdbc url

For example i have oracle database installed in my local server ODIGURU

. Then in order to create dataserver for the local database i need the following

1. Database connection admin credentials

User name: system
password: sysdba

2. Database jdbc url

jdbc:oracle:thin:@ODIGURU:1521:orcl

where ODIGURU is the hostname of my database server
1521 is the port number
orcl is the database connect string

The following are the steps to create data server

Step-1 : open Topology Navigator expand the Technologies node in the Physical Architecture accordion.

step-2: Select the technology you want to create a data server for.

Step3: Right-click and select New Data Server



Give the following details in the Definition tab:

Name: ORACLE_DEMO
 the following naming standard is used to name the data server: <TECHNOLOGY_NAME>_<SERVER_NAME>.

Data Server: For Oracle, this name corresponds to the name of the instance, used for accessing this data server from another Oracle data server through DBLinks.

User/Password:
This parameter is not mandatory for all technologies, as for example for the File technology.
User name and password for connecting to the data server

for this example:

User name: system
password: sysdba


 

 For some connections using the JNDI protocol, the user name and its associated password can be optional if they have been given in the LDAP directory

Connection parameters for the data server:
Two methods:
1. A technology can be accessed directly through JDBC
2. or the JDBC connection to this data server can be served from a JNDI directory.
for this example:



Database jdbc url:

jdbc:oracle:thin:@ODIGURU:1521:orcl