Latest Activity

code

Use bridge groups in Denodo access management.

We are trying to automate the Denodo access management, for this we are using bridge groups strategy (group as a member of another group), in which the access request occurs via Microsoft Cloud and after approval, the user is included in the cloud orig...

code

how to convert 3 rows of a column into 3 columns of json base view

JSON Base view return the data like below id field_0 1 23.569 1 314.356 1 4 How to convert data into 3 columns like below id x y z 1 23.569 314.356 4 I used windows functions but not working. can you please help on this

code

how to do pagination to retrieve json API datasource second page elements

JSON contains 15000 elements but the baseview returning results as 2 pages and each page contains 10000 elements...it displaying only 10000 elements only after flatten the baseview and not showing the second page 5000 elements in the results. How to do...

code

Data Catalog Assisted Query is throwing error.

Hi Team, We have tried to use Assisted Query feature in Denodo Data Catalog but it is not even getting executed. We are getting the following error. "The request was not successful. Contact with your administrator" We have logged in with Admin previle...

code

how to a split a column into multiple columns

A base view returning the data like below field {234.23,567,09} {456.78,3456.6777} How to convert above a column into multiple columns like below x y z 234.23 567 09 456.78 3456.6777 NULL Can you please help on this..

code

Denodo Embedded MPP - How to configure with Google Cloud Storage

We have deployed Denodo embedded MPP on Kubernetes on GCP GKE. Cluster is up and running and the admin_denodo_mpp VDB is created. Now we need to connect to GCP cloud storage, the parquet files is residing, Please let us know what configuration needs to...

code

Set up Mail Settings for Scheduler using environments variables

Hi, I am trying to configure automatically the section Mail Settings within the scheduler, but I am unable to find the right environment variable names to do so. We use the standard containers provided by Denodo in a kubernetes environment. Would you ...

code

Connect to azure sql managed instance using azure service account with MFA enabled

Does denodo support MFA now? We have an azure serivce account with MFA enabled, we are able to connect sql instance using SSMS but we get error connecting from denodo. We tried using 'ActiveDirectoryInteractive' and ActiveDirectoryPassword both and it ...

code

MS Dynamics 365 Data Source Failing to Create Base Views

I have created a data source (Dendodo 8.0) to MS Dynamics 365 using the wrapper: com.denodo.connect.odata.wrapper.ODataWrapper I used the OAuth 2.0 wizard to obtain the access and refersh tokens successfully. Unfortunatley, when I try to create a b...

code

API using OAUTH Access Token

Dear Denodo Support, i have a question regarding OAUTH authentication. We have a everything in place (client identifier, client secret access token) Access token expires every 12 hours. My question is, does the access token refreshes automaticall...