Q&A

SOURCE_CHANGES() error out with following error: The following fields are obligatory: table_name
answered 19-02-2019 16:48:34 -0500

Hi Team, I am referring to below link and trying to automate source changes refresh. https://community.denodo.com/kb/view/document/How%20to%20detect%20changes%20in%20data%20sources?category=Data+Sources But when I run below statement i am getting b...

Answers: 1

The following fields are obligatory: table_name SOURCE_CHANGES()

Denodo ignore the spaces
answered 19-02-2019 16:46:16 -0500

Hi, My source data is "XXX600 " but while pulling the data into the denodo it ignores spaces and shows the data as "XXX600". How can i retrieve my original data? in denodo. Thanks, Nithi

Answers: 1

Denodo Space

How to schedule a job to fetch data from an external source (tool) using XML API?
answered 19-02-2019 07:22:45 -0500

Can you please step down the process on how to schedule an XML API to fetch data from an external source(tool)?

Answers: 1

Automic scheduler automation XML XML Data Source Denodo Scheduler 7.0 API

oracle functions corresponding
answered 19-02-2019 05:15:47 -0500

Hi Team I am using following function but i am getting error TO_TIMESTAMP('YYYY-MM-DD HH24:MI:SS',dv_type.time) Error com.denodo.vdb.admin.model.vdbserverproxy.VDBServerProxyException: error computing capabilities: Function 'to_timestamp' with ...

Answers: 1

DenodoODBC Difference
answered 19-02-2019 03:48:08 -0500

what is the difference between DenodoODBCAnsi(x64) and DenodoODBCUnicode(x64) Drivers? Which one is recommended to use?

Answers: 1

#odbc

How to schedule HTTP query run in VDP?
answered 19-02-2019 01:24:44 -0500

Hi team, I am new to Denodo. I have created an xml data source to run HTTP query. I can run it sucecssfully. I want it to run automcatically at defined date/time, how can i do that? I tried to explore Denodo scheduler but could not find any way to do t...

Answers: 1

Denodo Monitor: way to log the trace for an incoming query
answered 18-02-2019 04:10:42 -0500

Hello, is there a way to configure denodo monitor to log the execution trace or the queryies going to underlying datasources for incoming Denodo Queries? Even when the incoming query does not specify it needs to be traced? Lets say I get incoming que...

Answers: 1

Denodo Pagination: how to pass variable in "Offset for the next requests"
answered 18-02-2019 03:29:39 -0500

Hi team, How can I specify value for "Offset for the next requests" to populate dynamically based on value of parameter returned in response on page 1? Is there any way to pass parameter name instead of number?

Answers: 1

days function
answered 18-02-2019 01:05:21 -0500

Hi Team I am able to execute on DB2 but not on the Denodo , is am i missing something (days(current_date)-days(view_a.DATEOFBIRTH))/365

Answers: 1

VDB error on the combination of to_date and formatdate functions
answered 17-02-2019 23:36:32 -0500

Hi Team I am using following functions on a filed but i am getting the VDB error Statement to_date('YYYYMMDD',formatdate('YYYYMMDD',cust.dateofbirth)) Error com.denodo.vdb.admin.model.vdbserverproxy.VDBServerProxyException: error computing cap...

Answers: 1