SAP Knowledge Base Article - Public

3317073 - Error "Unable to connect remote source: Connection to host & failed" occurs for Remote tables in Generic OData connection


When creating a new Generic OData connection, you get error for Remote tables:

Connection "CONNECTION_NAME" is valid, but not all features are available.
- Data flows are enabled.
- Replication flows are not supported.
- Remote tables can't be used because of errors in the connection.

Remote Tables: Unable to connect remote source: Connection to host HOST_NAME:PORT failed, Code: 5921, SQL State: HY000    


SAP Datasphere


As mentioned in SAP Help Prepare Connectivity for Generic OData:
"The OData service URL needs to be publicly available."

Therefore, make sure to use a public accessible OData URL for the Remote Table Replication. 


KBA , DS-DI-CON , Connections , Problem


SAP Datasphere all versions