Q&A

You must sign in to ask a question. If you do not have an account, you can register here

We are excited to announce the availability of a new version of the Denodo Express 7.0 with new features and fixed issues starting in November 2018.

If you want to try it or if you want to migrate your current Denodo Express version you can download the brand new Denodo Express 7.0 at the Express home page in the Denodo Community.

In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.

Flatten query parameters (array of string)
answered 15-04-2019 10:47:14 -0400

Hello, I have a table with an ID of a company and WS for getting an information if the company can be trusted or not. The problem is with the WS. In default, it has parametrized input array of string and returns two arrays of outputs. I used FLATTEN fu...

Answers: 3

flatten ws

getting HTTP error code 403 on creating base view
answered 15-04-2019 08:27:41 -0400

I'm trying to connect s3, following this Amazon S3 REST API section. my s3 is (dummy info below) bucket: denodo-test file:/denodo.txt (no folder) I have IAM account with full access to s3. I could get se file with awscli. on base view creation part,...

Answers: 3
Related to: How to integrate Amazon S3 with the Denodo Platform

AWS S3

Denodo with Spark
answered 15-04-2019 03:19:11 -0400

Hi, I need to connect Denodo with Spark which is on Yarn. How to connect it? This Spark is not Database.

Answers: 1

Cannot access Diagnostic & monitoring tool
asked 15-04-2019 03:17:18 -0400

Hi, I tried to login to Diagnostic & monitoring tool. Im getting below error: java.sql.SQLException: Cannot create PoolableConnectionFactory (Database '/opt/denodo_platform/resources/apache-tomcat/../../metadata/diagnostic-monitoring-database' not...

Answers: 0

Data Catalog promotion
answered 15-04-2019 01:32:02 -0400

What is the best way to promote catalog and tag mappings from one environment to another? We have allocated views to categories and tags in Dev but cannot figure out how to migrate this to Staging.

Answers: 1

Denodo 7.0 data catalog categories

tuple pattern for csv file
answered 12-04-2019 19:07:56 -0400

Hi, I have a csv file with columns that can grow monthly basis. Find the below example of csv file. I would like to know the wether its possible DF data source can handle using the tuple patterns. Your feedback is much appreciated. Column header is, "...

Answers: 2

DataSource

Unable to connect RDP
answered 12-04-2019 19:01:21 -0400

I have downloaded the RDP file. But unable to connect the same and getting error: " Remote desktop cant connect to remote computer Make sure that remote computer is turned on and connected to the network , and that remote access is enabled." Please su...

Answers: 1

free-trial

Date function issue
answered 12-04-2019 15:58:17 -0400

I want to convert below logic to date format formatdate('dd.MM.yyyy HH:mm:ss', date_time) i tried thisto_date('dd.MM.yyyy HH:mm:ss',formatdate('dd.MM.yyyy HH:mm:ss', date_time)) and cast('date',formatdate('dd.MM.yyyy HH:mm:ss', date_time)) I am ge...

Answers: 2

Denodo Driver Silent Install
asked 12-04-2019 15:48:52 -0400

Hi Everyone, I was hoping to get some insight in to installing the DenodoODBCx64.msi silently for users. I am working on an SCCM deployment and would love to automate the driver install and ODBC connection. I have the connection part down, but I canno...

Answers: 0

ODBC Driver Driver

denodo 7
asked 12-04-2019 14:30:31 -0400

hi, Does this apply to denodo 7.0 also? thanks, hamid

Answers: 0
Related to: Connecting to Denodo from Tibco Spotfire