Q&A

Connecting to Microsoft SQL Server
answered 26-11-2019 15:59:07 -0500

Can you guys show the steps on how to connect to Microsoft SQL Server to import data and to virtualize it in Denodo? Like how you guys did in the link attached below for MySQL. And currently I am using Denodo 7.0 (which is the latest version), but the ...

Answers: 1

Denodo_MySQL Denodo_SQL_Server

Column precision error for decimals
answered 26-11-2019 14:15:53 -0500

I'm getting below error when I execute my final view. This view contain more then 130 columns which I've made change for 'Decimals' Is there a way I can find that specific column because of which I'm getting this error. Finished with error: Error exec...

Answers: 1

Error Data Type Conversion

Exception parsing query near 'SCANNER'
answered 26-11-2019 07:15:26 -0500

I tried to deploy the wrapper from ITPilot to VDP. But it failed saying that 'An error was found while performing the operation: Syntax error: Exception parsing query near 'SCANNER''. Can you guys resolve this issue?

Answers: 3

SCANNER

User Access History
answered 25-11-2019 21:00:51 -0500

Hi Team, Denodo 6.0 Does Denodo stores user privilege and role assigning history and which user assigned access ? Through catalog permissions() we can view the recent permissions. But how to find : which user assigned the permission/role to ano...

Answers: 1

Role and User Management

how to use excel microsoft query to do some aggregation function on one denodo views?
answered 25-11-2019 13:10:19 -0500

I have configured 32-bit ODBC, and let my excel connect denodo views. I can pull the data from denodo to excel in detail level, how do I use microsoft query to do some aggregation caculation on some view. For example, denodo view_a (contain column mont...

Answers: 3

excel

Access interface in vdp connections file.
answered 25-11-2019 13:10:10 -0500

Hi Team, In "vdp-connections.log" file from Denodo Monitor. What could be the possible values for "AccessInterface: Type of access interface of the connection". ? I am intersted to know if "VDP" here would mean "Scheduler" Job. ? Please tell. Thanks.

Answers: 5

vdp connections file

Shell script Schedule
answered 25-11-2019 06:39:16 -0500

Team, We have installed Denodo 6.0 in our Unix environment. We would like to execute one shell script(rename.sh) file through scheduler before our actual denodo job start. Can we execute shell script through denodo scheduler?? Thanks Dp

Answers: 6

Job scheduler Denodo Scheduler 6.0

Denodo's Data Catalog's Capability
answered 22-11-2019 16:42:51 -0500

Can we search for the content in a PDF file by using Denodo? I tried to convert a PDF to HTML by using ITPilot and deployed it to Virtual DataPort, but still, I can only search for the column name and the file name under Data Catalog.

Answers: 1

data catalog

Denodo Pushdown
answered 22-11-2019 14:50:57 -0500

We are using Denodo version 7.0 and Netezza 7.0 Database to procure data. We have configured some of the data in cache and cache DB is also defined in the same Netezza sever as the DB from which we are fetching records. But Denodo instead of performin...

Answers: 1

http://localhost:8080/billing/services
answered 22-11-2019 08:26:09 -0500

Working my way through the tutorial. I could access this webservice but now I am getting an error: This site can’t be reached localhost refused to connect Anybody an idea why connection is now being refused when I could access it the last time I tri...

Answers: 1

SOAP Web Service