You can translate the question and the replies:

Unable To Create Base View

Dear all, Hi, i have an prablem on my local server especially denodo server. I just add new connection from APS (sql server) and tried to create base view, but i can't directly create base view so i must create base view from query and working. Please check error below 1. Connection - https://imgur.com/3NBNN9P 2. Retreiving Table - https://imgur.com/6OTkeXS 3. Error Details - https://imgur.com/1hiFWWp Thanks
user
08-03-2020 22:35:09 -0400

3 Answers

Hi, I have come across the same issue when I mistakenly use the Microsoft SQL Server adapter for the Azure SQL Data Warehouse data source. After using the correct adapter(i.e., Azure SQL Data Warehouse) the above error is resolved. To analyze the root cause, I would modify the Virtual DataPort log level as “Debug’’ in **<DENODO_HOME>/conf/vdp/log4j2** and check for the possible causes in the vdp.log file in** <DENODO_HOME>/logs/vdp**. For more information, you could refer to the section [Log Configuration](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/appendix/configuring_the_logging_engine/configuring_the_logging_engine) of the Virtual DataPort Administration Guide. If you are a user with valid support access and still facing any error, I would suggest you raise a support case in the [Denodo Support Site](https://support.denodo.com/). Hope this helps!
Denodo Team
09-03-2020 08:15:37 -0400
Thanks for the update. So we need a support adapter / driver for APS (Analytics Platform System) to solve this issue? Do you have reference? Thanks
user
11-03-2020 05:34:31 -0400
Hi, To connect the Analytics Platform System from Virtual DataPort, I would check with Microsoft for the version of SQL server which is compatible with the Analytics Platform System for connectivity, and then use the same adapter in [JDBC](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources) data source to connect from Virtual DataPort to Analytics Platform System. Hope this helps!
Denodo Team
18-03-2020 08:32:34 -0400
You must sign in to add an answer. If you do not have an account, you can register here