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.

How to get file modified date for an excel file in FTP location
answered 30-01-2020 11:26:17 -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: 2

File Modification Date

Is there a way to connect Denodo to Unix server non-interactively and use it as a data source
answered 30-01-2020 11:19:42 -0500

Hello, I need to connect Denodo to the specific folder on the Unix server, so I can use flat files as a datasource. Our security team only permits non-interactive login. Is there a way to connect Denodo to the Server non-interactive, and how that con...

Answers: 1

#connection #server #Unix

Unable to connect Azure Data Lake 2
asked 30-01-2020 01:43:45 -0500

Hi Team, My team is doing POC on data virtualization using Denodo via Azure portal. We required to get data from Azure Data Lake gen 2 and make base view on Denodo so that we can visualize our data using Power BI. As discussed with Mr. Himanshu Shriva...

Answers: 0

Denodo Scheduler authentication error
answered 30-01-2020 01:15:41 -0500

Hi, I can't execute a job in the scheduler because "dataSource 'PRE_CD2'. authentication error: The username or password is incorrect" I've configured in 'Data Sources > New Data Source > VDP' the PRE_CD2 which has the correct 'Connection URI' ...

Answers: 1

Fetching columns from denodo with space in column names through informatica bdm
answered 29-01-2020 21:08:34 -0500

While selecting columns with space in column names from denodo , informatica bdm is throwing error as such a column doesnot exist.

Answers: 1

Pass username and password with RESTful api.
answered 29-01-2020 19:20:34 -0500

when i am calling http://localhost:9090/denodo-restfulws/ from python request,porst() it throws a 401 not authorize error. how can i pass username and password here?

Answers: 1

REST API REST

Join with Excel data source
answered 29-01-2020 19:03:14 -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: 4

DATE / TIMESTAMP fields are not reflecting the i18n mapping change. Let us know if you need more info.
answered 29-01-2020 18:44:19 -0500

When applying custom i18n mapping to existing views and setting the custom i18n mapping as default we made these changes: To create custom I18N mapping CREATE MAP I18N i18n_us_est_custom ( ‘country’ = ‘US’ ‘datepattern’ = ‘MM/dd/yyyy’ ‘datesubtypepat...

Answers: 1

Denodo 7.0 Date Conversion i18n

From where can I install Apache Hive 2.0 JDBC Driver ?
answered 29-01-2020 18:35:19 -0500

Getting erorr: Unable to establish connection: The JDBC driver was not found. The Denodo Platform does not include the JDBC driver for this adapter. Copy the jar files of the driver to the folder "<DENODO_HOME>/lib-external/jdbc-drivers/hive-2.0...

Answers: 1

Hive apache hive hive 2.0

Denodo-Microsoft teams
answered 29-01-2020 10:45:58 -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: 3

Microsoft teams