Stack Overflow
Stack Overflow

Questions tagged [denodo]

The Denodo Platform is a middleware software platform for the (virtual) integration of data of diverse natures coming from several kinds of sources (databases, web, delimited files...). This software can be applied in scenarios like those involving SOA, Web automation or Web crawling.

The Denodo Data Services Platform is an enterprise Data Virtualization, Data Federation and Cloud Data Integration middleware that uses a declarative approach to abstract, unify, federate and understand disparate data sources and systems, supporting multiple acquisition and delivery modes and latency requirements, as well as a rich set of easy to use data transformation, data federation and data mashup capabilities.

100 questions
0
votes
1 answer

Denodo Json Source and Base View: how to make VQL more traditional SQL syntax

I have a web service api In Denodo, I have virtualized the following api: https://delphi.cmu.edu/epidata/fluview/?regions=nat&epiweeks=201501,201601,201701 as https://delphi.cmu.edu/epidata/fluview/?regions=@{regions}&epiweeks=@{epiweeks} This…
DapperDanh
  • 555
  • 2
  • 5
  • 17
0
votes
0 answers

Is there a VSCode Extension for Denodo VQL highlighting and formatting?

The title says it all. I am looking for a VSCode extension to format and syntax highlight Denodo VQL Queries. Any help is appreciated. Thanks. Link to VQL:…
picklebrain
  • 1
0
votes
1 answer

Denodo/VQL ISO_WEEK

I wanted to work with iso week in Denodo. I could not find any functions or calculations. I wanted to use this code below: GETWEEK("ISO_WEEK", ADDWEEK(CURRENT_DATE(), 1)) Obviously there is no ISO_WEEK function. Have you encountered such a problem…
Ezgi Turalı
  • 1
  • 1
0
votes
1 answer

DBeaver Denodo data access issue: 'user does not have EXECUTE privileges'

I am managing to connect to data in my organisation via Denodo Design Studio fine, but when I try to do it through DBeaver, I get the following error: SQL Error [20100] [HY000]: The user does not have EXECUTE privileges on the view XXXX Any idea…
Ferhat
  • 394
  • 1
  • 4
  • 17
0
votes
1 answer

How would I use divide each row by the SUM of another column?

The database is as follows: ID Classification emissions market_value 1 Type A 0.04 5.67 2 Type B 0.01 6.12 I am trying to add a column whose formula will be as follows: (emissions * market_value) / SUM(market_value) AS…
Wayne
  • 1
0
votes
0 answers

How to download very big table via python (using JDBC)

I have a very big table that I can access either through a Denodo front-end or through denodo-virtual client + jaydebeapi driver in Python, making queries in VQL and saving results to pandas like describe in the manual This table is so big that the…
euh
  • 319
  • 2
  • 11
0
votes
0 answers

Concatenation of non English characters

I'm trying to concatenate 2 columns with non-English data and result is showing up as question marks instead of showing the non-English data. I tried casting to nvarchar, but it's not working. What exactly I'm trying to…
A1569
  • 1
0
votes
1 answer

default parameters consuming a soap service on denodo

I have a question which I am trying to fix for some time but i can´t find the awnser to. I have a base view from a SOAP service in which im trying to make SQL querys. But the WSDL has a lot of optional parameters, if I don´t pass the optional…
arthur Benedetti
  • 1
  • 2
0
votes
1 answer

Integration of Denodo with AWS S3 bucket

Have a requirement to read data from Denodo (Data virtualization) tool to AWS S3 bucket. Has anyone done such integration. If so, what is the best practice/process to integrate Denodo with AWS S3 bucket. Any insight is appreciated. Thanks.
AWSMason
  • 1
  • 1
0
votes
1 answer

Denodo: SPLIT and FLATTEN in the same query statement

regarding to the FLATTEN documentation you have to create a view containing a split first, before you can use…
user9898927
  • 73
  • 8
0
votes
1 answer

Denodo VQL, use union to add a record to view

I'm trying to add a specific record to a view in VQL using UNION but it gives me an error saying com.denodo.vdb.admin.model.vdbserverproxy.VDBServerProxyException: The field properties can only be specified for derived fields. Does anyone know how…
mie
  • 1
  • 1
0
votes
0 answers

Can't resolve maven dependency for denodo

I am trying to use denodo JDBC driver in my spring boot application. I downloaded the jar from the denodo site -> denodo-vdp-jdbcdriver-8.0-update-20210715.jar I'm using intelliJ and I have the dependency in the pom.xml file as such …
Froshiga
  • 205
  • 2
  • 10
0
votes
1 answer

How can I remove the subquery from the select statement?

I need help in removing the subquery out of the original SELECT statement. Is this even possible? I'm needing this to ultimately move queries like this to Denodo/VQL, which doesn't allow subqueries in SELECT statements (but does allow CTE/WITH and…
ccny18
  • 49
  • 7
0
votes
1 answer

How to build a custom docker image which enables the connection of Apache Databricks with Denodo?

For now we are giving all the configurations manually in the Databricks to connect to denodo database.Now the issue is we need to have a docker image which can enable the connection so that a new user doesnt have to do this manually.
Laster
  • 388
  • 5
  • 18
0
votes
1 answer

Is there a Denodo 8 VQL function or line of VQL for throwing an error in a VDP scheduler job?

My goal is to load a cache when there is new data available. Data is loaded into the source table once a day but at an unpredictable time. I've been trying to set up a data availability trigger VDP scheduler job like described in this Denodo…
Floor
  • 5
  • 3
1 2
3
4 5 6 7