Q&A

You must sign in to ask a question. If you do not have an account, you can register here

We are excited to announce the availability of a new version of the Denodo Express 7.0 with new features and fixed issues starting in April 2018.

If you want to try it or if you want to migrate your current Denodo Express version you can download the brand new Denodo Express 7.0 at the Express home page in the Denodo Community

DAOVDBProxy executeDeferred error
answered 08-11-2017 06:51:29 -0500

We are trying to connect to Denodo from a JDBC client but are getting the below error - com.denodo.vdb.jdbcdriver.dao.DAOVDBProxy.execueDeferred(DAOVDBProxy.java:448) We verified that the jar files are the same on both client and server. Can you pl...

Answers: 1

JDBC Data Sources

command to move table from one folder to another folder
answered 06-11-2017 05:02:51 -0500

Hi , is there a command to move tables T from x folder to y folder? I am aware of following solutions but looking for solution something with command: Already known soltuions: export vql from folder x and modify the Folder to point to Y and impor...

Answers: 4

Switching from Denodo for AWS 5 data sources to unlimited sources
answered 03-11-2017 13:13:58 -0400

Hello, I would like to buy the Denodo Platform for AWS for 5 data sources. If one day I want to switch the version of unlimited resources, should I order a new AWS machine or I can change easily license somewhere ? Thanks, Emidio

Answers: 1

onpremise and AWS cloud

How many linux servers do you need for installation of the Denodo Platform?
answered 02-11-2017 13:05:16 -0400

I will have Aracne, ITPilot, and scheduler

Answers: 1

Denodo function for REGEXP_INSTR in Oracle
answered 02-11-2017 08:42:57 -0400

Need to search for the starting postion of a string that starts like FX......-......- where the . is a wildcard. How do I do this in Denodo Vql. In Oracle I would use REGEXP_INSTR

Answers: 1

ReST API Dynamic end point
answered 02-11-2017 08:39:35 -0400

I need to execute the First Endpoint and get the results Using the results of the First URL (ID) need to execute another call to get the corresponding data. First Call example https://company.data.com/api/metaproperties/ ID ABC CDE EFG Second Call e...

Answers: 1

REST API REST

best practice for user session variable/attribute
answered 02-11-2017 01:26:58 -0400

what is the best practice to pre-load/set a variable based on the active connection to Denodo? Is this done best by creating a custom function in Java, if yes can you provide an example containing SQL as below. use-case: query current user with his/...

Answers: 1

getsession roles

Import/Export objects from one environment to other environment
answered 01-11-2017 08:49:50 -0400

Hi Experts, Using export/Import of .vql we migrate from dev to QA. This will be a tedious task for following scenarios, I suspect I am not doing correct way, can you pls provide if any alternate way available? When we are migrating selective table...

Answers: 3

importing multiple vqls mass exports

PDF Data Extraction
answered 01-11-2017 08:16:06 -0400

I have data in PDF format which I need to convert into RDBMS or XML. Is it possible to add PDF as source in Denodo? Or What are the alternatives for it.

Answers: 1

PDF

Remove timestamp in date column
answered 01-11-2017 08:11:36 -0400

Hi All, I have a table\view in denodo with column as "createddate", below was the date format I am getting from this column. Tue Apr 21 13:53:52 EDT 2015 Tue Apr 21 13:22:12 EDT 2015 but i dont want time stamp and need in the below format. 2015-04-21 ...

Answers: 3