Connecting to SAP SQL Anywhere from GCP compute

[dheerajpanyam]

Connecting to most of the relational databases like Cloud SQL from serverless offerings is pretty straightforward using Cloud SQL auth proxy, GCP client libraries or direct private IP. 

SQL Anywhere is a 3rd party relational database from SAP. Connection via client libraries becomes non-trivial in this case meaning there is SQL Anywhere to be installed on the system, and the ODBC library requires the ODBC driver. My question is how can this be accomplished? Ideally want to use Cloud Run or even Cloud Functions (preferred since this needs to be event based)

[robertcarlos]

Hi @dheerajpanyam,

Welcome to Google Cloud Community!

As of the moment, you may only export data from SAP SQL Anywhere to Google BigQuery. You may check this documentation on how to export data from SAP systems to Google BigQuery through SAP Data Services.

You may also check out this documentation on SAP on Google Cloud for other SAP services that could be connected or deployed on Google Cloud.

I would also suggest filing a feature request so that our engineers could take a look at this. We don't have an exact ETA for this but you can keep track of its progress once the ticket has been created.

You can also reach out to SAP Support for additional assistance.

Hope this helps.

[dheerajpanyam]

@robertcarlos most of the 3rd party database vendors have a vpc peering setup with GCP maybe this is the solution here i don't know but the downside is the dependency on ODBC driver and downloading the SQL anywhere on the computer.

[dheerajpanyam · Accepted solution]

Thanks @robertcarlos