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

Query to get Execution Plan() as output in Denodo

Select * from view_name trace is giving me the query output which is the view data but I’m unable to get the execution trace as data. Please hlp me to get the execution trace or EXECUTION PLAN() as output so that I can redirect the same to a file…
Sourav Ghosh
  • 33
  • 3
0
votes
0 answers

Oracle IDLE sessions

We are having an issue with connections staying idle in Oracle. To give you some background, our users connect to Denodo which in turn has a data source that connects to Oracle. This data source works with one user name and password and creates a…
Luis Garcia
  • 1,311
  • 6
  • 19
  • 37
0
votes
1 answer

Getting 'Interpolate Error' in Denoto, on Delimited File Base View, using date variables

Denodo Data source is a Delimited file with variables in the local path for the date range. A Base View is created using interpolation variables. Querying the data with a start and end date filled in results in this error: Interpolate Error:…
EdHayes3
  • 1,777
  • 2
  • 16
  • 31
0
votes
3 answers

Denodo: How to aggregate varchar data types?

I'm creating an aggregate from a anstime column in a view table in Denodo and I'm using a Cast to convert it to float and it works only for those numbers with period (example 123.123) but does not work for the numbers without period (example 123).…
Ailcid
  • 5
  • 3
0
votes
0 answers

Connection refused for hive

I am trying to access hive from denodo platform, but I get the following error message "Unable to establish connection: Could not open client transport with JDBC Uri: jdbc:hive2://hostname:portnumber: java.net.ConnectException: Connection refused:…
Ranjan Mb
  • 13
  • 2
0
votes
1 answer

Denodo - Unable to case DATE>= addday(cast(now() as date),-365)

I've encountered an issue when trying to obtain the following output: "If x_date >= now-365 then 1 else 0" My select statement reads: SELECT id, x_date, CASE x_date WHEN x_date >= addday(cast(now() as date),-365) then 1 else 0 end…
Ethryll
  • 1
  • 3
0
votes
1 answer

SQL Server Linked server for data federation

I am familiar with SQL server as a product and want to use this to do data federation across a wide range of data sources that can be accessed trough linked servers. My data volumes are rather limited. However I am interested how would this approach…
OverflowStack
  • 259
  • 1
  • 3
  • 17
0
votes
1 answer

Equivalent of Dateadd and DateDiff in DBeaver

I'm getting an error running this code in DBeaver. Anybody help what is the equivalent of Dateadd and Datediff in DBeaver or anybody can convert this code in DBeaver. by the way, Just new in DBeaver. Thank you. row_number() over (partition by…
Jon
  • 139
  • 1
  • 13
0
votes
1 answer

Connecting WSO2 EI to Denodo - Simple Query

I am trying to connect to a Denodo Data source from WSO2 EI using PostgreSQL DB parameters. I am able to fetch the details using simple queries. However when I add a simple "where" condition I get the following error :…
simplysiby
  • 566
  • 9
  • 26
0
votes
1 answer

Creating a new column/field OVER id in denodo

I was wondering if I could get some help in terms of calculating a difference between the date of various statuses. I have a view with column named “id”, “create_dt” and “status”. I would have various statuses like submit, approve, deliver etc. Now,…
Shane
  • 51
  • 1
  • 8
0
votes
1 answer

Having issues while screen scraping pdf by converting to html - using ITPilot in Denodo

In ITPilot after recording the sequence, I have to screenscrape a Pdf document. I am able to convert the pdf to HTML and the resulting HTML is not totally formatted. This is resulting in the extractor in not receiving the fields exactly as…
Sandeep
  • 1
  • 1
0
votes
1 answer

Error connecting to Hive on Server from my local Denodo

I am trying to connect to hive 1.2 which sits on a remote server. I am trying to connect from my local laptop. I am getting an error as : Unable to establish connection: Could not establish connection to <> : java.net.ConnectException:Connection…
TechBytes
  • 563
  • 5
  • 16
0
votes
1 answer

Converting date format in denodo database

I'm trying to convert value for DIM_DT_ID to MMddYY. I'm successful in doinf that. However, query fails because ultimately I'm comparing a character value to date here. Is there a way by which I can get value for DIM_DT_ID in MMddyy format and its…
Ajaya Rk
  • 5
  • 1
  • 7
0
votes
1 answer

Access Metadata for a Derived View other than the tree View in Denodo

I am using Denodo VDP 5.5. I have a very complex Derived View to understand. I am able to get Tree View of the View. But since it is very BIG, it is very hard to understand it. Is there a way to access metadata for that VIEW or get the tree…
TechBytes
  • 563
  • 5
  • 16
0
votes
1 answer

Denodo Virtual Dataport Admin Server not opening on Azure

We have a machine - Windows Server 64 bit in MS Azure Cloud, where we have installed Denodo 5.5 full package with license. The VM has two IPs, one being Internet IP by which we connect the VM and one Internal IP. We have made changes in the Virtual…
mishaqman
  • 29
  • 4
1 2 3 4 5
6
7