Q&A BY TAG 'DENODO'

You must sign in to ask a question. If you do not have an account, you can register here

Protocol to connect Denodo Scheduler from a third party
answered 27-09-2017 04:31:29 -0400

Hi Support, We are planning to centralize all the jobs i.e. Windows Task schduler , SQL and Denodo into one. We have planned to use VisualCron for this. Can you help us with the protocol(FTP/SCP/SMTP/POP3/IMAP/SSH/WebDav) to select to connect Denodo Sc...

Answers: 4

DENODO Denodo Scheduler 6.0

Common Table Expression (CTE) getting an error
answered 05-09-2017 09:01:20 -0400

Hi, i'm converting my CTE codes from SQL server to Denodo/VQL but i'm getting an error it say "QUERY VIRTUAL ERROR". I have a multiple CTE's in my script but when i use a left join in my final query using the result of CTE i'm getting an error and some...

Answers: 1

VQL VQL simple condition DENODO

Date Expression convert to decimal to varchar
answered 05-09-2017 06:27:00 -0400

Hi, I'm new to this forum and also just started to use Denodo. I'm using SQL Server and were converting some SQL codes to Denodo. I'm trying to convert this code below but i'm getting an error specially this portion cast(serialid as varchar)+cast(cast(...

Answers: 3

DENODO

Creating an XML output view using the existing base/derived Views
answered 01-09-2017 09:29:26 -0400

How to Create an XML output using derived view ? for example: I have 3 base view Party, Party Address, Party Related Party. I will need to create an XML output, which needs to be published as SOAP Service. the structure should as below. <PartyServi...

Answers: 1

XML DENODO XML Data Source derived view XML request to response

Validating the Denodo Backups
answered 24-08-2017 03:38:11 -0400

Hi, We are taking denodo backup on daily basis. Will it be possible to vaidate the backup vql to make sure that we have a healthy backup. We want to carry this process on mothly basis. I don't find any way in admin guide to do same . for example: resto...

Answers: 3

Denodo Backup DENODO

Caching Service Views
answered 23-08-2017 08:29:10 -0400

There are 14 Service Views in my database which gives data from 2011 - 2018 (joining different combinedviews). We created partial service views for each of the service view by giving a where condition inside the Partial service view (less than 2016 and...

Answers: 1

cache DENODO Denodo Scheduler 6.0 SQL Server

How to compare two views in denodo
answered 16-08-2017 06:06:54 -0400

Hi, Is there any way in testing tool to compare the the values of two views and send a alert with the MISSING VALUES in case ther's a mismatch. I tried to use select from view 1 in execution directory and select from view 2 in result directory. It wo...

Answers: 1

Denodo Testing Tool DENODO

Unable to cache some views
answered 14-08-2017 09:24:58 -0400

I am trying to cache on Service Views Layer (14 Service Views). In the scheduler, I created VDPCahce jobs for every individual service view. After starting those jobs, I started the monitoring tool to see the status of caching. After 3 hours, 6 of the ...

Answers: 1

cache DENODO denodo scheduler SQL Server

Alter on Base View - Add Trim
answered 10-08-2017 12:24:32 -0400

I would like to add Trim() function to the column in the base view to remove the default spaces for CHAR data type. Can I do this by running an alter statement? I need to do this across all the coulumn in the Source, Is there any setting to do trim by ...

Answers: 2

base view DENODO

Keep view names to cached tables
answered 08-08-2017 09:11:08 -0400

When I am caching the views, some numbering is adding to the table names in the cache database. I want just the view names to be kept for the tables in the cache databse. Is this possible. If yes, please let me know how can I get this done. Thanks, Sa...

Answers: 1

DENODO Denodo Scheduler 6.0 SQL Server