information connecting a SQL Server DB to Data Warehouse Cloud

[#1]

Hi

In our infrastracure ( internal network ) we have a Microsoft SQL server Database that we need to connect to SAP Data wharehouse Cloud to read and import some table from SQL DB to SAP Datawharehoues cloud.

Can you confirm that it is technically possible ? Can you tell me wich agent and connector I need to install on premise to be able to do this without expose SQL server on internet and to be able to read Microsoft SQL DB data and import in sap data wharehouse cloud ?

thank you

regards

[XaviPolo]

As they said it is possible, but the configuration depends on whether you want: remote access to SQL Server or replicate data in real time.

In both cases you need the DPAgent installed on your network, but real-time replication requires some extra steps as it works through triggers.

Regards,