3317073 - Error "Unable to connect remote source: Connection to host & failed" when validate Generic OData connection in Datasphere

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

Connection "CONNECTION_NAME" is valid, but not all features are available.
- 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

and/or

Data flows: can't be used. Please re-enter your credentials in order to establish connectivity for data flows.

SAP Datasphere

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. 

KBA , DS-DI-CON , Connections , HAN-DP-SDI-DS , SAP Datasphere specific SDI issues , Problem