Home / Q&A / All Questions

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.

number of rows for all views
answered 22-11-2018 06:50:19 -0500

Hi Team, Denodo 5.5 Is this possible to achieve ? For a given view get number of rows for it and all it component views. This means as- Final View - FV1 - 1000 rows Derived View - DV1 - 5000 rows Derived View - DV2 - 7000 rows Base View - BV1 - 800...

Answers: 3

rows

TRIM function on base View Column
answered 22-11-2018 04:47:34 -0500

Would it be possible to do have Trim function on column in a base view. I know we can do it at datasource level by checking " Ignore all trailing spaces". But here I want to TRIM single column on a base view.

Answers: 1

Denodo version 7.0 Solution Manager - Cluster
answered 21-11-2018 15:09:32 -0500

Hi, In our solution manager we have created a prod cluster(have 4 nodes). we not sure how this works (the manual on denodo site doesn't help much) and please clarify this for us How do we know or see that the system is successfully in a cluster? ...

Answers: 1

Rename an existing Data Source
answered 21-11-2018 06:51:27 -0500

I have Version 6.0 Update 20180628 installed at my company (both Client and Server) I would like to rename an existing Data Source. Can I do this on my version (6.0.20180628) ? If so, how do I do this?

Answers: 1

Data Source

Monitoring mechanism for Denodo RESTful web services
answered 20-11-2018 18:48:12 -0500

There is a third party tool which consumes Denodo RESTful APIs, if any API goes down or not available then how to tract it. Is there any monitoring mechanism for RESTful web services in Denodo?

Answers: 1

API #HTTP #Post #Rest_API #webservice

ERROR while executing a job in scheduler
answered 20-11-2018 14:11:50 -0500

P_ALL_USERS_AMERICAS [PROJECTION] [ERROR] ALL_USERS_AMERICAS [BASE] [ERROR] ALL_USERS_AMERICAS_4884 [LDAP WRAPPER] [ERROR] ALL_USERS_AMERICAS_4884#0 [LDAP ROUTE] [ERROR] Received exception with message '162.116.244.21:3268' What does the above error m...

Answers: 1

LDAP Denodo Scheduler 6.0

how to mask data based from source to all base views created from that source ?
answered 20-11-2018 12:22:02 -0500

Hi, we created 2 base views from wich are created a Selection. is it possibile to use restriction on certain columns from the source (the base view) so it will be appliable on all future Selection and Join view we will create ? I tried using restrict...

Answers: 1

Getting access denied when Testing OAuth2.0 connection to BigQuery
answered 20-11-2018 10:23:58 -0500

Thanks for the help on the Authorization URL. After many permutations, I got the OAuth2.0 configured, but then hit a wall when testing the connection. I get the message below: "The user XXXXXXXXX@gmail.com does not have bigquery.tables.getData permis...

Answers: 1

Migration from 6.0 to 7.0
answered 19-11-2018 17:49:05 -0500

Hi, I am planning on migrating legacy denodo to 7.0. My enviornment is as follows: 1) Current state: Dev 6.0 Prod 6.0 (We do not have QA.) 2) For future state a) I have two new servers (one for Dev and one for Prod). Now I want to bring over databas...

Answers: 1

6.0 migration 7.0 denodo Upgrade

Integration with Version Control Systems
answered 19-11-2018 05:33:02 -0500

Hello, I believe I have read in the documentation that Denodo VDP integrates with TFS, Subversion, and GIT. Forgive me if this is a stupid question, but does Denodo integrate with VSTS or only on-premise TFS? Thanks, Lorrin

Answers: 1