CDS view approach to connect HANA as secondary database

CDS view approach is maybe the safest approach while connecting to a secondary HANA database. If there is a safer approach it would be using directly OpenSQL. However there are cases where OpenSQL is not enough to cover all the states. So CDS technique becomes the only option to connect secondary HANA.
If you are familiar with CDS , you will see that it brings many facilities including expressions,authorizations, annotations etc. Moreover CDS seems the most powerful tool to use HANA capabilities. Finally usage of CDS with HANA is same as OpenSQL usage: you just have to add a connection string to your SQL statement. The difference of CDS could be development environment as of now SAP GUI does not support CDS usage but the only way is using Eclipse. Below i am sharing a very simple CDS with a HANA connection string.


Eclipse/SAP GUI


You may also like