Q&A

How can we deploy scheduler - scheduling jobs from one environment to another without using the solution manager?
answered 05-06-2020 08:01:48 -0400

We have independent environments having one solution manager for each environment - We don't use scheduler manager for our deployments. Is there a way I and deploy one specific job from one environment to another - without creating individually? Appre...

Answers: 3

Denodo 7.0 Job scheduler Denodo Scheduler 7.0

how to join two table columns using like operator with wildcard search
answered 05-06-2020 07:57:53 -0400

Hi Aall, I have requirement like here. I have two tables first table has a column name is Test which contains data like below Test: SMSReminder Reminder second table has a column called Test1 and data like below Test1 Reminder now I would like to ...

Answers: 1

Access Denodo Express

Jar could not be deleted: error removing JAR: Error loading user
answered 05-06-2020 01:51:57 -0400

Version: Denodo 7.0 I am getting same error as explained in the QA at https://community.denodo.com/answers/question/details?questionId=9060g00000009rlAAA&title=Error+removing+JAR%3A+Error+loading+User%28XXXXXX%29 Jar could not be deleted: error r...

Answers: 4

Denodo 7.0 custom policy

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