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 November 2018.

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.

Need Talend performance
answered 28-08-2018 02:29:56 -0400

We have a requirement where we are reading data from three different files and doing joins among these files with different columns in the same job. Each file size is around 25-30 GB. Our system RAM size is just 16GB. Doing joins with tmap. Talend is ...

Answers: 1


New JDBC Data Source in Scheduler for Redshift database
answered 28-08-2018 02:24:05 -0400

Hi , In Scheduler in Extraction section, when trying to create a new JDBC connection for Redshift database. In the field Database adapter no option for Redshift database selection. Can you help how to achieve the same. Thanks,

Answers: 1


Denodo Notebook feature
answered 27-08-2018 15:28:22 -0400

I saw Denodo has Notebook feature which are similar to Apache Zeppelin and Jupyter; however, I'm not able to get any information while trying to google it. Can someone tell me if this is only new in version 7 or we can use in version 6 and where I can ...

Answers: 3

Unable to establish connection: Internal error: com/mysql/jdbc/Driver : Unsupported major.minor version 52.0
answered 27-08-2018 13:24:35 -0400

I am using Denodo Express with 6.0 version and am trying to create JDBC data source connection for MySQL 5.5 but getting the below error:Unable to establish connection: Internal error: com/mysql/jdbc/Driver : Unsupported major.minor version 52.0 Trying...

Answers: 4

Pagination in Denodo 6.0 without ITPilot
answered 24-08-2018 18:59:40 -0400

Hello, I am facing an issue about pagination, since i only get the first set of records when connecting to my webservice. Checking in the help, i saw this is solved in Denodo 7.0 or with the ITPilot, however I just have a simple DEnodo 6.0 installation...

Answers: 1

from which Object class I have to create baseview to get AD group list
answered 24-08-2018 14:18:58 -0400

Denodo team replied me: "Since there’s no real way to distinguish between roles that were created by denodo or imported from LDAP once they’re in the system, the easiest way to achieve what you’re looking for is going to be to make a data source poin...

Answers: 1

AD group LDAP

Kerberos authentication and service accounts
answered 24-08-2018 11:50:39 -0400

We have denodo 6.0 installed in our company and configured to work with Kerberos. We have fond that it works well for all regular users and delegates credentials to databases just fine. Now, we have some services working under service accounts. For all...

Answers: 1

Kerberos #LDAP-ServiceAccounts Active Directory

Filtering between Current_Date and Current_Date - x days
answered 24-08-2018 10:49:12 -0400

I'm looking to filter a query by dates. The date (my_dt) within the table I'm pulling from is in the format yyyyMMdd but as type numeric and length of 8. So, what I'm trying to do is filter where my_dt is between a date that is x days ago from today an...

Answers: 1

Date Conversion Date

Identifying problematic data sources
answered 24-08-2018 05:31:58 -0400

Hi Team, Denodo 5.5 Is there any way to identify if any JDBC datasource has connection issues. Like - login fail, account locked, TLS/SSL issues etc. Instead of running each datasource and identifying which could have problem. Any web service or an...

Answers: 1

Data Source

Timestamp Millisecond issue
answered 24-08-2018 04:42:56 -0400

In my source date is ‘Fri Jun 16 04:05:55.25896 IST 2017’, while using formatdate getting ‘Fri Jun 16 04:05:55.258 IST 2017’ this date. I have missed the milliseconds after 3rd digits. How can i retrive all digits?

Answers: 1