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
3
votes
1 answer

C# connect to System ODBC datasource

The server admin created a 32-bit ODBC system DSN for me that has the database and user credentials in it. I'm struggling now to understand how to connect to that database from my C# code. If I'm using an SSIS connection it goes through without…
Gargoyle
  • 9,590
  • 16
  • 80
  • 145
2
votes
1 answer

Denodo Dive Split function URL

I'm trying the below code to select the last part of the URL: select 'http://www.XX.com/download/apple-Selection-products/beauty-soap-ICs' , field_1[0].string from ( select SPLIT('([^\/]+$)',…
guess_work0205
  • 21
  • 2
2
votes
1 answer

Performing denodo tasks from Jenkins

I am trying a create a working prototype for performing denodo activities from my Jenkins server. Steps that i want to perform are : Import a VSQL file from GIT to Denodo from Jenkins. Create a view in Denodo from Jenkins. Run this VSQL file in…
Nithin
  • 21
  • 2
2
votes
0 answers

Git promotion/merging approach with 3rd party product

I realize this is a very specific question, and some things might make even the hardened git user shudder, but bear with me… We're implementing a virtual data warehouse, which generates metadata (SQL-like code). The product (Denodo) can be connected…
DocZerø
  • 8,037
  • 11
  • 38
  • 66
2
votes
2 answers

Why spark sql is adding where 1=0 during load?

I am pretty new with spark. I have a task to fetch 3M record from a sql server through denodo data platform and write into s3. In sql server side it is a view on join of two tables. The view is time consuming. Now I am trying to run a spark command…
AIR
  • 817
  • 12
  • 24
2
votes
2 answers

Tableau + Denodo ODBC connectivity?

Has anyone successfully been able to use Tableau to connect to Denodo via ODBC? I'm doing a proof of concept with Tableau and I'm trying to connect to a Denodo data source. I've been told that there are no issues doing this, however, I'm receiving…
Colorado Techie
  • 1,302
  • 1
  • 13
  • 21
1
vote
0 answers

Connecting to Denodo from AWS Glue Job

I am trying to add a new Glue Job that will connect to Denodo and pull data from there. I followed the guide from Denodo but I am still getting below error 2023-03-30 07:09:49,542 INFO [Thread-9] glue.AnalyzerLogHelper$…
rann
  • 11
  • 1
1
vote
3 answers

SQL getting rows with a flag value without using functions

I have a following table I need to only select all the values with sensorfield1 flag = r and reject the rows with corresponding IDs with flag = h and select those values for IDs where flag value is only 'h' I am working on denodo and somehow can…
Hammad Ahmed
  • 75
  • 9
1
vote
2 answers

Complex date column case statement

I need a small help, I am having a date field that has a format like this in a column COL1 COL1 yyyy-MM-dd dd-MMM-yy ddMMMYYYY The query I have is case WHEN ("COL1" like '%-%') THEN to_localdate('yyyy-MM-dd', "COL1") WHEN ("COL1" like…
KSp
  • 1,199
  • 1
  • 11
  • 29
1
vote
0 answers

Error executing view: Function count is not executable in denodo

I have a table with few columns as shown below. I would like to get a count of all the records per week level but I am unable to count it. I could also use group by but I do not want to do that because it gives me too many records. I use denodo and…
KSp
  • 1,199
  • 1
  • 11
  • 29
1
vote
1 answer

How do I use named placeholders in a WITH statement (common table expression) with psycopg2?

I use psycopg2 to connect to a postgres database. More precisely it is a schema on the Denodo platform. When I try to do a database query with a common table expression and use named placeholders I get the following error: DatabaseError: Execution…
Tom
  • 11
  • 2
1
vote
1 answer

Denodo Join between disparate sources without cache

I am new to Denodo, just have installed Denodo Express Server.I am running a sample task. I have two disparate data sources (Postgres and MySQL), Postgres has agents table while MySQL has Customer and Orders data. When I execute a join statement…
OsamaTirmizi
  • 23
  • 3
1
vote
1 answer

Denodo customWrapper Datetime field is not working in environment

Denodo custom Wrapper I am using below code, In the timestamp_field, timestamptz_field column is coming blank. @Override public CustomWrapperSchemaParameter[] getSchemaParameters( Map inputValues) { return…
Rahul Patel
  • 307
  • 1
  • 9
  • 27
1
vote
1 answer

correct way to establish a redis connection with lettuce in java 8

I am trying to build a Denodo java stored procedure that communicates with redis via lettuce. I am using the Denodo 4e eclipse extension and oxygen as recommended by Denodo. I am clearly missing something because all of the documentation indicates…
frogg
  • 55
  • 1
  • 10
1
vote
2 answers

Is it possible to execute sh files GUI application from linux remote server and view it on local machine?

I have a job that runs denodo platform on remote server. Sh files is a GUI application, and I have to run it to start denodo service. I can't access it in windows, is there a way to solve these problems? Already running sh files on Putty Windows,…
Shem Lim
  • 15
  • 5
1
2 3 4 5 6 7