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

[Yogananda]

claudiorossi_sap

Yes, it is technically possible to connect your Microsoft SQL server database to SAP Data Warehouse Cloud. You will need to install a connector on your premises and configure it to allow access from SAP Data Warehouse Cloud. The exact connector and agent will depend on the type of SQL server you are using, however some of the most popular options include SAP Data Services, SAP Replication Server, and Microsoft SQL Server Integration Services. You will also need to ensure that you have the appropriate security measures in place to ensure that your SQL server is not exposed to the internet.

[claudiorossi_sap]

I use MS SQL Server 2016

Sorry but I don't know the option you write,

I see in SAP documentation and seems that the connector is "Data provisioning agent" linked to this documentation ---> https://help.sap.com/docs/HANA_SMART_DATA_INTEGRATION/7952ef28a6914997abc01745fef1b607/d52c01c93e674...

Is it Correct ?

[Yogananda]

claudiorossi_sap

[claudiorossi_sap]

This Blog is to connect to an on premise Hana... I must connect to an on premise SQL Server.

Can you confirm that this right agent to implement ?

regards

[Yogananda]

claudiorossi_sap

yes that's correct.. DP agent is the right to connect and bring the data from MSSQL to DWC and since its 3rd party SQL server, we don't have any blogs written. If incase someone writes it, I will post it to this question again.

[claudiorossi_sap]

Hi Thank you for your answer

Another question: does DP agent support SQL SERVER EXPRESS EDITION as source DB system ? in my searches i found that only real-time replication probably is not supported, but the other way of read data from SQL SERVER EXPRESS EDITION for import in SAP DWC seems are possible because not denied.

Can you confirm this for sure is technically possible ?

regards