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

Denodo Metadata
answered 06-05-2016 02:48:20 -0400

Does denodo has any metadata which holds vql for each and every view?

Answers: 2

Compare between two schema or databases
answered 04-05-2016 11:06:57 -0400

Hi, Is there a smart way to compare two schema or databases using denodo itself? Fro Eg, I have two versions of the same database say DB_v1 and DB_v2. I have added few more functionalities or logic correction / modification on top of DB_v1.vql and cre...

Answers: 1

database schema.sql tutorial

Issues starting Jetty
answered 03-05-2016 20:23:53 -0400

I extracted the Jetty folder from the tutorial zip and I get the following error when running java -jar start.jar: "Could not find the main class: org.eclipse.jetty.start.Main"

Answers: 6

Connecting
answered 03-05-2016 18:14:55 -0400

It says that Teradata database cannot be connected to because of license although Teradata is in the Driver dropdown. SQL Server is the only other thing in the dropdown. Does that mean that I cannot connect to an Oracle database with Denodo Express?

Answers: 1

JDBC Connection time out
answered 03-05-2016 04:16:18 -0400

I am not able to connect to mysql using jdbc ,it throws error of connection time out while saving datasource. Below is details ,Please help. Database adapter: mysql5 Driver class : com.mysql.jdbc.Driver Database url: jdbc:mysql://localhost:3306/acme_crm

Answers: 1

create or rename an aliass name
answered 02-05-2016 10:32:42 -0400

I want to create an alias name for the view i had select. Can you tell me if that is possible. And if so, how we can do that. An example for what i want: 1) new --> join 2) drag and drop a view called v_test 3) Then again drag and drop the same view ...

Answers: 1

alias

select top 2 * from table
answered 29-04-2016 21:39:06 -0400

Hi Team, Am looking for to query top few rows from the tables. I used below query select top 2 * from table . Please correct the query. Thanks Saraswathi C

Answers: 1

Select Query

data cleansing
answered 28-04-2016 17:50:08 -0400

has anyone figured out how to take source data and format it? for example i have phone numbers in my access data base that's in 2813339400 I want it to be in 281-333-9400, also sometimes the data is in (281) 839-6700 and I want to convert that to a c...

Answers: 2

data cleansing

Custom i18n map has no effect
answered 27-04-2016 05:38:38 -0400

The query: select now() CONTEXT('i18n'='nl_euro_cust2') Gives me the following result Tue Apr 26 18:38:47 CEST 2016 That's not what is expected. I expected this result: 26-04-2016 18:38:47 The content of the custom i18n map 'nl_euro_cust2' is as ...

Answers: 1

i18n

Can DV support History Data Migration?
answered 26-04-2016 11:33:46 -0400

Can DV support History data migration? scenario is the source systems are completely external to the customer system and cannot /may not be connected during working hours. so the customer wants to implement ETL to get the history and data on daily basi...

Answers: 1