Q&A

Delimited file data source, start at specific line
answered 05-11-2021 07:25:16 -0400

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...

Answers: 3

Delimited file data source

Setting user agent with Denodo connector in Tableau
answered 05-11-2021 06:41:08 -0400

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 ...

Answers: 3

Tableau user agent

Skiiping first 3 rows in csv datasources
answered 05-11-2021 03:20:18 -0400

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.

Answers: 1

CSV

How to schedule a CSV export to S3?
answered 05-11-2021 01:29:50 -0400

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

Answers: 3

S3 Export

Power BI Direct Query to SQL dn through Denodo
answered 04-11-2021 05:37:14 -0400

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...

Answers: 1

#powerBI connection #Denodo-PowerBI Azure SQL DB

Unable to create jdbc data source in denodo design studio
answered 03-11-2021 16:13:37 -0400

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...

Answers: 1

JDBC Data Sources Denodo Design Studio

Metadata repository
answered 03-11-2021 03:36:39 -0400

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.

Answers: 3

#metadata

Case Statement
answered 02-11-2021 21:44:18 -0400

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 .

Answers: 3

VARCHAR(65536)
answered 02-11-2021 08:21:33 -0400

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

Answers: 1

How can I get java to set the exit code in my shell when a SQL statement run via jisql throws an exception in Denodo?
answered 01-11-2021 17:53:17 -0400

I am running a command line like this from a Bamboo job in a Windows cmd shell and would like to have the Bamboo fail the deployment if a SQL error occurs in JiSQL however it seems I am unable to get JiSQL to bubble the error out to java.exe or get jav...

Answers: 4

JiSQL