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.

Special character issue through SSIS.
answered 02-01-2018 10:27:20 -0500

Hi all, we are using DENODO DB as a source and trying to pull data to SQL server using SSIS2014. we are facing special charcters issue. special characters are appearing as junk charcters. PFB DENODO data and SQL server data. <img src="https://drive.goo...

Answers: 4

SSIS

Query to get internationalization of each view in denodo?
answered 29-12-2017 13:30:48 -0500

How to get internationalization type of each view in denodo using vql. In my scenario, Some has us_est and some has us_pst_pdt, za, ve, uy. I want to change the internationation of each object to us_pst_pdt. How to find objects using vql having interna...

Answers: 1

query to get i18 type

Page By/ Group By email Reports in Denodo Scheduler
answered 29-12-2017 07:24:23 -0500

Hi Team, If the view shows records in below tabular fashion: | Id | Name | Department | | 1 | John | Finance | | 1 | John | Accounts | | 2 | Maria | HR | | 2 | Maria | Facilities | | 3 | David | Legal | Is it possible to send seperate email reports ...

Answers: 1

DENODO Denodo Scheduler 6.0

How to Export data to CSV in Denodo?
answered 29-12-2017 06:15:38 -0500

I would like to export data from Denodo to CSV format. How can i do that?

Answers: 2

Huge volume of data in cache
answered 29-12-2017 03:33:28 -0500

Is it possible to load big volume of data (several TB tables) without causing a performance issue?

Answers: 2
Related to: Batch inserts in the cache and Scheduler

Cached Denodo view is slower than uncached view while fetching data from the tableau.
answered 28-12-2017 13:45:38 -0500

Hi, I have two views in Denodo. One is cached and another one is not cached. Both are having almost 3 crores records and 36 columns. In this scenario, when I fetch records in denodo such as find distinct cloumn in each table, I see it is taking almost...

Answers: 1

slow query

Connect Denodo view from python code
answered 28-12-2017 07:21:55 -0500

Hi Team, I am trying to access a Denodo derieved view from my python code. Which library do I need to import in my code? Could you also provide any sample snippet for the same?

Answers: 1

Denodo error when creating/updating view.
answered 28-12-2017 04:49:22 -0500

Hello guys. I faced with issue when trying to delete/update some derived view (and its base view/table/wrapper), the following logs are from denodo: 14460953 [RMI(30959)-10.111.111.222-4929] FATAL 2017-10-18T08:36:24.281 com.denodo.vdb.interpreter.ex...

Answers: 6

denodo

Error while creating Base View (incorrect expression)
answered 28-12-2017 03:55:34 -0500

Hi: When attempting to create a base view from a Delimited File, there is an error displayed for the regular expression ^. However this expression is used in the example. Can you please help me? I attach an image with the error https://imgur.com/a/s9Rc8

Answers: 1

Delimited Files delimited_files tuple