/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PublicSymptom
On SAP Datasphere, connection validation for Amazon Redshift connections fails with the error:
Connection "KORE Redshift" is valid, but not all features are available. - Data flows can’t be used because of errors in the connection. - Replication flows are not supported. - Remote tables are enabled.
Data Flows: Cause: Open request could not be performed due to error: System call <LoadLibrary> to load and initialize functions failed for </usr/sap/flowagent/ds-lite/db_clients/redshift/libamazonredshiftodbc64.so>. Please make sure the shared library is installed and located correctly.
Environment
SAP Datasphere
Cause
Required driver was not uploaded.
Resolution
Upload the required drivers per Upload Third-Party ODBC Drivers (Required for Data Flows) | SAP Help Portal.
Keywords
Data Flow, Amazon Redshift, connection, validate, validation, library, driver , KBA , DS-DI-CON , Connections , Problem
/support/notes/service/facebook.svg)
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)