topic Re: Changes in native SQL on Hana in Application Development and Automation Discussions

Changes in native SQL on Hana

balbino_soaresferreirafil — Thu, 07 Apr 2016 11:42:03 GMT

Hello!

Here in my company, we have a lot of native sql code to connect with a non SAP systems that uses oracle DB. This connections are made using db link on oracle.

In a document that I read said:


Native SQL statements embedded in OpenSQL or called via the ADBC interface must be migrated to HANA Native SQL or OpenSQL and with Netweaver 7.40 SP5 OpenSQL got extended, to help to convert native SQL to OpenSQL

On a scenario of switch on hana, how can I adapt this codes? How can I keep this connections? What yours suggest to do in this scenario?

Thank you all!

Re: Changes in native SQL on Hana

lbreddemann — Thu, 07 Apr 2016 17:10:31 GMT

This remark applies only if the target DBMS for the native SQL or the ADBC interface is a SAP HANA database.

If you switch your database on which your Netweaver stack runs and you used DBLINK before to connect to another Oracle DB, you now have to change the SQL code to confirm to SAP HANA SQL dialect.

Also, there is no DBLINK in SAP HANA - but you could use smart data access to achieve a similar integration.

Re: Changes in native SQL on Hana

balbino_soaresferreirafil — Fri, 08 Apr 2016 16:25:53 GMT

Thanks for the reply Lars, was very helpful.

Using the smart data access, I will need make any changes in my abap code, for exemple, can i keep the sql syntax for oracle, if the tables that I will use still in oracle? Or it will be transparent, needing only database configuration?

I say this, only in a scenario of connection with a non sap system.