question

NavinDondapati avatar image
0 Votes"
NavinDondapati asked PRADEEPCHEEKATLA-MSFT commented

SAP ECC or SAP S4 -Serverless Pool/SQL dedicated poool

Hi Guys,

Can we have direct connection to SAP ECC or SAP S4 to Server less pool or SQL dedicated pool in synapse? if so can you provide some article around it...

We know CData can do it
https://www.cdata.com/kb/tech/saphana-odbc-polybase.rst

azure-synapse-analytics
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @NavinDondapati,

Just checking in to see if the below answer provided by @VaibhavChaudhari helped. If this answers your query, do click Accept Answer and Up-Vote for the same. And, if you have any further query do let us know.

0 Votes 0 ·

Hello @NavinDondapati,

Following up to see if the below suggestion was helpful. And, if you have any further query do let us know.

0 Votes 0 ·

1 Answer

VaibhavChaudhari avatar image
0 Votes"
VaibhavChaudhari answered VaibhavChaudhari edited

Not sure if you can do that, but optional approach would be to use Data factory pipeline to copy data from SAP side to Azure data lake and consume the data in Synapse

I see, we can use ODBC driver while creating external data source for SQL server

https://docs.microsoft.com/en-us/sql/t-sql/statements/create-external-data-source-transact-sql?view=sql-server-ver15&tabs=dedicated#syntax

but its not available for Synapse SQL

https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-external-tables?tabs=hadoop#create-external-data-source


Please don't forget to Accept Answer and Up-vote if the response helped -- Vaibhav

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.