SAP HANA Smart Data Access to Databricks SQL Warehouse

[ClaudiuSolar]

Hi

I'm currently looking into connecting to the SQL Warehouse through SDA/SDI. Does anyone have any experience doing so and can share some takeaways on how to implement it. We want to expose the Databricks tables to SAP. We're already doing this by using an Azure SQL Server, and we would prefer to switch.

Our current plan is:

1. Install the simba adapter on the server

2. define odbc connection

3. use that to connect through SDI

Another option would be to use the SDI Camel JDBC Adapter.

https://lingarogroup.com/blog/how-to-expose-azure-databricks-to-sap-on-the-fly

[ClaudiuSolar]

You can assume that the way to go is the Camel JDBC Adapter through the DP Agent Unified Analytics with SAP Datasphere & Databricks Lakehouse Platform- Data Federation Scenarios | S... 

[Anonymous]

Hi @ClaudiuSolar 

Thank you for posting your question in our community! We are happy to assist you.

To help us provide you with the most accurate information, could you please take a moment to review the responses and select the one that best answers your question?

This will also help other community members who may have similar questions in the future. Thank you for your participation and let us know if you need any further assistance! 

[ClaudiuSolar · Accepted solution]

SAP HANA SMART INTEGRATION

The official answer