Q&A

Unable to connect denodo using ODBC from power BI
answered 22-07-2020 02:23:59 -0400

Hi I use denodo platform 7.0 in windows. When i connect denodo data view from Power BI i get below error. --datasource.error: odbc: error [hy000] error while executing the query Even when i tried to connect from microsoft excel using the option "fro...

Answers: 2

ODBC

Issues connecting Amazon S3 bucket with Denodo VDP
answered 21-07-2020 18:06:42 -0400

Hi team, I'm trying to connect Denodo and retrieve CSV files from a S3 Bucket. I have followed all the steps provided in this article: https://community.denodo.com/kb/view/document/How%20to%20integrate%20Amazon%20S3%20with%20Denodo%20Distributed%20Fil...

Answers: 3

AWS S3

Virtual DataPort server won't start
answered 21-07-2020 16:47:38 -0400

I've recently installed Denodo express platform 7.0 on Windows so that I can explore and try it. Now, when I try to start the Virtual DataPort server, it keeps getting stopped. Here you can find the logs from vdp.log ====== INFO 2020-07-16T17:32:01.46...

Answers: 3

Working with JSON hierarchical data
answered 21-07-2020 15:24:12 -0400

Hi Denodo Team, I am struggling with virtualizing data which is in JSON format (and can only be pulled in JSON format from the API). There are numerous arrays within Registers within arrays. My requirement is that I do not create numerous flattened vi...

Answers: 3

flatten JSON

Tableau Desktop connection issue for Denodo SSL enabled server
answered 21-07-2020 11:06:25 -0400

We have SSL enabled Denodo server which we can easily connect from VDP Client.To connect to VDP, we needed to put a certificate file in the security folder under lib within Denodo Installation path. But Tableau desktop data source connection cannot be...

Answers: 5
Related to: How to connect to Denodo from Tableau Desktop

Data calalog giving page not found 404 error
answered 21-07-2020 10:48:32 -0400

Hi All, I have started the denodo platform services in below sequence and all services are running except data catalog and unable to open the http://hostname:9090/denodo-data-catalog/ URL, getting page not found 404 error. I can login in VDP admin too...

Answers: 4

Denodo data catalog data catalog Data Catalog Error Denodo Data Catalog. Version 7.0

Denodo Express Setup and Configuration
answered 21-07-2020 06:36:27 -0400

All, We are exploring the Denodo Express and wanted to try out the Denodo express. I did install on windows and was setting up Database and users. I have some challenges to configure the ODBC, I did install the ODBC drivers supplied by Denodo, I canno...

Answers: 1

Setup

Dynamically updating API endpoint using response from previous call
answered 21-07-2020 05:27:35 -0400

Hi, I am working with a REST API where I need to make a POST call to return a jobid. The jobid needs to be passed to the endpoint of a GET method call to return a result set satifying the post body request from the first call. For example: Submit a qu...

Answers: 3

vdp_admin.sh missing in Denodo 7 VDP Admin tool Linux installation on Mac
answered 21-07-2020 04:26:42 -0400

Hi, I recently installed Denodo 7 VDP Admin tool on Mac 64bit and I see only the below files in the bin directory. I don't see vdp_admin.sh in the directory. Files Available regenerateFiles.sh encrypt_password.sh export.sh import.sh ping....

Answers: 2

Denodo 7 vdp_admin.sh

Labs sqlite driver not found
answered 20-07-2020 23:00:37 -0400

Hi I have been doing the labs and am stuck with DEN70EDUD1004LAB01 in getting the sqlite driver to work. http://denodolearning.litmos.com/course/1620457/module/4346077 I dont have an option to use the VM unfortunately I have downloaded vairous drive...

Answers: 2