Q&A

Rename a column in a view using VQL
answered 25-02-2022 07:30:36 -0500

Is it possible to rename a column in a view using vql? For instance, if I have a view that has the columns id, firstName, lastName - is there a way to use VQL to rename id to person_id? I know there is documentation for modifying a view: https://com...

Answers: 1

VQL column name Rename

Trying to connect to Oracle 19c database using oracle 11g driver
answered 25-02-2022 06:48:07 -0500

Trying to connect to Oracle 19c database using oracle 11g driver. Able to access the database using plsql developer but facing logon denied issue with denodo. Have access to the sid and database with that user.

Answers: 1

Data platform controller does not start VDP server
answered 25-02-2022 02:48:20 -0500

Hello, I have installed Denodo Express 8.0 on my macbook. When i launch the Denodo Platform Control Center and click on start for VDP server it does not work. Rest all option Data Catalog, Design Tool all start running but the server does not. I have ...

Answers: 12

Python Script to generate secret_key to connect tencent from Denodo
answered 25-02-2022 02:02:40 -0500

How to install python3 in Unix server and what is the python script to generate secret_key to connect tencent with Denodo

Answers: 1

API connection working but cannot paginate using a cursor key reference in the JSON response
answered 25-02-2022 00:53:13 -0500

I have a working API call that returns the first set of data without error (up to first 5000 records). However, when I try to set up pagination using a value in the end of the results it spins indefinitely. The token to use is called "cursor" at th...

Answers: 1

Pagination API

XtraFuncs firstdayofmonth
answered 24-02-2022 23:45:12 -0500

Where can I download the jar file with dependencies containing the code for the functions metionned in the Denodo XtraFuncs - User Manual? More specificaly the one for the firstdayofmonth function.

Answers: 1

XtraFuncs

Restoring metadata via server restore
answered 24-02-2022 07:15:44 -0500

Hello team, We are having issues with an import of our data on one of our servers, so we are planning to revert the servers to an earlier backup to restore data to how it was prior to the import we ran. In order to do so, we are simply restoring all d...

Answers: 1

rollback metadata restore

Getting a stored procedure via VQL
answered 24-02-2022 06:52:29 -0500

Is there a way to get the stored procedure for a view / table created in Denodo via VQL? For example, I have a view called 'p_raw_data' that is created using the following procedure: CREATE OR REPLACE VIEW p_raw_data FOLDER = '/0. raw data' AS SELECT ...

Answers: 1

VQL Denodo stored procedure

Separating the Tomcat web container from Denodo
answered 24-02-2022 01:43:47 -0500

Hi, I would like to ask the following questions: Is it possible to separate the Tomcat built in web container which comes by default with Denodo, to a separate server? If yes how and do you have documentation with the steps for that? Instead of...

Answers: 3

Error: 403 Authentication required
answered 24-02-2022 00:17:26 -0500

I am not able to download denodo installer. Its showing error 403 Authentication required. how to install it?

Answers: 1