Latest Activity

code

Error executing on a Hive Table

I have configured Hive on Denodo 6.0 using following parameters: database adapter: Hive 0.12.0 (Hiveserver2) Driver classpath: 'hive-0.12.0' Driver class: org.apache.hive.jdbc.HiveDriver Database URI: jdbc:hive2://13.82.57.6:10000/default Transaction i...

code

Delimited file data source, start at specific line

I am using DENODO VDP version 6.0 20170925. I want to create a demilited file data source, but my file contains comments in the first 6 lines, each comment marked with the character #. Is it possible to start reading the file only after the comments? T...

code

Setting user agent with Denodo connector in Tableau

The reference manuals describe the option to set the user agent for a JDBC, ODBC and JMS connection. It also states that "The user agent is not configurable for other types of clients". The native Denodo connector for Tableau does not have an option ...

code

Skiiping first 3 rows in csv datasources

Hi How to create a datasource for a csv delimiter which i need to skip first 3 rows of the file? the first 3 lines has description about the data and it has only one column and starting from 4th line it has 10 columns.

CSV
code

How to schedule a CSV export to S3?

Is there a way to schedule a CSV export to AWS S3 location? Any example

code

Power BI Direct Query to SQL dn through Denodo

Hey , I am new to denodo. I have a powerbi file in direct query mode . it uses odbc connection to denedo serving layer which is connected to sql dB. when end user interact with powerbi, it will generate sql queries and pass that to underlying source in...

code

Unable to create jdbc data source in denodo design studio

Hi Team, Denodo installation is done in aws,am trying to create JDBC data source in denodo design studio in local machine ,am using mysql database as a source ,i have added mysql connector version 8 driver (.jar) in denodo home(denodo/lib/extensions/j...

code

Metadata repository

Can i have one metadata repository for 2 vdp server . we have Dev environment with 2 vdp servers on it. will i face any performance issue in this case.

code

Case Statement

case when id=1 then y else z end what if i have 3 attribute like "Null" I have a 3 values a b c while i am writing CASE statement i can do up to 2 values what if i have 3 option . case when id=1 then a else b end How i am suppose to get 3rd value .

code

VARCHAR(65536)

Few columns in denodo take VARCHAR(65536) as column size even though the size present as VARCHAR(200) OR VARCHAR(20) etc in db. Why do we see the change in column size in denodo and what is the reason for this? In unified views