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