Question Re: Create Connection to SQL Server on SAP Data Intelligence in Technology Q&A

Create Connection to SQL Server on SAP Data Intelligence

former_member759762 — Mon, 02 Aug 2021 03:38:31 GMT

Hi, I am trying to connect SAP Data Intelligence on Cloud to on premise SQL Server. Is there any prerequisite or something that need to be done? Like to Connect SAP Analytics Cloud to SQL Server need to configure SAP Analytics Cloud Agent and SAP Cloud Connector.

And Is there a reference or example to read data from sql server using SQL Server Consumer in SAP Data Intelligence Modeller?

Kindly Advise.

Thank you.

Re: Create Connection to SQL Server on SAP Data Intelligence

architectSAP — Mon, 02 Aug 2021 07:38:16 GMT

There are no prerequisites to connect SAP Data Intelligence to Microsoft SQL Server over its port being reachable, Agus. As an example, I describe how to Leverage your Advanced Data Migration metadata with Data Hub 2.4.

Best regards

Re: Create Connection to SQL Server on SAP Data Intelligence

former_member759762 — Mon, 02 Aug 2021 07:54:38 GMT

Hi Frank, Thank you for your answer. So, as long as the SQL server is allow access (white list) from sap data intelligence we can connect? Cause previously I have tried to connect SAP Analytics Cloud to MSSQL. And I need to configure SAP Analytics Cloud Agent and SAP Cloud Connector on HEC.

Re: Create Connection to SQL Server on SAP Data Intelligence

architectSAP — Mon, 02 Aug 2021 09:04:50 GMT

SAP Data Intelligence does not require agents on the to be connected systems. Best regards

Re: Create Connection to SQL Server on SAP Data Intelligence

former_member759762 — Mon, 02 Aug 2021 10:28:19 GMT

Well, thank you for your answer Frank.

Regards,

Re: Create Connection to SQL Server on SAP Data Intelligence

Lee — Thu, 30 Sep 2021 12:27:03 GMT

Hi Frank

Connect from DI for sql 2005? M SQL Server 2005/2008. For the connections, can see that Microsoft SQL Server (MSSQL) 2012 onwards are in DI version. Any suggestions on the approach ?

Regards

Leena Gopinath

Re: Create Connection to SQL Server on SAP Data Intelligence

Lee — Thu, 14 Oct 2021 18:42:41 GMT

hi agus

We were able to connect to azure SQL server. Just have to setup the connection management parameters. Host name, port , login credentials for the SQL database.
Regards

Leena

Re: Create Connection to SQL Server on SAP Data Intelligence

former_member541625 — Wed, 20 Apr 2022 09:02:05 GMT

What are the incoming port & outgoing port to open for this?