Q&A

Shell Scripting
answered 09-12-2020 17:28:18 -0500

Can you please provide a shell script through which I can connect to a particular Database in Denodo using "Driverclassname", "URL" , USERID , PASSWORD or other details of a JDBC connection. Please let me know incase of any other information needed.

Answers: 6

Shell

je voudrais savoir les limites de Denodo en ce qui concerne la gestion de la qualité des données, lenteur des traitements, incohérences, etc
answered 09-12-2020 08:48:16 -0500

Denodo 8.0

Answers: 1

Data Quality

Promotion of view with same datasource
answered 09-12-2020 04:21:13 -0500

Hello, We have a datasource as Snowflake. QA and Prod Databases are in the same login. We have created the same jdbc datasource(ds_snowflake in both env) for this in both QA and prod. Lets say the QA database is named db_qa and prod database is named ...

Answers: 1

Solution Manager Solution Manager API Deployment using Solution Manager Best Practice

Export base view to Azure data lake storage
answered 08-12-2020 23:03:59 -0500

Hi, I have created a base view. How do I export my base view to Azure data lake storage v2 account. Please advice.

Answers: 1

Denodo on Azure Export Azure Data Lake Storage Gen2

Remove duplicate words with a regular expressión
answered 07-12-2020 07:38:34 -0500

Hello: I have this input: abc,abc,123,000,123,000 And I need to remove duplicates words. The output must be: abc,123,000 I'm using this regexp: \b(\w+)\b\s,\s(?=.*\1) but it doesn't work. I'm testing in this page were works: https://regex101.com/r/...

Answers: 1

Duplicates Regex

IGC can read data From Denodo but..?
answered 04-12-2020 03:57:15 -0500

Hello, I have made a Governance bridge from Denodo to IBM InfoSphere IGC, question is "Can we automate the data synchronization from denodo to IGC by Denodo Governanvce bridge tool in linux on daily basis?" Thank You.

Answers: 1

IGC

Unable to Query views with individual columns in select query
answered 03-12-2020 06:51:36 -0500

Hi Denodo team, I am trying to query a view with its individual columns in the select query but it is failing to fetch the result and throwing the below error. Finished with error: Error in select view conditions: Field not found 'view_name.column_name...

Answers: 1

JDBC query JDBC SQL

How to get the most recent file from data source AWS S3?
answered 03-12-2020 05:46:04 -0500

I'm using Denodo Distributed File System Custom Wrapper. On S3, we have a file gets generated weekly with a full dump of data. So is there a best way to always get the most recent file whenever requested? Also is there a date range supported using cust...

Answers: 1

S3 Bulk Data Load

Tableau vs Denodo
answered 03-12-2020 01:15:00 -0500

I am a Tableau Developer. I work with various source systems to create combined data view. Based on information provided on Denodo platfom, It looks like it connects wth source system to fetch data and provides functionalities to combine them. Tableau ...

Answers: 2

Command to confirm for odata4 service running in vdp server?
answered 02-12-2020 06:24:37 -0500

What is the command to confirm for odata4 service running ( by default) in a vdp server?

Answers: 1

DENODO