Siebel Analytics Platform Installation and Configuration Guide > Configuring the Siebel Analytics Data Sources >

Configuring Teradata Data Source for Analytics Under UNIX

Analytics License: Analytics Applications only.

Operating System: UNIX only.

Databases: Teradata only.

This topic is part of the Roadmap for Configuring Siebel Analytics Platform.

This task is required if Teradata is to be configured as the only data source of Siebel 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.

  Platform	Default Installation Path
  Solaris, HP/UX	/usr/odbc
  AIX	/usr/lpp/tdodbc

• The IP address of the Teradata server.

To configure Teradata as a Siebel Server data source

1. Log on as a separate telnet session.
2. Go to the Siebel Analytics installation /setup directory.
3. 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.

4. 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=Siebel Analytics Server

   SnowFlake=Siebel Analytics Server

   AutoSnowFlake=Siebel Analytics Server

   DimSnowFlake=Siebel Analytics Server

   DimSnowFlake=Siebel Analytics Server

   Star=Siebel Analytics 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.

5. Open the user.sh script in the same directory and add the library path line (based on the operating system and shell) to configure the Siebel Analytics data source, as shown in the following table of library path commands:

   Operating System	Shell	Library Path
   AIX	Korn Bourne bash	LIBPATH=$LIBPATH:/usr/lpp/tdodbc/odbc/drivers:/usr/lpp/tdodbc/odbc/ lib export LIBPATH
   	C	setenv LIBPATH $LIBPATH: /usr/lpp/tdodbc/odbc/drivers:/usr/lpp/tdodbc/odbc/lib
   Solaris	Korn Bourne bash	LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/odbc/drivers:/usr/odbc/lib export LD_LIBRARY_PATH
   	C	setenv LD_LIBRARY_PATH $LD_LIBRARY_PATH:/usr/odbc/drivers:/usr/odbc/lib

6. Using the Siebel Analytics Administration Tool, open the Repository and add the new DSN you created as the Connection Pool Data Source Name for the appropriate physical databases.

   In the example, add Terav502.

7. Start the Analytics server or, if it is running, stop and restart it.