Q&A

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

Denodo Data bricks jar error
answered 10-12-2020 00:33:26 -0500

I am trying to load the CDATA driver jar to connect to data bricks cluster from denodo 8, I am following the instructions to load the driver in class path using the following instructions in the below link https://community.denodo.com/docs/html/browse...

Answers: 1

denodo8 databricks JDBC CDATA

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 API Solution Manager 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

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