SAP Knowledge Base Article - Preview

2878660 - DSConnectionManager connection to Amazon Redshift fails - Data Services

Symptom

  • Use the DSConnectionManager.sh to create an ODBC connection to Amazon Redshift and the connection test will fail.
    Error: "CON-120103: Initialization System call <LoadLibrary> to load and initialize functions failed for <InstallDIR/lib/libodbc.so.2>. Please make sure the shared library is installed and located correctly."
  • Use the DSConnection/connection_test.sh to test the ODBC connection and the following errors will occur.

    Error: "CON-120307: Initialization ODBC call <SQLConnect> to connect database <Amazon Redshift ODBC DSN> failed with error: <ODBC call <SQLConnect> for data source <Amazon Redshift ODBC DSN> failed: <[Amazon][ODBC] (11560) Unable to locate SQLGetPrivateProfileString function.>"

    Error: "CON-120103: Initialization System call <LoadLibrary> to load and initialize functions failed for <InstallDIR/lib/libodbc.so.1>. Please make sure the shared library is installed and located correctly."
  • Amazon Redshift ODBC variables are correctly defined.


Read more...

Environment

  • SAP Data Services
  • Linux

Product

SAP Data Services 4.2

Keywords

KBA , EIM-DS-CON , Connectivity , EIM-DS , Data Services , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.