Q&A

Denodo cache storing at external DB
answered 09-03-2020 12:04:09 -0400

Please I want to ask if I can store denodo cache at external database ( as mysql or other) ?

Answers: 1

external Database Cache

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