Q&A

How can we output of one query as input to create a view?
answered 24-04-2020 14:10:01 -0400

in order to create base views automatically i need to use inputs from the presviously executed query'

Answers: 1

query bands to teradata.
answered 24-04-2020 06:01:38 -0400

my team is impementing denodo with one of our customer facing apps calling denodo. denodo then will reach out to Teradata. so the jdbc from my app will be calling the denodo views/objects ( which are inherintly mapped to my teradata views/objects). ...

Answers: 7

teradata query bands

How can I see stored procedures from a generic JDBC connection in "Create base view"?
answered 23-04-2020 16:33:46 -0400

I can't see any stored prodcedures in Admin Tool for generic JDBC connections. Is there a flag somewhere to see them?

Answers: 1

Use denodo-scheduler-admin for database backups.
answered 23-04-2020 13:25:19 -0400

Team, we need to setup a schedule to backup the databases in our Production environment and wanted to ask if there are step by step instructions to do this via denodo-scheduler? Below is the script I found but am unsure how I could use it in the sche...

Answers: 1

database backups Job scheduler Backup Denodo Scheduler 7.0

Custom Driver stored procedure's not listed
answered 22-04-2020 17:30:01 -0400

Hi, I am writing a Generic JDBC driver to load inside denodo. The driver loads fine but I dont see my stored procedures returned by DatabaseMetaData. They do show up in my other DB tools like dbever. Any insight is really appreciated. Thanks Anish

Answers: 1

driver datasource procedure

Training: Create bv_wo_distance_from_storage base view
answered 22-04-2020 07:38:13 -0400

I’m trying to do this lab, I’m trying to creat from a query, I’m using Denodo supplied code and I get this error. CODE\Tip: SQL query: select LATITUDE as lat_storage, LONGITUDE as lon_storage, ID as storage_id, (NVL(6387.7,0) * ACOS((sin(NVL(@lat_...

Answers: 1

vql for Import roles from LDAP data source
answered 21-04-2020 17:50:35 -0400

Hi all, I understand in VDP we can use “Import Roles from LDAP” wizard to import roles from LDAP data scouce, and I can see ldap data source defined in VDP database, if that do we have vql to import roles, which can does the same thing as the Import Ro...

Answers: 1

vql import ldap roles

Pivot function in denodo
answered 20-04-2020 17:34:20 -0400

Is there any pivot functions in denodo, like the MSSQL server? The KB shows us doing it using case statements. Also is there a new way of creating dynamic columns from distinct row values other than what suggested in below link? https://community.den...

Answers: 1

dynamic columns Pivot

FETCH or LIMIT in a Subquery
answered 20-04-2020 15:00:05 -0400

Are you not able to use FETCH and/or LIMIT in a subquery? This query throws an error - Syntax error: Exception parsing query near 'LIMIT' SELECT a.* FROM view1 INNER JOIN (SELECT joinval from view2 ORDER BY joinval DESC FETCH FIRST 3 ROWS ONLY) AS vie...

Answers: 1

FETCH LIMIT Subquery

Unable to connect Azure Data Lake 2
answered 19-04-2020 13:42:42 -0400

Hi Team, My team is doing POC on data virtualization using Denodo via Azure portal. We required to get data from Azure Data Lake gen 2 and make base view on Denodo so that we can visualize our data using Power BI. As discussed with Mr. Himanshu Shriva...

Answers: 1