Siebel Analytics Installation and Configuration Guide > Configuring Siebel Analytics in the UNIX Environment > Configuring Siebel Server Data Sources (UNIX) >

Configuring Teradata Data Source for Analytics (UNIX)

This task is required if Teradata is to be configured as the only data source of Siebel Server.

NOTE:  The Siebel Analytics application must already be installed.

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.

   Add the following section to odbc.ini:

   [Name of the DSN]

   Driver=<Teradata ODBC driver Path>/drivers/tdata.so

   Description=NCR 3600 running Teradata V2R5.2

   DBCName=<Teradata Server IP Address>

   LastUser=

   Username=

   Password=

   Database=

   DefaultDatabase=<name of target database or user>

   Example 1.

   Assume the following:

• Teradata's server is running on IP 172.20.129.42
• The Teradata ODBC driver is installed at /usr/odbc

  You add the following section to odbc.ini:

  [Terav502]

  Driver=/usr/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>

  Example 2.

  Assume the following:

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

  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.so

   Example.

   The new Teradata DSN is Terav502. Therefore, add the DSN entry:

   [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.so

5. Open up 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.