Q&A

Real Time Data Migration from SAP to Cassandra with Denodo.
answered 04-03-2020 06:46:39 -0500

We have currently Micro service based Architecture connected to SAP backend system and Cassandra database as persistent layer. Currently we are performing complex data migration as below which requires lots of resources and overall time consuming S...

Answers: 3

How to use the Denodo JDBC connector from Tableau?
answered 04-03-2020 04:01:12 -0500

As is, when using the JDBC connection from Tableau with the PostgreSQL dialect and the Denodo driver. It is possible to read the metadata from Denodo, but not to view the actual data. What parameters (.tdc file?) should be set to make a JDBC connecti...

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

java.lang.NoClassDefFoundError while trying to connect to hive
answered 03-03-2020 07:37:34 -0500

hello, i have a problem concerning connecting to hive database. i have denodo virtual dataPort version 7 and the quickstart cloudera vm with cloudera version 1.1 .0 but everytime i try to test the connection the following error appears Unable to es...

Answers: 1

Hive Access Denodo Express Hive Issue AWS HIVE JDBI Connection URI

Error while connecting to Git
answered 03-03-2020 07:34:30 -0500

How to upload image/screenshot here in this question?

Answers: 1

Invalid Query because of Oracle REGEXP_LIKE pattern
answered 03-03-2020 04:40:24 -0500

Hi, I am trying to create a base view from query with below sql syntax. However it is failiing with invalid query so i came to know that it is because of '<(1\d{3}(.\d+)?)+>'). Now i tried escaping { and } with '\' but still no success. i am ...

Answers: 1

Invalid query in create base view from query

Elastic queries timeout when aggregating timestamps
answered 02-03-2020 07:57:21 -0500

We are having issues with a Elastic queries hanging and eventually timing out when aggregating or formatting on a timestamp column. Here's our issue. We've created a Data Source using the Elastic JDBC connector. Our Base View is as follows: SELECT t0...

Answers: 1

elastic

denodo_platform
answered 02-03-2020 02:09:59 -0500

Hi there On a windows server, when the server starts up is it possible to make Virtual DataPort startup automatically as administrator. Please let me know

Answers: 1

Virtual DataPort

Error while testing the SSL connection using Keystore
answered 28-02-2020 07:56:46 -0500

Hi, I am trying to test and HTTPS request throught SSL certificate. I tried generating a certificate following below link https://community.denodo.com/docs/html/browse/6.0/platform/installation/postinstallation_tasks/enable_ssl_connections_in_the_deno...

Answers: 1

Text to Date field conversion
answered 27-02-2020 21:31:33 -0500

Hi Team, Using Denodo 7.0 version. I have date field in format 'MM/dd/yyyy' in my source which is in text datatype. I need to project the same in same format('MM/dd/yyyy') but in date datatype. When i use CAST, to_date ,to_localdate ....., format is ...

Answers: 1

Date Conversion Date

Unable to create TFS environment
answered 27-02-2020 13:55:51 -0500

I'm trying to integrate denodo with TFS in version 6.0. Whenever i try to create environment I'm getting this error: Error creating environment: error creating environment: Unexpected URL format: 'http://team/tfs/****/folder/environments/development.p...

Answers: 1

TFS