KB47273: Configuring DataDirect Cloud ODBC Driver on Linux

Following are the steps to configure the DataDirect Cloud ODBC Driver on Linux:
 
1.       Modify the odbc.ini file located in the directory where the DataDirect driver was installed:

DataDirect Cloud=DataDirect Cloud 2.0


IANAAppCodePage=4
InstallDir=/home/rrahate/DataDirect/Cloud_for_ODBC_20
Trace=0
TraceFile=odbctrace.out
TraceDll=/home/rrahate/DataDirect/Cloud_for_ODBC_20/lib/ivtrc27.so


Driver=/home/rrahate/DataDirect/Cloud_for_ODBC_20/lib/ivd2c01.so
Description=DataDirect Cloud 2.0
Database= datadirectsalesforceDSN <Name of the data source created in DataDirect cloud>
DataSourceName= linuxtodatadirectconnetion
LogonID= <Enter the DataDirect cloud login id here>
Password= <Enter password for DataDirect cloud here>
ClientTimeZone=America/New_York <If this is left blank, it defaults to system time zone
Eg. America/New York
Note: The missing _ in New York will throw an error>
DataSourceUser=
DataSourcePassword=
ProxyHost=
ProxyPort=
ProxyUser=
ProxyPassword=
TransactionMode=0
WSRetryCount=3
WSTimeout=120
LogonDomain=
LoginTimeout=30
QueryTimeout=0
ApplicationUsingThreads=1
ReportCodepageConversionErrors=0 

 
2.       Add the following to the ODBC.sh file in the env subfolder located in the folder where Strategy has been installed.

#
#ODBC Driver for DataDirect Cloud
#

DataDirectCloud_PATH='/home/rrahate/DataDirect/Cloud_for_ODBC_20/lib' <Path of the Lib subfolder located in the folder containing the  DataDirect Cloud driver >

 
if ; then
                export DataDirectCloud_PATH
            
                mstr_append_path LD_LIBRARY_PATH "${DataDirectCloud_PATH:?}"
                export LD_LIBRARY_PATH
fi

 
3.       Modify the odbc.ini file located in the Strategy folder:

test=Strategy ODBC Driver for SQL Server Wire Protocol
DataDirect Cloud=DataDirect Cloud 2.0


Driver=/home/rrahate/DataDirect/Cloud_for_ODBC_20/lib/ivd2c01.so
Description=DataDirect Cloud 2.0
Database= datadirectsalesforceDSN <Name of the datasource created in datacloud>
DataSourceName= linuxtodatadirectconnetion
LogonID= <Enter the datadirect cloud login id here>
Password=<Enter password for data direct cloud here>
ClientTimeZone=America/New_York <If this is left blank, it defaults to system time zone
Eg. America/New York
Note: The missing _ in New York will throw an error>
DataSourceUser=
DataSourcePassword=
ProxyHost=
ProxyPort=
ProxyUser=
ProxyPassword=
TransactionMode=0
WSRetryCount=3
WSTimeout=120
LogonDomain=
LoginTimeout=30
QueryTimeout=0
ApplicationUsingThreads=1
ReportCodepageConversionErrors=0

 
4.       Copy the message files from locale\en_US\LC_MESSAGES located in the DataDirect Cloud driver folder into install\locale subfolder for Strategy.
 
5.       Copy the SSL certificates folder located in the DataDirect Cloud driver folder into install folder where you downloaded Strategy.