Changes in native SQL on Hana

[balbino_soaresferreirafil]

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!

[lbreddemann]

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.

[balbino_soaresferreirafil]

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.