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 September 2019.

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.

In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.

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

Availability of GET_ELEMENTS
answered 01-11-2017 05:14:49 -0400

Hi Team, Do GET ELEMENTS stored procedure works in all Denodo versions ? I use below: Denodo Platform 5.5 Denodo Platform 6.0 Denodo Express 6.0 Of these i get results only in Denodo Platform 6.0 In others I get error message: "Error execu...

Answers: 2

Stored Procedure

List of users info
answered 31-10-2017 09:06:00 -0400

We're using Oracle DB for Denodo. How to pull list of Denodo users from Oracle DB. Thanks

Answers: 1

Slow Response on Webservice.
answered 31-10-2017 08:19:49 -0400

I have a derived view ready and working, as well as an exposed REST service for this. I have a fairly large set of paramaters I can use to call this service or view(using execute). When I use the same paramters in the view, using execute query, it come...

Answers: 3

Creating Stored procedure in Denodo without eclipse
answered 30-10-2017 09:40:35 -0400

I am trying to create a simple stored procedure. i followed along the steps for eclipse, but when trying to publish it, i'm getting an error not supported by license. I did the same code using intelliJ IDEA and manually importanting depending jars. But...

Answers: 1

extention custom Stored Procedure

Unable to stop the Denodo Job in Scheduler
answered 30-10-2017 08:36:51 -0400

When we try to stop a job from scheduler. Below message was displayed Message : 1 Jobs were Stopped But able to see the job is still running in Scheduler. It didn't stop at all. Wht could be the reasons. Could you pls help on this.

Answers: 1