Q&A

Fetching View's underlying query
answered 16-10-2020 08:53:59 -0400

Hi Denodo team, I have a requirement of fetching view and also the query through which this view is created if that view is created by query.I have tried GET_VIEWS(), CATALOG_VDP_METADATA_VIEWS() and CATALOG_METADATA_VIEWS() procedures.But none of them...

Answers: 1

Base view Stored Procedures query logs Denodo view

Full Caching mode
answered 16-10-2020 07:41:32 -0400

Hello, I am trying out full caching mode and I am using a API from whcih I am calling data and I cannot store last refresh date in it. Can you let me know if still I can use Full caching as it fully suits my requirement.

Answers: 1

caching

Caching issue while sending data to MYSQL workbench.
answered 16-10-2020 07:03:15 -0400

Hello, I have a problem with caching the data I got an error : Finished with error: Error loading cache: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Loading local data is disabled; this must be enabled on both the client and server sid...

Answers: 1

caching

Use Denodo Web Service as a Data Source in Denodo
answered 16-10-2020 06:30:28 -0400

Hi, Is it possible to creat a Data source on a Denodo REST web service ? We have a requirement where we want the Denodo Web service to be utilized as a Data Source .

Answers: 1

Time zone differences and daylight savings
answered 16-10-2020 05:30:41 -0400

I need to account for Daylight Saving Time with the data I am processing. One of the rows has a date time of '01-Nov-2009 01:59:00'. When I set the Locale value to us_cst: English (United States) via the Denodo Administration/Admin Tools Preferences op...

Answers: 1

Denodo 7.0 Date time stamp

Query optimization
answered 16-10-2020 05:23:32 -0400

Hi Denodo community, We have a big tree-view and multiple branch of the tree use same source/query. As is, Denodo reexecute the same query many times during the same execution.I understand that caching might be a solution but I understand too that cach...

Answers: 1

Flattening a Mongo Array
answered 15-10-2020 08:09:58 -0400

I have a Mongo connection that returns data similar to the following: _id : VARCHAR, ticket: { status : VARCHAR, recipient : VARCHAR, request_type : VARCHAR }, stages: { supplier: { status : VARCHAR, eta : VARCHAR }, recipient: { status : VARCHAR, eta...

Answers: 1

Denodo Scheduler Jobs
answered 15-10-2020 07:52:47 -0400

I have a scheduled job that runs 15 minutes after the hour, 24 hours a day. When a long running, heavy resource job is running at the same time, the scheduled job that runs 15 minutes after the hour does not complete before the next hourly execution of...

Answers: 1

Denodo Scheduler 7.0

Connecting MS SQL Server through Denodo Testing tool throws error.
answered 15-10-2020 07:07:41 -0400

I'm trying to establish a connection to SQL Server using the below properties through config file. mssql.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver mssql.jdbcUrl=jdbc:sqlserver://sqlsrv- devtest.database.windows.net:1433;databaseName...

Answers: 1

SQL Server SQL

Where to download google analytics .vql scripts?
answered 15-10-2020 06:35:58 -0400

Hi there, Can you please advise where I can locate the the 2 scripts: google_analytics_administration_templates_denodo.vql google_analytics_report_templates_denodo.vql as reffered to in the user manual: https://community.denodo.com/docs/html/d...

Answers: 1