Q&A

How to get denodo data lineage through view_dependencies()
answered 04-06-2020 07:21:43 -0400

Hi all, We are trying to recreate denodo data lineage in one of our vizualization system. If I am querying the VIEW DEPENDENCIES It is giving data in a cluttered format which is very tough to recreate the lineage. Let's say I am querying dependencies...

Answers: 3

#Data Lineage

How can we automate deployment process through Jenkins
answered 04-06-2020 01:27:11 -0400

Hi Team, Can anyone provide solution for automate denodo deployment process through Jenkins.

Answers: 1

Jenkins Automation automate

Although I can query the table for count from oracle db to Denodo. But while fetching data through it results in the following error.
answered 03-06-2020 17:18:05 -0400

sys@oracle> select count(1) from "Finance"."mis_monthly_data"@"VDBSTAGE" ; COUNT(1) 44087129 1 row selected. select from FDSL_UAT.MIS_MONTHLY_DATA where rownum<10 ERROR at line 1: ORA-28500: connection from ORACLE to a non-Oracle system re...

Answers: 3

VCS Pull Problems
answered 03-06-2020 17:15:26 -0400

I encounter some pull problems with denodo VCS git. Suppose I have two DB, one is Main_DB, the other is Sub_DB, Sub_DB code was checked out from Main_DB branch on 2020-05-01 (which means I checked out a new branch from Main_DB branch), on Main_DB there...

Answers: 3

Pull deletion VCS

No privilege to create database/users?
answered 02-06-2020 09:26:00 -0400

Hi, I am trying to create a new database with my user "admin" (default user), and a new user to assign different privileges, but I receive the message "Error accessing the metadata while loading/storing objects" Bear in mind i have a test licence DT...

Answers: 1

Administration Tool

Caching
answered 02-06-2020 08:20:28 -0400

Hi, I have partial caching enabled, and configuration is set on external database and allowed writing on the database. Also I exposed the view as a REST service. When I access the RET service it creates the table in the cache database but does not cach...

Answers: 1

Partial Caching

Query to AWS Athena
answered 02-06-2020 08:04:38 -0400

Do the Denodo query optimizations (aggregation pushdown etc) works with AWS Athena?

Answers: 1

AWS S3 Athena

Errors with ODBC client connection from SQL Server Polybase
answered 02-06-2020 03:49:04 -0400

Hi-- My use-case requires me to establish a Polybase connection from SQL Server using ODBC driver. I have successfuly followed instructions on: https://docs.microsoft.com/en-us/sql/relational-databases/polybase/polybase-configure-odbc-generic?view=sq...

Answers: 4

ODBC

Error removing JAR: Error loading User(XXXXXX)
answered 01-06-2020 09:41:49 -0400

Hi, I used the custom policy code provided in samples and added a user check and query contains check. Now i cannot delete the jar from jar management and get errors. Error removing JAR: Error loading User(XXXXXX) What is the solution for this? Than...

Answers: 4

custom policy Denodo 6.0

Incremental cache implementation in denodo
answered 01-06-2020 04:23:27 -0400

Hi Team, Our source is a custom java API using custom java wrapper, we have made couple of views in denodo. These views are cache'd everyday using scheduler jobs. After vdb cache job ran, we have set of vdb scheduler jobs which will export the cached d...

Answers: 1

Incremental Cache