You can translate the question and the replies:

Connection with sql server database

Hi Team, I have to read one view from sql server database.How we can set up connection with sql database and can access view. Thanks in advance.
user
29-12-2020 04:46:43 -0500
code

1 Answer

Hi, In order to access Microsoft SQL server database from Denodo Platform, I would perform the following steps in Virtual DataPort Administration Tool: 1. Firstly, create a [JDBC](https://community.denodo.com/docs/html/browse/latest/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources#jdbc-sources) datasource by following the instructions provided in the similar Q&A mentioned [here](https://community.denodo.com/answers/question/details?questionId=9060g000000TQnaAAG&title=Error+connecting+to+SQL+Server). 2. Next, create a [base view](https://community.denodo.com/docs/html/browse/latest/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources#creating-base-views-from-a-jdbc-data-source) over it to be able to query this base view or combine its data with data from other views. Hope this helps!
Denodo Team
30-12-2020 00:52:28 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here