KB46678: How to configure the DataDirect Cloud 2.0 ODBC Driver on Linux for connectivity to DataDirect Cloud

Follow the steps below to configure the DataDirect Cloud 2.0 ODBC Driver on Linux:
 
1.After downloading the required ODBC driver , follow the step by step instruction from the DataDirect Cloud driver Installation PDF
 
2. Modify the ODBC.ini  file located in the directory where the DataDirect Cloud ODBC driver was installed:

1. DataDirect Cloud=DataDirect Cloud 2.0
2. IANAAppCodePage=4
3. InstallDir=/home/rrahate/DataDirect/Cloud_for_ODBC_20
4. Trace=0
5. TraceFile=odbctrace.out
6. TraceDll=/home/rrahate/DataDirect/Cloud_for_ODBC_20/lib/ivtrc27.so
7. Driver=/home/rrahate/DataDirect/Cloud_for_ODBC_20/lib/ivd2c01.so
8. Description=DataDirect Cloud 2.0
9. Database= datadirectsalesforceDSN <Name of the data source created in DataDirect cloud>
10. DataSourceName= linuxtodatadirectconnetion
11. LogonID= <Enter the DataDirect cloud login id here>
12. Password= <Enter password for DataDirect cloud here>
13. 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>
14. DataSourceUser=
15. DataSourcePassword=
16. ProxyHost=
17. ProxyPort=
18. ProxyUser=
19. ProxyPassword=
20. TransactionMode=0
21. WSRetryCount=3
22. WSTimeout=120
23. LogonDomain=
24. LoginTimeout=30
25. QueryTimeout=0
26. ApplicationUsingThreads=1
27. ReportCodepageConversionErrors=0

3. Save and close the ODBC.ini file.
 
4.Add settings for enviorment variables by manually adding the following entry to the end of the <MSTR HOME>/env/ODBC.sh file:

1. # 
2. #ODBC Driver for DataDirect Cloud
3. #   
4. DataDirectCloud_PATH='/home/rrahate/DataDirect/Cloud_for_ODBC_20/lib' <Path of the Lib subfolder located in the folder containing the  DataDirect Cloud driver >
5. if ; then
6.        export DataDirectCloud_PATH
7.        mstr_append_path LD_LIBRARY_PATH "${DataDirectCloud_PATH:?}"
8.        export LD_LIBRARY_PATH
9. fi

5. Save and close the ODBC.sh file.
 
6. Create a DSN to DataDirect Cloud 2.0 by manually adding the following entry to the Strategy ODBC.ini file (this file is located in the Home Directory of the Strategy installation on Linux):
7.Save and close the odbcinst.ini file.
 
8.Copy the message files from locale\en_US\LC_MESSAGES located in the DataDirect Cloud driver folder into install\locale subfolder for Strategy
 
9. Copy the SSL certificates folder located in the DataDirect Cloud driver folder into install folder where you downloaded Strategy.
 
 
 
 
 
Third Party Software Installation WARNING
 
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.

• 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 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