Q&A

ReadyAPI JDBC connection to denodo: java.sql.SQLException: connection error: no such object in table
answered 17-12-2018 04:03:43 -0500

I am trying to do a JDBC connection from ReadyAPI, I get the follwing error connection String -> jdbc:vdb://<HOST:127.0.0.1>:<PORT:9997>/<DB>?user=<USER >&password=<PASSWORD>; error: Fri Dec 07 11:07:18 CST 201...

Answers: 6

java.sql.SQLException

Write-back scenarios
answered 17-12-2018 03:55:17 -0500

Hi, I would like to get some information about write-back scenarios. Do you have any information about this topic? Thank you!

Answers: 1

Write-back scenarios

ITPilot Wrapper Sequence Generator 7.0 runs in Protected Mode in IE
answered 17-12-2018 00:10:43 -0500

I just started experimenting with ITPilot, and creating sequnces using the IE-based Sequence Generator, and noticed that all files saved/loaded are "sandboxed" to a virtulaized file path due to IE running in Protected Mode. So files I save to "C:\User...

Answers: 1

ITPILOT

how to avoid time zone conversion in Denodo ?
answered 16-12-2018 21:58:51 -0500

Hi, Is there a way we can avoid any implicit timezone conversion in Denodo ? We have a column in a table which house datetime from different regions of US along with an additional Flag column which tells us about the time zone of the row. In this scena...

Answers: 3

High DPI display and Windows 7
answered 14-12-2018 15:56:45 -0500

Hi, I am using Denodo 7 vdpadmin on a Windows 7 machine with a 4K display. The application is displayed unscaled and too tiny. I tried both configuration settings in https://community.denodo.com/docs/html/browse/7.0/platform/installation/appendix/laun...

Answers: 1

Power Query parameters not working when cache is on
answered 14-12-2018 13:01:38 -0500

Hi - I have a view with 1 parameter that I am consuming in Excel through ODBC. I cannot pass the parameter back to Denodo unless the cache is turned off of the view. Is there any solutions for this?

Answers: 1

Power BI Cache

Is there any option to automate, columns and tables from different sources to get a unified schema.
answered 14-12-2018 09:52:16 -0500

I am having sources from different databases i.e sql, oracle and flatfiles. Is there any way i can automate, to find a mapping between the source tables and columns ?

Answers: 1

How to connect Denodo with HDFS?
answered 14-12-2018 07:29:15 -0500

Hi. Does anyone know what is the best way to connect Denodo with HDFS? I cannot find any article or how-to about this topic. I added data sources like Oracle and MySQL databases, Hive. But I need to connect to HDFS.

Answers: 1

DENODO Hadoop HDFS

Start and End Cell Behavior in DenExp 7.0
answered 14-12-2018 07:28:48 -0500

Hi Team, Denodo 7.0 Express MS Excel 2010 Format .xlsx Id Name Age City 1 ABC London 2 PQR 20 Sydney 3 LMN 30 Munich 4 XYZ 40 Paris If I chose Start Cell as B1 and End Cell as D4. I get below result: Name Age ABCPQR 20LMN 30 XYZ 40 Why is city colu...

Answers: 1

Excel

SQL Server recursive query
answered 14-12-2018 05:42:20 -0500

According to https://community.denodo.com/answers/question/details?questionId=90670000000XcjoAAC&title=Can+denodo+Support+to+recursive+queries+%3F Denodo doesn't support recursive query directly. I am trying to create a base view through the method...

Answers: 1

recursive query SQL Server