Latest Activity


How to define multiple columns delimiters in denodo vdp Delimited File

Hi I want to know if its possible to define multiple columns delimiters while editing a DF datasource. The problem is than the file usually is delimited by ";" but sometimes it comes delimited by a ",". I read documentation and didnt find this issue.

vdp Delimited Files


connection error: Permission denied: connect

I have just installed Denodo 5.5 on windows 64 and as per the tutorial clicked on "vdp", started the server, then staretd the Virtual Data Port Admin tool and tried to login using info provided in the tutorial: Login: admin password: admin Server URL: ...

Related to: Error accessing views from VDP admin tool



HTTP Headers for an external REST service

We have to integrate with a SaaS HR system which exposes everything RESTfully. To search with a filter, I have to make a POST and pass in a JSON header according to their syntax. I have the following working so far as my header - this will create 2 r...



Database stored procedures

I was trying out Denodo Express (5.5) and see that they have added graphical support for stored procedures. I found through testing that I could create a base view from an Oracle function which took in a mandatory input variable and returned an inte...

VDP Stored Procedures


How can I simulate the "Search in index" functionality that exists in /webadmin/denodo-aracne-admin/aracne/indexer-data-management/search-engine?13&srv=2, but from within Denodo VDP?

I created a base view pointing at an aracne index and I can run this query: SELECT * FROM aracne_index WHERE content contains 'middleware' I can also connect to http://localhost:9090/webadmin/denodo-aracne-admin/aracne/indexer-data-management/search-...

vdp arachne search in index


Denodo VQL Server on linux & VDP Admin Tool from local computer has connection time out

Just installed and started up a denodo vdp server on a linux ec2 instance. Was using on local win desktop so semi understand the features and workflow. The vdp server is running on the linux box, appropriate ports are open and being listened on. No ...

VQL vdp connection


Not Sure of Error in VDP

Below is the error I recieved in the VDP and I am not sure what is wrong or how to fix it. The wrapper works fine in the ITPilot. Error executing query. Total time 5.156 seconds. QUERY [PROJECTION] [ERROR] QUERY [SELECTION] [ERROR] OH_CLERMONT_CO...

VDP Error Questionable


Missing Driver Creating New Data Source in VDP

When I attempt to create a new ODBC data source in the VDP there are missing drivers. The only Driver available via the drop down list is "SQL Server" I am attempting to create this for a "Microsoft Excel Driver (*.xls)". Please let me know if there...

Missing New ODBC VDP data Driver source


Denodo Express 5.5 VDP won't start

I have recently installed Denodo Express 5.5 on a Windows 7 machine at work. I run the Control Center as administrator and then go to VDP and try starting the server. The status changes to "Starting...", then the stop button appears, then the status...



Error Deploying Wrapper because of "regexp_like" in condition

I am having an issue deploying a wrapper that contains "regexp_like" in a condition for determining if each record that is iterated contains a firstname in the name column that is the same as entered at start. The "contains" function does not work as i...

VDP regexp_like ITPilot deploy