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 September 2019.

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.

SAP BW Composite Provider - Denodo 6 support
answered 06-03-2020 08:10:05 -0500

Hello, Does Denodo 6 connect to SAP BW Composite provider type Infoprovider? I am able to connect to SAP BW (On HANA database) using the multi-dimensional DB adpater and in the create base view, I am able to view the composite proovider. However, when ...

Answers: 3

SAP BW

Query Regarding UNION ALL
answered 05-03-2020 20:55:42 -0500

Hi Team, I have created a multiple node in denodo connecting to Jethro Database. All these nodes are working fine and gives the proper result. Now when I am doing UNION of all these nodes, then denodo is not giving result. It says "java.sql.SQLExcept...

Answers: 1

Union All UNION

Fields Truncation
answered 05-03-2020 07:41:57 -0500

We have a delimited data source of weblogs, when we try to cache the data results in below error. Finished with error: Error loading cache: There was an error during a batch insertion: String or binary data would be truncated.. total time: 14 seconds ...

Answers: 1

Cache error

SQLServer as Cache with BCP - Best practices ?
answered 05-03-2020 07:28:52 -0500

Hello, When switching from MSSQL "standard" cache load, to a bulk-load using BCP, what are the best practices and recommendations regarding the SQL Server database ? The User Manuals (here) are quite laconic about that. Best regards

Answers: 3

MSSQL bcp Cache

Split Comma separated string to columns
answered 04-03-2020 23:45:02 -0500

Hello I am trying to split a comma separated string to multiple columns . I am not able to find an easy method to do it using the available functions. Essentially I have a field called carmodel in the datawarehouse.It has multiple model separated by a...

Answers: 1

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