connecting to sybase databse in HANA Studio

[asthana_s76]

Hi Experts,

I have a requirement to connect to Sybase database as the source and HANA is the Target system. I have an idea to use ASE adapter to create remotes source. I need tables in my HANA DB. Question is: what privileges will be required to create a remote source in case Sybase is the source system. What should be the next steps once connection is established? Thanks in advance.

BR,

Saurabh

[jeffrey_kresse]

Hi Saurabh,

You can read about the adapter setup for ASE (including the needed ASE permissions) here: https://help.sap.com/docs/HANA_SMART_DATA_INTEGRATION/7952ef28a6914997abc01745fef1b607/c6217d9cb7204...

On the HANA side, you will need System Privileges: AGENT ADMIN (to create a dpagent registration), ADAPTER ADMIN (to add the ASE adapter to that agent), CREATE REMOTE SOURCE (to configure the connection for your ASE adapter). Once you create the remote source, next is to create a virtual table for some ASE object you wish to access from HANA, and test a query on that table.

Best regards,
Jeff K