You can translate the question and the replies:

Connecting to Microsoft SQL Server

Can you guys show the steps on how to connect to Microsoft SQL Server to import data and to virtualize it in Denodo? Like how you guys did in the link attached below for MySQL. And currently I am using Denodo 7.0 (which is the latest version), but the latest Microsoft SQL Server version that it connect to it is 2016. Why not include 2017 or 2018 or 2019 as I am using Microsoft SQL 2019? https://community.denodo.com/tutorials/browse/basics/2fs5jdbc
user
26-11-2019 03:19:37 -0500

1 Answer

Hi, I have an instance of Microsoft SQL Server 2017 and to connect to it I use the Microsoft SQL Server 2016 adapter and they work perfectly fine. To configure a JDBC Data Source to a Microsoft SQL Server 201X database I would follow the instructions in our documentation page [JDBC Sources](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources). The steps are exactly the same for JDBC connection, just changing the adapter, driver and Database URI. Adapters are only included when enough direct testing has been made but this does not mean that newer versions will not work. Usually changes between versions are minor and older adapters work perfectly fine. For Microsoft SQL Server Denodo already includes both the MS Driver and the JTDS so you just have to pick the desired one from the dropdown menu and both Driver class path and Driver class fields will be automatically filled for you. Just put the URI to your database following the template (in case you do not know the port by default it is 1433) and the appropriate credentials. Hope this helps!
Denodo Team
26-11-2019 15:59:07 -0500
You must sign in to add an answer. If you do not have an account, you can register here