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

[kalpesh_pandey]

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,

[Henry_Banks · Accepted solution]

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/0d5ffbb6951b45778c1a90ffd...

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/b1bd4cc40a6f44829b2056173...

Regards,
H

[kalpesh_pandey]

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