Q&A

Denodo to Informatica PowerCenter through DenodoODBC driver
answered 17-12-2019 22:19:18 -0500

Hi, I am trying to create a connection from Denodo to Informatica PowerCenter. I tried connecting with DataDirect 7.0 PostgreSQL Wire Protocol driver which was unsuccessful(the connection works locally and I was able to import Denodo data source in m...

Answers: 1

ODBC Linux Informatica

Error while creating Base View with Delimited Files : column name could not be generated
answered 16-12-2019 21:54:13 -0500

I have below delimited file. When I create base view I'm getting error. Please help me to write Tuple pattern while crateting Delimited Data Source to load the file in Denodo. FirstName;LastName;RollNo ABC;XYZ;22;MUM;0.0;10000 PQR;KYT;26;MOM;10.9;2000...

Answers: 1

Issue promoting custom function/stored procedure relying on third-party libraries from DEV to PRD
answered 13-12-2019 13:09:25 -0500

I developped a stored procedure and a custom function that relies on third party library: ecas-jsr196-4.19.3.jar On all my environments, this libraries is both imported into VDP using extension management and stored in folder: $DENODOHOME/extensions/t...

Answers: 1

Elastic Datatype Text and the LIKE operator
answered 12-12-2019 23:40:08 -0500

We have created a base view to an Elasticsearch data source which has a field named "logmessage" with a datatype of "text". select * from bv_elastic where logmessage like 'something%' When using the LIKE operator on this "text" field, we receive the...

Answers: 1

elastic

Unable to run the install.sh file on mac terminal
answered 12-12-2019 14:52:20 -0500

How to install the denedo on my mac, getting the error when trying to run install.sh file on mac terminal. Please help

Answers: 1

Can "Azure Data Lake Storage Gen2" be connected in the same way?
answered 12-12-2019 07:23:19 -0500

Azure Data Lake Storage Gen2 is now GA. I think the procedure described in this video is for Azure Data Lake Storage Gen1, but is Gen2 compatible with the same settings? Best Regards.

Answers: 1
Related to: How to connect to Azure Data Lake Storage from Denodo Platform

Azure Data Lake Storage Gen2

WGT get info from QlikView tables
answered 12-12-2019 04:00:09 -0500

Dears, Is it possible to grab data from a QlikView dashboard table, by using the Wrapper Generation Tool or with ITPilot in general ? Does it support interraction with Qlik tables ? I've tried I and can't create or assign examples with Denodo 6. ...

Answers: 2

WGT vs QlikView

Cache fetch error
answered 12-12-2019 00:34:47 -0500

Hi Team, Denodo 6.0 source DB : SQL Server cache DB : SQL Server cache type : Full Cache , Never Expire normal query : runs successfully, 10230397 rows cache query : when loading cache : error Error: [BASE] [ERROR] There was an error during a batch...

Answers: 4

Cache

RFC trigger from Denodo
answered 11-12-2019 12:44:38 -0500

Hello. We are creating files to a SAP system in Denodo. The SAP downstream wants to know when the files are generated to start the pull. They ask to send a RFC signal to the SAP system as a trigger for them. Could you help with this? How to config...

Answers: 1

DEN70EDUD02 MySQL server connection issues for DEN70EDUD2002LAB04
answered 11-12-2019 07:54:39 -0500

I am trying to go through DEN70EDUD2002LAB04 and noticed there are issues with connection to a MYSQL server. I followed the steps of adding the jar file from the MYSQL website (adding both the 5.x and 8.x jar files in the lib-external/jdbc-drivers/mysq...

Answers: 3

Denodo_MySQL MYSQL vm