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

[xiaoming_wu]

Hi Claudio,

I think you already checked the PAM document and see "Enterprise Edition required for real-time replication."
https://support.sap.com/content/dam/launchpad/en_us/pam/pam-essentials/TIP/PAM_HANA_SDI_2_0.pdf

Yes, mssql is supported as source through DP agent in DWC.

Best regards
Helen

[claudiorossi_sap]

Hi Helen

thank you for your answer. Yes , i see this PAM and regard this I have another question;

Now i have connected two MS SQL databases ( that are MS SQL SERVER EXPRESS EDITION ) to our SAP BW on premise with DB connect in RSA1 tcode and it work fine.

My question is : does DP agent support SQL SERVER EXPRESS EDITION or only enterprise edition as source DB system ?

as you write "Enterprise Edition required for real-time replication." , so my question is if i don't want to use realtime replication but only simple table reading can i technically connect this MSSQL database express edition to SAP DWC as source systems using SDI 2.0 ?

thnak you

regards

[xiaoming_wu]

Hi Claudio,
Yes, you can use it for batch loading.

Best regards
Helen