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

DEN60EDU0104LAB04 - Create ds_support_site data source and import all procedures
answered 28-08-2018 12:39:21 -0400

Hi, I have found myself stuck on this lab in ondemand Data Virtualization Developer Introduction. Specifically: “ds_support_site” data source, create two base views over the stored procedures included in the PKG_SUPPORT_DB package: EDIT: How do I cre...

Answers: 3

ondemand

Create a Comma Seperated List (CSV) as part of query resultsL
answered 28-08-2018 03:55:24 -0400

Is it possible to convert a list of values into a csv string as part of query result? Ex: Customer | Item John | Glove John | Bat Desired output: Customer | Items John | Glove, Bat In SQL Server, i would use syntax like shown in this article. https:...

Answers: 1

VQL CSV

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

Talend

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

redshift

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 Active Directory #LDAP-ServiceAccounts

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