Accessing data from HANA DB

[former_member603982]

Hi,

We have an application that pulls metadata from different databases.

Typically, our application needs below details to connect to the database. Like...

• Hostname/IP Address
• Port Number
• SID
• Driver Name like Oracle JDBC driver
• Username and Password

Is there any way to pull HANA data catalog (metadata) in a similar way.

I know that we can export metadata to .csv file through SAP HANA Studio.

But I don't want data in .csv files. Please help.

Thank you.

Ravinder.

[lbreddemann · Accepted solution]

Yes, by providing the logon data (the items you mentioned) you can logon to the system and query the database catalog views (TABLES, VIEWS, SCHEMAS, etc.). These views are extensively documented in the reference documentation.

[former_member603982 · Accepted solution]

Thank you Lars Breddemann.

I can able to pull data from HANA DB.