Q&A

How to convert rows to columns using SPLIT function/any generic function in Denodo
answered 06-11-2020 04:45:33 -0500

Hi Team, I need to know is there any generic function available in DENODO for SPLIT function which can be used for any of the views without depending on one single view/function. Example: In Oracle we do have below function which can be used in any o...

Answers: 1

#Denodo #Split #SQL #rowsToColumns

Unable to establish connection to local host
answered 05-11-2020 08:05:59 -0500

Name:jdbc_sql Database adapter: Microsoft SQL Server 2017 (MS Driver) I am using SQL Server 2019 Express Database url: jdbc:sqlserver://localhost;IntegratedSecurity=true;DatabaseName=incident Left all the others blank I get an error: Unable to establ...

Answers: 2
Related to: Accessing MS SQL Server using Windows Authentication

For base view vql, what does "ESCAPE" mean?
answered 05-11-2020 04:35:49 -0500

I just observer the vql of the base view (data source is Hadoop Dremio), for the columns whose sourcetypename='CHARACTER VARYING', some has the attribute "ESCAPE NOT SORTABLE" , some has the attribute "NOT SORTABLE", why for the same data type, they ha...

Answers: 4

vql base view ESCAPE

Denodo4E used for Denodo in AWS cloud
answered 04-11-2020 07:18:12 -0500

When using Denodo4E for custom wrapper development, it is required to specify Denodo Platform Home Directory. When the Denodo server instance is in AWS cloud not on a local machine, can I still use Denodo4E? If yes, how do I specify the Denodo Platform...

Answers: 1

Denodo4E

Pega connection
answered 03-11-2020 11:02:34 -0500

I'm using denodo 7 How Denodo can connect Pega as a datasource. If i need to consume Extracts from Pega, how denodo can handle it. Please help.

Answers: 1

TomcatManager
answered 03-11-2020 06:03:46 -0500

Hi there I am in the process of setting up SSL on Denodo v8. But I cant get tomcat started. Please assist. 3350 [main] INFO 2020-10-29T11:15:09.377 server.start [] - Starting Denodo Platform 8.0 - Process owner: xxxx i - Operating system: Windows Serv...

Answers: 1

TomcatManager

Merging multiple views
answered 03-11-2020 05:56:16 -0500

Hello, I have 6 views. Each view has Key1,Key2,Key3 and other common columns except 1 column which is different in each of the 6 views. I created 1 single Join view (Merge Full Join) joining all views on Key column. I am expecting all the views to merg...

Answers: 1

MERGE

Reading delimited files from multiple unknown subfolders
answered 03-11-2020 04:37:33 -0500

Hi, I'm trying to read delimited files that are being saved to a partially known folder structure such as this: The root folder is known and will not change. The subfolder is partially known. E,g I want denodo to read data from within any subfolde...

Answers: 2

[Teradata Database] [TeraJDBC 16.10.00.05] [Error 9719] [SQLState HY000] QVCI feature is disabled.
answered 03-11-2020 00:57:07 -0500

we are upgrading to teradata 16 in the cloud, I had been using teradata 14 drivers prev for more stability. after overcoming socket exceptions , I flipped to the teradata 16 drivers and got further. I went to create baseline views on my source teradata...

Answers: 3

Denodo 7 - Automate GIT Operations
answered 02-11-2020 07:17:51 -0500

HI Community, We're looking to execute VCS operations (GIT) outside of the Denodo Admin client. Has anyone performed VCS operations without using the Denodo Admin client? John

Answers: 1

Denodo 7.0 GIT VCS