Question Re: SQL Anywhere (Sybase) support for live or batch data load in Technology Q&A

SQL Anywhere (Sybase) support for live or batch data load

kalpesh_pandey — Sun, 31 May 2020 05:07:44 GMT

Hi, My client has SQL Anywhere DB. We have ODBC connection to connect to it. Now question is if SAP Analytics cloud supports SQL anywhere via ODBC to provide live connection or provide hourly load.

Thanks,

Re: SQL Anywhere (Sybase) support for live or batch data load

Henry_Banks — Mon, 01 Jun 2020 12:19:36 GMT

Hi kalpesh.pandey

SAC supports Import data from JDBC connection to SQLAnywhere

you can schedule this through the Cloud Connector via a Cloud Agent

here 's the help guide https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/0d5ffbb6951b45778c1a90ffd0114f04.html?q=sybase

there is a partner offering called Live Data Gateway by APOS which offers Live/Online (no data replication) for many types of sources inc SQLA

https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/b1bd4cc40a6f44829b2056173eb7d132.html?q=sybase

Regards,
H

Re: SQL Anywhere (Sybase) support for live or batch data load

kalpesh_pandey — Mon, 08 Jun 2020 03:34:01 GMT

Thanks. I see what to do. In the meantime I used PowerBI and within few mins, I could make it work without any file/config change. Just install a data gateway and few clicks online. Will check SAC next.

Thanks,

Kalpesh