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

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

DATA TYPES
answered 19-05-2017 07:57:46 -0400

For the NUMERIC data type how is scale and precision set, is there a default value or is it set by the user ? Also there max or min values for the criterias ? For the VARCHAR data type how is max_length set, is there a default value or is it set by th...

Answers: 1

How to change the Field type from Text to Date
answered 19-05-2017 06:13:56 -0400

Hi, I have a field having fieldtype as Date in base table in the format of "Wed May 17 00:00:00 IST 2017". But the timestamp it is showing is not correct. So when I tried to change it to get the correct timestamp, I tried using formatdate('MMM-dd-yyyy ...

Answers: 1

Cold-Backup activation
answered 19-05-2017 05:14:27 -0400

I understand that we can use a license for a cold-backup server for free. In that case, is the cold-backup license activated with IP adress like production server licenses? Kind regards,

Answers: 1

License

Need to use DataSource as excel and have the capability to edit it. Is it possible in Denodo?
answered 19-05-2017 05:07:35 -0400

I have requirement where i need to configure excel as data source and edit it to add/update/delete some rows from it as needed. is it possible in Denodo?

Answers: 1

#datasources

Supported structures and queries
answered 18-05-2017 09:07:09 -0400

Question 1: I am not being able to use "NOT NULL", "NULL" or "NOT" in the create statement for a materialized table. Is this beacuse denodo does not support this ? If this can be done can you send me an example to go by ? Question 2: I am trying to do...

Answers: 1

How to store password authentication and re-utilize again and again
answered 18-05-2017 08:32:39 -0400

Hi Team, I am connectining VDP with multiple data source in Linux. My data source are csv file , xml file and excel sheet While connecting I am using below SFTP method to connect sftp://10.223.66.228///home/denodo_admin/data_files/Client.csv sftp...

Answers: 1

automation

Where can I find the VQL for the following action in Denodo: Server Configuration menu --> Cache --> Cache Status = ON
answered 18-05-2017 08:21:19 -0400

Where can I find the VQL for the following action in Denodo: Server Configuration menu --> Cache --> Cache Status = ON? I need to create the VQL to turn ON the cache database's status to ON. Denodo allows this using mouse-click operations (Serve...

Answers: 1

Denodo Metadata store and checking in and checkout across different user
answered 18-05-2017 03:26:01 -0400

Hi Team, I am glad to know regarding below things in denodo. I have installed denodo on Linux Server and GUI on Windows Machine. I can able to access Flat files, DB source , and Web Services from Linux server trhough GUI . I have created sample fol...

Answers: 3

metadata store

Converting a Julian date stored in an Oracle DB as a NUMBER to a 'date' data type
answered 17-05-2017 10:22:56 -0400

Has anyone successfully implemented a function for converting a Julian date stored as a NUMBER in the RDBMS to a 'date' as used by VDP? I wasn't able to find any help. I found some imperative algorithms for doing so, but nothing easily converted to a d...

Answers: 2

Date Conversion VDP

Columns
answered 17-05-2017 08:54:24 -0400

how do I delclare a column as null or not null in denodo ? is this even possible ? If it is what is the syntax ?

Answers: 1