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.

Unable to start webcontainer
asked 18-01-2020 03:16:12 -0500

I am not able to deploy any web service. When I check the status of Webcontainer, it says OFF. WEBCONATINER START in VQL shell is unable to start. It says started but even after 30 minutes the status is still OFF. When I check the status: webcontainer...

Answers: 0

Manage outlier with Denodo
answered 17-01-2020 23:47:36 -0500

Good afternoon, how can I manage the outlier in Denodo. Verify that they exist and then be able to eliminate them. It is to say from a list of quantities I have values that are exaggeratedly high or exaggeratedly low that will interfere with my data....

Answers: 2

Replicate data automatically
asked 17-01-2020 23:20:12 -0500

Good evening, once I have virtualized a database how can I do to export the data from the tables again. In other words, if I have loaded some tables in the Denodo, the transactional systems continue to fill my database (tables), as Denodo can be conf...

Answers: 0

Error when run Ddenodo.launcher.excluded.jars
answered 17-01-2020 18:10:50 -0500

version: 7.0 OS: windows Error: When I run Ddenodo.launcher.excluded.jars on windows cmd,I saw '-Ddenodo.launcher.excluded.jars' is not recognized as an internal or external command, operable program or batch file. '-classpath' is not recognized as an ...

Answers: 1

How to get file modified date for an excel file in FTP location
answered 17-01-2020 17:47:30 -0500

We have defined some excel datasources that resides in a FTP server and Denodo BVs are created on top of them. We have a requirement to put the last modified/update date of each of the files (coming from different sources at different time). Is there a...

Answers: 1

File Modification Date

PHP ODBC Binding issue with numbers/integers
asked 17-01-2020 10:14:25 -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: 0

ODBC php

LIST_JDBC_DATASOURCE_TABLES - 'Error getting tables and views.'
answered 17-01-2020 08:53:55 -0500

Hello, I am attempting to perform some management/automation on Denodo and calling LIST_JDBC_DATASOURCE_TABLES on an mssql datasource and it is failing with 'Error getting tables and views' after getting through 971 rows of tempdb, and no other databas...

Answers: 2

Why do JDBC escape sequences give an error with the Denodo JDBC driver?
asked 16-01-2020 11:43:19 -0500

We are using SAP Business Objects Xi 4.2 to consume data from Denodo 7.0 using the Denodo JDBC driver. However queries generated by Business Objects that use a filter on a date object return an error. The SQL is generated with the following syntax in ...

Answers: 0

Create empty file if query does not return result
answered 16-01-2020 04:35:26 -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: 4

emptyresult

Denodo-Microsoft teams
asked 16-01-2020 03:13:05 -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: 0

Microsoft teams