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.

Attribute level business metadata
answered 09-03-2018 07:16:21 -0500

We have a external metadata repository with all of our business definitions. We assign a business definition to every field in the database/rest service etc. Is it possible to bulk import field descriptions from external sources? Can it be extended t...

Answers: 1

Metadata

Scheduler Data source change
answered 09-03-2018 07:05:58 -0500

Hi Team, Can you please let us know in which log we can capture any changes made at scheduler data source level ? Thanks

Answers: 1

Export Script for Changed Views(Delta)
answered 09-03-2018 06:48:36 -0500

Hi Team, I know we can have export script written which can take backup of complete virtual databases. I am looking to have a script which will only export Delta for those views or component which got changed after last export was run. Each view shou...

Answers: 1

ODBC Timeout.
answered 09-03-2018 06:19:52 -0500

I created a ODBC connection DSN to Denodo, using the Denodo ODBC driver, that is using a long running query. I had the timeout set and eventhough the query was still returning data, the connection timedout according to the setting. That is not the beha...

Answers: 1

ODBC

JDBC Connection Query "select 1"
answered 09-03-2018 06:16:49 -0500

We have some webservices setup to hit Hadoop Impala's JDBC connection. We are seeing "select 1" queries every minute for each of the webservices that we have setup. Is there a way to change the frequency of these queries (they are being fired off every...

Answers: 1

Denodo 6.0 JDBC

Alias name of view is something different
answered 09-03-2018 05:36:48 -0500

Hi Team, I have view in DB as DND_PRODUCER_SUMMARY_VW, just importing into Denodo, while importing, I changed capital name into small letters as "ud_producer_summary_vw' but when i see VQL for this base view. I am getting as below, my question is why a...

Answers: 1

Lookup - Informatica PowerCenter
answered 09-03-2018 05:31:32 -0500

I hear regular complaints from my ETL team that Denodo Views selected as lookup is not performing well, they had to move it as source qualifier. Do you have any recomendataions on this before i get more details from my team.

Answers: 1

lookup DENODO Informatica

Meaning of the join arrow's direction in a join view
answered 08-03-2018 08:11:48 -0500

When joining two or more views (as source) together in a join view, Denodo will draw an arrow between the tables. The arrow's direction seems to depend on how you "draw" the line, i.e. from which table you start. Is there any "deeper" meaning to this ...

Answers: 1

join

ER Tool integration
answered 08-03-2018 07:41:41 -0500

We use SAP Power Designer for our logical data modelling. It is possible to populate the VDP definitions from external metadata e.g. definitions of data sources, joing views etc?

Answers: 1

logical models

Denodo 6: VDP tool Connection error: Connection Refused
answered 07-03-2018 11:01:26 -0500

Hi I'm getting connection refused error while trying to login to VDP Client //localhost:9999/admin. I've confirmed that the port is open, vql server is also started (started from the client and from execution on .vqlserver.sh. Please let me know wha...

Answers: 1