Configuring Teradata Data Source for Oracle BI Under UNIX

Configuring Teradata Data Source for Oracle BI Under UNIX

Operating System: UNIX only.
Databases: Teradata only.

• This task is required if Teradata is to be configured as the only data source of the operationalapplication server.
• Before beginning the following procedure, you must know the following information:
• The default installation directory paths for Teradata on UNIX, as shown in the following table of Teradata installation default paths under UNIX.
• The IP address of the Teradata server.
• To configure Teradata as an application server data source
• Log on as a separate telnet session.
• Go to the directory OracleBI_HOME/setup.
• Using vi or another text editor, open the odbc.ini file and add the following section to odbc.ini:

Data Source Name=<Name of the DSN>
Driver=<Teradata ODBC driver Path>/drivers/tdata.[$libsuffix]
Description=NCR 3600 running Teradata V2R5.2r
DBCName=<Teradata Server IP Address>
LastUser=
Username=
Password=
Database=
DefaultDatabase=<name of target database or user>

NOTE: The string [$libsuffix] represents the library suffix appropriate to the specific UNIX
operating system you are using.

•  For example, for Solaris or AIX, use libnqsodbc.so; for HP-UX,use libnqsodbc.sl.

Example 1. The following is true:

• Teradata server is running on IP 172.20.129.42
• Teradata ODBC driver is installed at /usr/odbc
• Therefore, for Example 1, add the following section to odbc.ini:

[Terav502]
Driver=/usr/odbc/drivers/tdata.sl
Description=NCR 3600 running Teradata V2R5.2
DBCName=172.20.129.42
LastUser=
Username=
Password=
Database=
DefaultDatabase=<name of target database or user>

Example 2. The following is true:

• Teradata server is running on IP 172.20.129.42
• Teradata ODBC driver is installed on /usr/lpp/tdodbc

Therefore, for Example 2, add the following section to odbc.ini:

[Terav502]
Driver=usr/lpp/tdodbc/odbc/drivers/tdata.so
Description=NCR 3600 running Teradata V2R5.2
DBCName=172.20.129.42
LastUser=
Username=
Password=
Database=
DefaultDatabase=<name of target database or user>

NOTE: The DefaultDatabase parameter may be left empty only if you have checked the entry
Require fully qualified table names in the Repository Connection Pool for this Data Source.

• In the same file, in the section [ODBC Data Sources], add the following entry:Terav502=tdata.[$libsuffix]

Example: The new Teradata DSN is Terav502. Therefore, add the DSN entry to
odbc.ini:

[ODBC Data Sources]
AnalyticsWeb=Oracle Business Intelligence Presentation Services
SnowFlake=Oracle Business Intelligence Server
AutoSnowFlake=Oracle Business Intelligence Server
DimSnowFlake=Oracle Business Intelligence Server
DimSnowFlake=Oracle Business Intelligence Server
Star=Oracle Business Intelligence Server
Terav502=tdata.[$libsuffix]

NOTE: The string [$libsuffix] represents the library suffix appropriate to the specific UNIX
operating system you are using. For example, for Solaris or AIX, use libnqsodbc.so; for HP-UX,
use libnqsodbc.sl.

• Open up the user.sh script in the same directory and add the library path line to configure the Oracle BI data source, based on the operating system and shell.
• Using the Oracle Business Intelligence Administration Tool, open the Repository and add the new DSN you created as the Connection Pool Data Source Name for the appropriate physicaldatabases.
• In the example, add Terav502.
• Start the Oracle BI Server or, if it is running, stop and restart it.

Hope it Helps!!

Thanks,
Shanmugha Bharathy G B