Q&A

You must sign in to ask a question. If you do not have an account, you can register here

Is it possible to create data source in one format and save the view in different format (say parquet)
answered 09-12-2020 23:45:51 -0500

Hi, I have created a data source using ADLS2 container using csv format. Using that I have created a base view. Is it possible to save the base view is parquet format after the view is created in ADLS2.0?

Answers: 1

Delimited file data source parquet file Export Azure Data Lake Storage Gen2

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

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

Connecting to denodo from .net core 3.0
answered 07-12-2020 18:13:30 -0500

I am using .net core 3.0 with entity framework core . Is there an article somewhere detailing how to connect to denodo vdp using ef core and .net core. I tried connecting like a postgres database using Npgsql and it does not work.

Answers: 4

.Net core Entityframework Npgsql

Function to synchronize the VDP server metadata with Data Catalog
answered 07-12-2020 12:09:55 -0500

Hi Team, Do we have the feature in some high version Denodo (such as Version 7.0) , which can have auto metadata synchronize the VDP server metadata with Data Catalog? Then we will have no need to do manual sync VDP metadata to Data catalog, and we wil...

Answers: 3

Data Catalog synchronize with VDP feature

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