Can we copy data from postgres (AZure Cloud) to SAP (Sink dataset)?

Lakshmi Narayana Sarma Bhamidipati 160 Reputation points
2023-09-25T13:15:58.7033333+00:00

Hi, Can you please let me know how to copy data from Azure PostgresSQL data to SAP database. This SAP is on target side. Thanks

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
Azure Database for PostgreSQL
{count} votes

Accepted answer
  1. Oury Ba-MSFT 20,931 Reputation points Microsoft Employee Moderator
    2023-09-29T17:19:04.8333333+00:00

    Lakshmi Narayana Sarma Bhamidipati

    SAP table doesn't support as sink. Please see the below document

    User's image

    https://learn.microsoft.com/en-us/azure/data-factory/copy-activity-overview#supported-data-stores-and-formats

    This is a limitation with ADF tool as of now. Please submit a feedback item if you are looking for SAP table as sink.

    See this similar feedback item: https://feedback.azure.com/d365community/idea/3f1f9b95-7126-ec11-b6e6-000d3a4f032c 

    The above feedback item is for- SAP BW and SAP HANA

    Regards,

    Oury

    1 person found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Lakshmi Narayana Sarma Bhamidipati 160 Reputation points
    2023-09-29T04:17:55.93+00:00

    Thanks for your answer. I m not getting the SAP connector on sink side. If SAP is a source, i am able to see the SAP connectors while creating the linked service but not on the SINK side.

    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.