cancel
Showing results for 
Search instead for 
Did you mean: 

OPENQUERY command available for HANA?

Trinidad
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi HANA experts,

 

Do you know if OPENQUERY command is/will be available in HANA SQL?

One of our partners (SAP Business One) is currently using openquery in order to build reports where data from different databases (MSSQLServer, ORACLE) is mixed. They will like then to still build reports and Dashboards with data mixed between MSSQL, ORACLE and HANA.

Do you know if open query or an equivalent command could work with HANA?

Thanks for your help,

Trinidad.

Accepted Solutions (0)

Answers (1)

Answers (1)

paula_ditallo
Participant
0 Kudos

Maria,

Did you ever find an answer to this question?

lbreddemann
Active Contributor
0 Kudos

As far as I understand, OPENQUERY is the MS SQL Server version of having remote DB access.

That sort of functionality can be achieved via Smart Data Access (SDA) in SAP HANA.

See the documentation for details on that.

Just generally: it would be very helpful if you not only ask for a specific command but rather about what you want to do with it. Also, non-standard commands like OPENQUERY might not be known to people who are not used to your specific platform.