Q&A

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

Recursive queries
answered 10-12-2020 06:42:46 -0500

Does denodo 6.0 support Recursive queries like CTE from MSSQL?

Answers: 4

Denodo 7 and 8 data catalog process name
answered 10-12-2020 06:17:58 -0500

Team - I am writing a script to check if denodo data catalog is down and then start. What process or DENODOAPP should I be looking for when I run ps -eaf [our environment is Linux]? Also, what startup script should I use from the $DENODO_HOME/bin direc...

Answers: 3

data catalog process name

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 JDBC databricks 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