how to make SAP BW communicate with azure Databricks

Ram Babu 80 Reputation points
2023-10-31T04:41:26.1866667+00:00

Hi Team,

currently we are loading SAP BW data into azure storage and transforming data in azure databricks and stored into delta tables. i want to directly connect SAP BW to azure databricks.

If you can help with figuring out how to make BW communicate with Databricks that would be great.

Thanks

Azure Databricks
Azure Databricks
An Apache Spark-based analytics platform optimized for Azure.
2,534 questions
{count} votes

1 answer

Sort by: Most helpful
  1. KranthiPakala-MSFT 46,642 Reputation points Microsoft Employee Moderator
    2023-10-31T18:40:54.21+00:00

    @Ram Babu Welcome to Microsoft Q&A forum and thanks for reaching out here.

    Unfortunately, as per the official document connectivity to SAP is not supported as a source in Azure Databricks.

    Out of box connectors: Supported Data Sources in Azure Databricks.

    But you can explore JDBC connector to establish connection from azure Databricks as described in this article - Your SAP on Azure – Part 22 – Read SAP HANA data from Azure Databricks

    You can download the SAP JDBC Driver from here: ttps://tools.hana.ondemand.com/#hanatools

    Hope this info helps.


    Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.