Bookshelf v7.8.2: Configuring an Analytics ODBC Data Source Under UNIX

Configuring an Analytics ODBC Data Source Under UNIX

Analytics License: All licenses.

Operating System: UNIX only.

Databases: NQSODBC only.

The following task is required if ODBC is the only data source of Siebel Analytics Server. The task is part of the Roadmap for Configuring Siebel Analytics Platform.

Under UNIX, the file odbc.ini contains the standard or clustered Siebel Analytics ODBC connection details that are used by the Siebel Analytics Web Server and nqcmd processes.

To configure ODBC as the single Siebel Analytics Server data source

Log on as a separate telnet session.

Go to the Siebel Analytics installation directory /$INSTALLDIR/setup.

Open the odbc.ini file.

NOTE: The following table shows ODBC data source values for both the standard Siebel Analytics and the clustered Siebel Analytics configurations.

In the odbc.ini section [AnalyticsWeb], edit the name values as shown in the following table.

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.


Standard Analytics Values	Clustered Analytics Values
Data Source Name=ODBC Data Source	Data Source Name=ODBC Data Source
AnalyticsWeb=Siebel Analytics Server	AnalyticsWeb=Siebel Analytics Server
Driver=[client $INSTALLDIR]/Bin/libnqsodbc.[$libsuffix]	Driver=[client $INSTALLDIR]/Bin/libnqsodbc.[$libsuffix]
Description=Siebel Analytics Server	Description=Siebel Analytics Server
ServerMachine=local	ServerMachine=local
Port=9703	Port=9703
Repository=	Repository=
Catalog=	Catalog=
UID=	UID=
PWD=	PWD=
	FinalTimeOutForContactingCCS=7
	InitialTimeOutForContacting
	PrimaryCCS=1
	IsClusteredDSN=Yes
	PrimaryCCS=[Primary Cluster Controller Name]
	PrimaryCCSPort=9706
	SecondaryCCS= [Secondary Cluster Controller Name]
	SecondaryCCSPort=9706 NOTE: The primary CCS and secondary CCS should not be on the same machine.

	Regional=No