Home / Q&A / All Questions

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.

Bulk Data load API
answered 11-04-2018 07:23:37 -0400

Hi Team, I am new to the denodo software. Can you please let me know the steps for bulk data load in denodo having a oracle DB source. Also let me know the things to take care while doing bulk data load using denodo. Also i would like to know what is...

Answers: 1

How to connect the Denodo Server to the Microsoft SQL Server who supports SSL?
answered 11-04-2018 04:11:40 -0400

The Denodo Server is trying to connect to the Microsoft SQL Server using JDBC. But, the MS SQL SERVER forces SSL encryption. The SSL encryption can not be turned off on the the server so turning off SSL is not an option. In that case, how to connect th...

Answers: 1

SQL Server MSSQL SSL SQLServer

Getting error while installing Denodo update denodo-vdp-v60-update-201802161101
answered 10-04-2018 12:34:32 -0400

Getting below error while installing Denodo update in my local VDP tool. Error : This update updates only the components of the Virtual DataPort module, but the target installation includes components from the module Aracne, ITPilot and/or Scheduler. ...

Answers: 1

Disable Localization
answered 10-04-2018 12:27:19 -0400

Is it possible to disable this feature? Currently this feature does more harm than help to me. We are dealing with time stamps calculated based on GPS and Denodo's help in this matter actually has unintended consequences. Thank you!

Answers: 1
Related to: Internationalization configuration and dates

Connecting Tableau to Denodo
answered 10-04-2018 08:26:22 -0400

How do we conenct tableau to denodo? When i select Denodo in Tableau it need inputs like Server : Port : Database: Authentication: Username : Password : Can someone tell me with example where do i get these details?

Answers: 1
Related to: Connecting Tableau Desktop to Denodo

ODBC Tableau Connectivity Tableau denodo with tableau

How to use substr / substring function to fetch last n characters of a string
answered 09-04-2018 23:43:31 -0400

In most databases we are able to fetch last n charaters using substr function in the following manner.... select substr('abcdefghij',-3) from dual; This returns the string 'hij' i.e the last three characters. How would I be able to do the same using De...

Answers: 1

substring

How to read values of array column without flattening it.
answered 09-04-2018 07:26:04 -0400

Hi team , I have an array column in my selection view which I want to use to make decisions based on the values in that array .For example I have array which has country codes . in my selection view I want to check - For a particular fund if that arra...

Answers: 1

work with arrays ; reading arrays

Hardware Requirements for VDP client
answered 09-04-2018 06:14:08 -0400

What are the Hardware Requirements for VDP client?

Answers: 1

VDP client

Aggregate Awareness
answered 09-04-2018 05:09:23 -0400

Not sure if this question belongs in this section, but I would like to know how Denodo handles aggregate awareness. Does Denodo have the ability to be configured logically to pull from a single fact table, but physically have multiple tables at differe...

Answers: 1
Related to: Data Virtualization and ETL

Aggregate query re-write

REST data source returning only text/plain
answered 09-04-2018 02:42:01 -0400

I am using Denodo 6. I am faced with a REST data source that actually returns text/plain only - application/json or application/xml is not offered. Probably the easiest approach is to create a Delimited File data source with a very uncommon delimiter, ...

Answers: 2

REST HTTP