Q&A

Connecting MS SQL Server through Denodo Testing tool throws error.
answered 15-10-2020 07:07:41 -0400

I'm trying to establish a connection to SQL Server using the below properties through config file. mssql.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver mssql.jdbcUrl=jdbc:sqlserver://sqlsrv- devtest.database.windows.net:1433;databaseName...

Answers: 1

SQL Server SQL

Where to download google analytics .vql scripts?
answered 15-10-2020 06:35:58 -0400

Hi there, Can you please advise where I can locate the the 2 scripts: google_analytics_administration_templates_denodo.vql google_analytics_report_templates_denodo.vql as reffered to in the user manual: https://community.denodo.com/docs/html/d...

Answers: 1

Ms-Access database connection
answered 14-10-2020 06:54:03 -0400

Dear Sir, I have data in the MS-Access database and please let me know the procedure for connecting these database from the Denodo Tool. Give with example of connectivity. Regards, Senthil

Answers: 3

MS-Access-db-connection

QUERY [VIRTUAL] [ERROR] when i group by some columns in the baseview.
answered 14-10-2020 06:31:32 -0400

I am getting QUERY [VIRTUAL] [ERROR] when i group by some columns in the baseview. Please let me know why do i face the issue only when adding some specific columns. At times this error occurs even for all the column.

Answers: 1

#VirtualError #Groupby #projectionError

Snowflake connection - change warehouse based on e.g. a particular role
answered 13-10-2020 09:04:54 -0400

Hi, With Snowflake as our backend, we keep track of the compute consumption per departement. Users are assigned a "department role" and each departement role uses a dedicated warehouse. How can I do something similar in Denodo? I want to give users acc...

Answers: 3

snowflake

Programmatic IN Operator
answered 13-10-2020 08:36:09 -0400

I am trying to pass in a set of selection criteria for an IN operator but I can't seem to find any way for Denodo to accept it. Example: User enters A,B,C into a text box, and I would like to have that become SELECT * FROM <view> WHERE <column...

Answers: 1

VC++2013 redistributable dependency
answered 13-10-2020 06:53:08 -0400

Hi there, We've noticed that ODBC connectivity with Denodo's ODBC driver is dependant on an older PostGres driver which in turn requires the VC++ 2013 redistributable. As this isn't supported on Windows Server 2016, are there plans for this to be upgr...

Answers: 1

ODBC support Windows Server 2016

Denodo AWS Free-Trial BYOL
answered 12-10-2020 21:26:51 -0400

Is is possible to automate the process of initiating an EC2 instance of Denodo Free-Trial BYOL ? May be using ansible? I'm kind of new so I'm not certain where and how to start with. Any help is appreciated.

Answers: 2

free-trial

Denodo Platform license file
answered 11-10-2020 22:58:54 -0400

Hello there, I'm new to Denodo and I'm trying out the free-trial. https://community.denodo.com/docs/html/document/7.0/Denodo%20Platform%20for%20AWS%207.0%20Free%20Trial%20BYOL%20Quick%20Start%20Guide Four Step instructions: -Register for Denodo Platfo...

Answers: 2

free-trial

to_date function from denodo cannot be delegated to HIVE
answered 09-10-2020 19:21:03 -0400

Hi, I am getting warning as to_date cannot be delegated while trying to find the difference between two dates in denodo with source as HIVE The logic I have used in denodo as: getdaysbetween(to_date('yyyy-MM-dd', table1.start_dt), to_date('yyyy-MM-dd...

Answers: 3

Denodo and Hive