Q&A

Denodo 7 and ORC Files
answered 25-01-2023 15:15:21 -0500

Hello, We are investigating how to connect Denodo to Google Cloud Storage. We already found the different options to do it and files Denodo can read, but we have not seen a connector to read ORC files. Do you know if Denodo has a connector or if ther...

Answers: 1

Big Data ORC File google cloud storage

Limitations on derived view (JOIN)
answered 25-01-2023 08:16:47 -0500

Hi All, we have derived view (JOIN) created with 15 tables (14 joins) and planning add additional logic which will bring 10-15 joins additonally . Could you please let me know if there will be any limitaion on that ? Thanks, Ravi

Answers: 1

limitation hash join join

TCP/IP connection failed
answered 25-01-2023 02:23:08 -0500

Hi team, I am new to Denodo and try to establish a connection to a local sql-server instance. I get the following error: Unable to connect to the database: The TCP/IP connection to the host localhost, port 1433 has failed. Error: "connect timed out. Ve...

Answers: 4

Denodo SSO SAML with Azure AD failed "Error validating SAML message" & "insufficient privileges to connect to the database 'admin'"
answered 25-01-2023 01:03:33 -0500

I tried setting up Azure SAML SSO in denodo express edition, It gives me below errors. I tried assigning different roles (allusers, admin, User, global_admin) to users but nothing is working. Open ID SSO Configuration is working good. Error validating...

Answers: 2

SSO

Data movement for same source
answered 24-01-2023 21:35:18 -0500

Need to re-factor complex SQL code in Denodo layer. Query is not getting executed in the source(Snowflake) layer after re-factoring it. It is failing with compilation error due to memory/warehouse limitation set at source layer. Can I temporarily stor...

Answers: 2

DataMovement

Two Solution Managers
answered 24-01-2023 18:11:43 -0500

Hi Denodo wizards, Can we have two solution managers , one for Pre-prod Denodo and one for Prod Denodo? Also, currently we have just one solution manager for pre-prod and prod. We want to create a POC solution manager for testing something, so can we ...

Answers: 1

#solutionmanager

to_timestamp
answered 24-01-2023 17:12:53 -0500

i have two field one for years and the other for month i want to combine the to one field of type timpstamp i used the function to_timestamp but it did not work

Answers: 1

to_timestamp denodo training timestamp

"Configuration tasks" module
answered 24-01-2023 07:27:22 -0500

Hi, where can I find the "Configuration tasks" module? I need the " Denodo Training QuickStart Virtual Machine.ova" file for the DQVM installation. Can you maybe help me with a link?

Answers: 1

Modify selection view
answered 24-01-2023 04:53:50 -0500

Hi All, Can we modify existing "selection" view and add another view with join condition?. I have tried to add it but it is accepting only one view . Just want to double check if there will be any other option .

Answers: 2

Obtaining Data from API
answered 23-01-2023 09:01:16 -0500

Hello. I would like to obtain data from this API: https://www.bankofcanada.ca/valet/ What type of data source do I need to create, please? Thank you.

Answers: 3

#Cloud API #Rest API #API #Rest_API API