Product specifications

These can work with either DataDirect ODBC 6.0 SP2 driver or DataDirect ODBC 6.0 SP2 branded
driver.
You can find the DataDirect branded driver files in boe-install-dir/enterprise_xi40/platform-
name/odbc/lib directory, where boe-install-dir stands for the BI platform installation directory
and platform-name for the UNIX platform name.
Caution:
To use the branded driver, you must make sure the data access is configured correctly.
10.2.1 To enable the use of DataDirect branded drivers
Note:
The following section is only related to MS SQL Server 2005 SP2 and MS SQL Server 2008 databases.
Data Access supports the use of DataDirect ODBC 6.0 SP2 drivers for MS SQL Server databases on
all UNIX platforms. These drivers can be either non-branded or branded drivers.
The Connection Server default settings allow the non-branded ODBC driver to work seamlessly with
your current configuration settings. If you have already deployed a driver in your environment, you will
be able to install the non-branded driver without any configuration change.
1.
Navigate to the directory that contains the sqlsrv.sbo file.
On UNIX, this configuration file is located in the connectionserver-install-dir/connec
tionServer/odbc directory.
2.
Use an XML editor to open the sqlsrv.sbo file for editing.
3.
Locate the Defaults section.
The Use DataDirect OEM Driver parameter is set to No by default. This means the data access
is configured by default to work for non-branded drivers.
4.
Set the Use DataDirect OEM Driver parameter to Yes and save the file.
5.
Add the following path to LD_LIBRARY_PATH environment variable:
boe-install-dir/enterprise_xi40/platform-name/odbc/lib
6.
Configure the environment by editing the env.sh file in the boe-install-dir/setup directory
and source it.
For example:
DEFAULT_ODBCFILE="${BOBJEDIR}enterprise_xi40/"odbc.ini
Export DEFAULT_ODBCFILE
ODBC_HOME="${BINDIR}odbc"
Export ODBC_HOME
ODBCINI="${BOBJEDIR}enterprise_xi40/"odbc.ini
export ODBCINI
Note:
DEFAULT_ODBCFILE can point to any file which holds the connection details for the branded drivers.
7.
Configure the data source by editing the odbc.ini file.
2012-03-15118
Configuring data access driver parameters