Latest Activity

code

Denodo Solution manager roles

Hi Denodo experts, Scenario below: In the Denodo Dev and Stage environments we have a developer called db_1_admin who is an admin on a specific Denodo db called db_1. In the Solution manager, we have provided the stage promotion admin role. Because of ...

#Denodo8 #solutionmanager

code

Denodo OKTA integration related questions

Hello Denodo gurus, We are looking at integrating OKTA with our Denodo 8 instance and we have a few questions if you have already done this integration: Currently the roles are created in the VDP. But when we do the OKTA integration, do the roles ...

#Denodo8 #OKTA

code

Delegate geospatial function

Hi Experts, How can I delegate the ST_INTERSECTS geospatial function to my snowflake datasource? In the Source configuration, I see analytic, scalar and other types of functions. How do I delegate a geospatial fumction to Snowflake? Thanks much in ad...

#Denodo8 #Snowflake #Datasource

code

Denodo function equivalent to Power BI's Text.BeforeDelimiter function

Hello. Does Denodo have a function that can do what the Text.BeforeDelimiter function of Power BI (https://learn.microsoft.com/en-us/powerquery-m/text-beforedelimiter) can do? Thank you.

#powerbi Text.BeforeDelimiter #Denodo8

code

Execution plan says completed but query still running

Hello Denodo Gurus, I am hoping someone can shed some light on the below scenario: In the VDP shell, am running a simple select query from a base view, and clicked on retrive all rows. 2.The query keeps on running for a long time. 3.Upon checking ...

#Denodo8 #ExecutionTrace

code

Outgoing Connections from Denodo

Hello experts, We have been told that there are several million connections open from Denodo to an FTP datasource/baseview. Where can we view these connections in Denodo? The getsessions() seems to display just the incoming connections/queries. Please...

#Outgoingconnections #Denodo8 #Denodo

code

function 'leftpad' cannot be delegated to this database

I have created a selection view in denodo where i have applied some transformations and while executing got the error stating function 'leftpad' cannot be delegated to this database. Redshift is the data source. lpad works in reshift but doesn't work ...

#Denodo8 #Denodo

code

SSL configuration in Denodo 8 (VDP and solution manager)

Hi Team, I am facing couple of issues while enabling SSL in my VDP and solution manager in Denodo 8 platform. Kindly help me with the answers at the earliest. I updated all the configuration files as described in the link: https://community.denodo....

Denodomigration #Denodo8 solutionmanager8 #SSL