Q&A

VDP Server will not start due to a data source connectivity problem
answered 18-03-2020 20:31:21 -0400

We cannot get our VDP server to start at the moment. We have a datasource connected to a SQL Server DB where the external security on the host has changed to SSL, so I'm pretty sure in the Denodo driver settings I need to set SSL to 'On' but I'm not ab...

Answers: 1

Unable To Create Base View
answered 18-03-2020 08:32:34 -0400

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. Pleas...

Answers: 3

Error Baseview

Denodo Azure/PowerBI Cloud service with cloud and on-premise data sources
answered 18-03-2020 07:20:34 -0400

I am looking into Denodo on Azure and PowerBI service (cloud) as primary data consumer with data sources on premise and cloud (Azure). What is required for Denodo Azure to connect to on-premise datasource?

Answers: 1

Not able to off the execution plan
answered 18-03-2020 05:51:17 -0400

Hi, I have created a derived view dv1 and on top of that i have created another derived view dv2. Now the problem is i did specify execution plan in dv2 from options tab. But as soon as i off the specify execution plan and open it again it automatic...

Answers: 1

Execution plans

How to handle the Register and Array when using XML datasource? Please explain me if my xml source has more hierarchicals
answered 18-03-2020 05:40:09 -0400

Denodo 6.0 and Windows 10 OS

Answers: 3

XML Data Source

Remote table Creation
answered 18-03-2020 04:43:23 -0400

Hi All, I am trying to create remote table in VQL shell and it gives syntax error between Create and remote Please help me to create a remote table in mysql already enabled the bulk data load api and mysql varaible local_infile to on Not able to see th...

Answers: 2

remote table

How to connect from Azue Blob storage(Parent folder) to Denodo
answered 17-03-2020 11:06:20 -0400

Hi, I was doing some POC over the connection from Denodo to Azure Blob/DataLake Storage. I am able to connect a particular csv file from Azure Blob to Denodo but my need is to connect a folder having multiple files instead of having multiple connectio...

Answers: 1

No Option of "Create Missing VQL Properties " in solutions manager
answered 17-03-2020 07:44:41 -0400

Hello, I am trying to Deploy a webservice I have created in QA to Prod. When I am trying to Deploy it, is failing with the error of "Missing VQL Properties". When researched on this, according to the link pasted below we can use the "Create Missing VQ...

Answers: 3

SolutionManager Missing Deployment using Solution Manager Best Practice Password

Configure third party application with denodo and execute the job from application and export the data into csv
answered 17-03-2020 07:42:20 -0400

Hi, We have a java application which is configured to our database. Whenever we invoke an job in our application it goes to respective table inside the database and run the job and pull data into our application. Now we are planning to put denodo in b...

Answers: 5

Connecting to an external web service Java Procedure Denodo 5.5 extraction Denodo Excel Add-In Denodo Testing Tool REST Webservice

Single WS call needs to execute 2 separate update statements.
answered 17-03-2020 07:34:14 -0400

hi there I have a single web service call that needs to execute 2 store procedures on 2 separate sql services. Is this possible? Thank you in advance. Regards

Answers: 3

REST API Denodo Testing Tool REST Webservice REST Webservice