SAP HANA smart data access gives you the power to expose data from remote sources as virtual tables in SAP HANA and also query supported remote sources directly without creating virtual tables using the linked database feature. This is a huge advantage compared to traditional ETL processes in many situations as it gives you a cost-efficient, easy-to-deploy option to get real-time data visibility across fragmented data sources.
Currently with the native SAP HANA smart data access adapters you can access a number of SAP owned data sources (e.g. SAP HANA, SAP ASE, SAP IQ…) as well as other 3rd party databases (e.g. Teradata, Oracle, MS SQL Server…). The complete list of currently supported SAP HANA smart data access adapters can be found in SAP NOTE 1868209 and also in the SAP HANA Administration Guide.
If you don’t see the version of the database/ database driver you would like to access on the currently supported list of SAP HANA smart data access connections, don’t fret. With this new SAP ICC Integration Scenario our partners will now be able to certify new versions of their databases for use with SAP HANA smart data access. Our goal is to be able to provide our customers with access to more remote sources than ever before.
What to do if you are a customer who would like to see support for a new version of a database/database driver?
- We encourage you to share the news about this new certification option with your database vendor. Let them know that you would like them to certify a new version of their database for use with SAP HANA smart data access and why this is important to you and your company.
What to do if you are a partner who is interested in certifying your database/database driver?
- Read more about the conditions of the certification and learn about the benefits of certification here: https://www.sap.com/documents/2017/08/90ccc067-d07c-0010-82c7-eda71af511fa.html#
- Apply for the official SAP Integration Certification: https://xs01a3cae2a65.hana.ondemand.com/sap/App/AppForm/index.html
We are currently equipped to certify new versions of the following databases/ database drivers:
- IBM DB2
- Microsoft SQL Server