Share via

Is that possible to pull data from Sap Hana CDS View using Synapse Pipeline

Nermin Yehia 0 Reputation points
2023-08-09T12:49:23.0333333+00:00

Hey,

I need to Ingest data from the Sap Hana CDS view to my storage account using Synapse Pipeline and Sap Hana connector. Is that possible?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,380 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Bhargava-MSFT 31,261 Reputation points Microsoft Employee Moderator
    2023-08-09T18:45:41.3133333+00:00

    Hello @Nermin Yehia ,

    Welcome to the Microsoft Q&A forum.

    Sorry, I am not an expert on the SAP datasets, but per the below documents, you can use the SAP Hana connector by installing SHIR and SAP Hana ODBC driver to pull data from SAP Hana CDS views to the storage account.

    Prerequisites

    To use this SAP HANA connector, you need to:

    • Set up a Self-hosted Integration Runtime. See Self-hosted Integration Runtime article for details.
    • Install the SAP HANA ODBC driver on the Integration Runtime machine. You can download the SAP HANA ODBC driver from the SAP Software Download Center. Search with the keyword SAP HANA CLIENT for Windows.

    https://learn.microsoft.com/en-us/azure/data-factory/connector-sap-hana?tabs=data-factory

    https://techcommunity.microsoft.com/t5/azure-synapse-analytics-blog/extracting-sap-data-using-odata-part-7-delta-extraction-using/ba-p/2865383

    I hope this helps. Please let me know if you have any further questions.

    0 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.