Solved

MS SQL Data Integration

  • 18 January 2022
  • 1 reply
  • 61 views

We are trying to connect to our server, which is Microsoft SQL. However, it is only offering the URL option as opposed to connecting via an IP address. Can anyone pleaseĀ help?

icon

Best answer by Jan Kos 18 January 2022, 19:31

View original

1 reply

Userlevel 2

Hello Steve,

Ā 

you would need to create connection URL in your Microsoft SQL server environment:

https://docs.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url?view=sql-server-ver15
Ā 

The URL should be in this formatĀ jdbc:sqlserver://<host>:1433
Then you can add this URL toĀ the datasource connection details. For more information about Microsoft SQL datasource connection feel free to also check:

https://help.gooddata.com/start/integrate-a-data-source-for-a-data-warehouse-81961942.html#IntegrateaDataSourceforaDataWarehouse-MicrosoftSQLServer

Ā 

-Jan

Reply