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.

Issue in renaming a view
answered 09-03-2020 02:29:40 -0400

HI Team, Using Denodo 7.0 version. I'm facing an issue in renaming a view. Lets say, i've two derived views dv_1_orders and dv_2_sales. And dv_3_join is the join view of dv_1_orders and dv_2_sales. Then I have renamed dv_1_orders to dv_4_orders and...

Answers: 1

Rename

Cannot Create BaseView Form SQL Server Partition Table
answered 08-03-2020 22:21:50 -0400

I will create 6 baseview from sql datasource, i'm not sure the table have partition table or not. But on denodo only 1 table created and another table error (conflict table name). Illustration, i will create base view - https://imgur.com/HdsObLD + ...

Answers: 2

on conflict partition Create Base View Baseview Denodo_SQL_Server SQL

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