SAP DataServices --> Redshift (Amazon Wire Protocol Driver error) - Forum - DataDirect Connect - Progress Community

SAP DataServices --> Redshift (Amazon Wire Protocol Driver error)

 Forum

SAP DataServices --> Redshift (Amazon Wire Protocol Driver error)

  • Hi,

    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?

    Thanks

    DataService LOG

    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:

    ODBCINI=$LINK_DIR/DataDirect/odbc/odbc.ini

    LD_LIBRARY_PATH=$LINK_DIR/DataDirect/odbc/lib:/opt/Progress/DataDirect/ODBC_71_64bit/lib:$LD_LIBRARY_PATH

    export ODBCINI LD_LIBRARY_PATH

    Check out my world famous blog on data connectivity

  • Hi Sumit,

    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.

    docs.aws.amazon.com/.../odbc-driver-configure-linux-mac.html

    This is our LD_LIBRARY_PATH:

    /opt/Progress/DataDirect/ODBC_71_64bit/lib:/opt/java/lib:/opt/sap/dataservices/DataDirect/odbc/lib

    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.

    Check out my world famous blog on data connectivity

  • Thanks Sumit,

    I'm waiting and I am grateful for the help.