SAP Knowledge Base Article - Public

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

Symptom

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    

and/or

Remote Tables: Unable to connect remote source: exception 2560000: Connection to host 'HOST_NAME:PORT' failed
exception 2112401: Failed to resolve hostname [HOST_NAME] with exception
exception 2050100: System call failed [addrinfo:-2]: Name or service not known
, Code: 5921, SQL State: HY000

Environment

SAP Datasphere

Resolution

As mentioned in SAP Help Portal Documentation: 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. 

Keywords

KBA , DS-DI-CON , Connections , Problem

Product

SAP Datasphere all versions