Solved

MS SQL Data Integration

  • 18 January 2022
  • 1 reply
  • 42 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 1

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