Q&A

Unable to create base view with CSV as a data source
answered 08-11-2021 06:37:46 -0500

Hi Team, I am trying to create a base view with CSV as a data source created. The data is stored in my local. The connection is successfully created but when I try to cretae the base view it just keeps loading sign showing and nothing happens post tha...

Answers: 1

CSV

Error executing on a Hive Table
answered 07-11-2021 22:34:11 -0500

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

Answers: 3

Hive Issue hive; hadoop

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