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

[murllimaraati]

MS SQL Server 2016 is supported by SAP DWC and in the DP agent you need to register MssqlLogReaderAdapter & then create a connection in DWC using Microsoft SQL Server. Once the connection is established you can create data flows

[claudiorossi_sap]

is MSSQL Express edition also supported by the DP Agent ? ( not for realtime replciation )

[murllimaraati]

Yes. It will support. I have not tried.. but i am confident it will support.

[claudiorossi_sap]

We hope.

is there any step by step guide to configure DPA for an MSSQL Server ? It is possible to configure only access from DPA to MSSQL Server DB to test the connection ( i still not have DWC tenant ) ? I have installed DPA Agent on my pc but i can't find a configuration console to do the configuration to connect to sql and test it

thank you !

[murllimaraati]

Hi,

Please follow the below link

https://help.sap.com/docs/SAP_DATA_WAREHOUSE_CLOUD/9f804b8efa8043539289f42f372c4862/ea69328fb328449a...

Best Regards

Murlli Maraati