The core reason you're currently unable to connect is most likely not due to a configuration error, but rather to the cloud provider not actually opening the ODBC port (due to security policy restrictions).

The next step is to confirm with them whether they support direct external ODBC connections. If not, you'll need to use the API, export, or proxy.