I'm testing the Progress DataDirect Connectors for Redshift database as data target. But I have some problems in the driver's use.
We are using SAP 4.2 DataServices as ETL tool, running on Linux x64 environment.We made all installation by following the guides of Progress (http://documentation.progress.com/output/DataDirect/jdbcinstallhelp/index.html)
and can connect perfectly into the Redshfit using SQL tools (SQL Plus and ISQL) on the Linux console using ODBC connection.
However, when I try to make a connection through SAP BO DS tool some mistakes happen as below (ODBC Connection):
System call <LoadLibrary> to load and initialize functions failed for </opt/Progress/DataDirect/ODBC_71_64bit/lib/ddrsft27.so>.
Please make sure the shared library is installed and located Correctly.
The installation is correct and the bods configuration files are also configured.
Does anyone have any idea what might be happening?
DS ERROR LOG
The most common cause for these type of errors is due to ODBC environment settings picked up by the DS job.
Here's an article on configuring DataDirect drivers with BODS: wiki.scn.sap.com/.../To configure DataDirect ODBC on Linux and Unix
For Redshift, you would need to add /opt/Progress/DataDirect/ODBC_71_64bit/lib to the LD_LIBRARY_PATH
For example, add the following environment settings to the session running the job service:
export ODBCINI LD_LIBRARY_PATH
Check out my world famous blog on data connectivity
We follow all the steps from SAP Configuration guides as you send, so that we can properly setup ODBC distributed directly by Amazon Redshift, and the driver works well. The only problem of Amazon driver is that it does not have the expected performance. Writes about 5 records per second on RedShift.
This is our LD_LIBRARY_PATH:
The problem remains the same.
Thanks for the feedback. I am checking with the tech team supporting your evaluation next so we can establish a successful POC for you.
I'm waiting and I am grateful for the help.