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.

PHP ODBC Binding issue with numbers/integers
answered 22-01-2020 06:23:18 -0500

Closely related to this question: https://community.denodo.com/answers/question/details?questionId=9060g000000TQpWAAW&title=ODBC+binding+parameters Binding any type of date, datetime, varchar or char seems to work. however when doing integer or d...

Answers: 1

ODBC php

Dynamic Source File Configuration with SFTP
answered 22-01-2020 05:20:43 -0500

Hi I am experimenting with a prototype for my organization thru Denodo Express Virtual Data Port. Here is my problem: 1) Daily files are deposited into sftp via batch upload. 2) I have configured the data source in denodo to point to the sftp but i...

Answers: 1

Technical Training material usage
answered 22-01-2020 05:10:34 -0500

Hello Denodo team, i went through on demand trainings,found it very helpful & informative. Now i want to use Denodo training study material for my team members & want to train them as well. just want to check if that's ok to use the same study...

Answers: 1

Training

Denodo-Microsoft teams
answered 22-01-2020 04:47:04 -0500

Hi, I am trying to connect Denodo with Microsoft Teams or Microsoft Sharepoint or OneDrive. The documentation given in the community does not solve my problem it just makes it more complicated.

Answers: 2

Microsoft teams

Join with Excel data source
answered 22-01-2020 04:45:21 -0500

Hi, Is there a way to optimize a join from Excel that has 1.7M registers with other one that has 25M registers. The problem here is it takes longer than 15 minutes so it times out. Any suggestions? Thank you, Best regards.

Answers: 2

Type of model in the join
answered 21-01-2020 19:20:43 -0500

The Denodo tool has the join function that allows you to join or integrate data from different sources, however, this works by means of PK (primary key) or FK (foreign keys), I would like to know what models are formed. In other words, it is a star mo...

Answers: 1

Tableau Server Version: 2019.2.2 can't connect to Denodo V7 using SSL
asked 21-01-2020 13:03:33 -0500

Hi, We can't seem to figure out what is causing Tableau Server to be unable to connect to Denodo V7 when the latter is in SSL. Anybody got a similar issue?

Answers: 0
Related to: How to connect to Denodo from Tableau Desktop

ODBC Tableau DENODO Tableau SSL pass-through

Create empty file if query does not return result
answered 21-01-2020 08:10:07 -0500

Is there some way to distinguish when we have an input empty file in the source or the file is missing? (sftp protocol with "flat file" data source) From our POV, the behaviour should be different: We are expecting to receive a delta file with "yeste...

Answers: 5

emptyresult

Error while creating Base View with Delimited Files
answered 21-01-2020 07:11:58 -0500

I'm trying to create a Base View with the information detailed in DEN60EDU0112LAB01 and everything works fine until I select the Create Base View, it gives me an error: "There was an error while creating this base view: Column names could not be genera...

Answers: 9

Delimited Files

TIMESTAMPDIFF
answered 20-01-2020 17:12:14 -0500

Team, How can we convert TIMESTAMPDIFF function. Eg:- TIMESTAMPDIFF(SQL_TSI_DAY, Date1,Date2) Can you please let me know in case of any idea on this ?

Answers: 2