Q&A

best way to create a scheduler job to throw exception if a table has records in it
answered 23-10-2019 08:07:25 -0400

Hi Sorry if this is covered in some example docs but i've not found anything that really helps with what i'm looking for. Can you provide an example of how to create a scheduled job that will throw an error if the extraction sql query returns record...

Answers: 3

Job scheduler

Denodo data catalog Internal Database Configuration Missing
answered 23-10-2019 05:54:09 -0400

Hi Team, I am not able to find the internal database configuration option denodo after login as admin. I have full privliagesto setup one.I want to configure mysql Please help me

Answers: 1

Denodo Internal Database Configuration

Query Simplification
answered 22-10-2019 09:05:11 -0400

Hello, I have a scenario where I need to "Simply a Query" based on selection. For example I have two base views, first one named "bv_first_view" (with field names - id, name, age, address) , second base view named "bv_second_view" (with field names - ...

Answers: 4

DB2 Query Simplification

denodo data catalog
answered 22-10-2019 00:24:11 -0400

Hi team, We are getting 404 error while accessing denodo catalog after our installation. we enabled ssl and also found below error sudo /opt/denodo/bin/datacatalog_startup.sh Starting Web Container... Oct 21, 2019 5:08:20 PM ClientCommunicatorAdmin ...

Answers: 1

data catalog

LDAP Microsoft ACtive Directory services
answered 21-10-2019 21:31:44 -0400

Hi Team, I am trying connect the LDAP Microsoft ACtive Directory services to set up Single sign on. I am able to connect LDAP server by creating data source. I am created a base view with Objectclass->User->userprincipalname Got a error java.secu...

Answers: 3

ldap

Denodo to Salesforce via API
answered 21-10-2019 07:23:03 -0400

HI Team, I am trying to get counts of below two objects in Salesforce via API call from Denodo. The counts are varying between Denodo API call and Workbench. Even running below API query in Salesforce(workbench)REST Explorer gives the same count as SO...

Answers: 1

DENODO sales force connection

Denodo Server after Installation error
answered 21-10-2019 02:25:08 -0400

I installed the denodo server and started service after setting up SSL. THe srevice say's running. But i amnot able access the datacatalog and VDP server. Then check logs of VDP. Below error found in VDP.log 5484 [Thread-3] TRACE 2019-10-19T00:43:53.7...

Answers: 1

Installation

How to Update and Insert Data into Table using source Table in different Environments.
answered 21-10-2019 01:22:28 -0400

Hi Team, Good morning!!!! Good Day!!! I Have a question that I having 3 tables(Table A,Table B and Table C) which or in different Environments so Here I want to Update table B using Table A and I want to Insert into Table C using Table A, simple we ca...

Answers: 3

Alert Configure after Detect Changes in Data Source (Oracle DB)
answered 18-10-2019 08:06:33 -0400

Hi team, I already knew that we can detect changes in data sources as shown in the following help page. https://community.denodo.com/kb/view/document/How%20to%20detect%20changes%20in%20data%20sources?category=Data+Sources After detecting the changes...

Answers: 4

alert datasource SOURCE_CHANGES()

Denodo Cached View Issue (returns 0 records)
answered 18-10-2019 07:33:53 -0400

I am seeing a strange issue with my Denodo cached view where it returns 0 records if I put a where statement and limit the columns. No issue if I select all columns though. Is this a bug, or I am missing the error? Please help me get the tailored view ...

Answers: 5

Query Full Cache WHERE CONDITIONS Cache