Q&A

Issue while manipulating json APIs as source in Denodo
answered 14-02-2022 07:21:30 -0500

We are connecting to Absorb LMS from Denodo via json apis we are consuming below APIs: Generating API token (https://myabsorb.com/api/rest/v1/Help/Api/POST-api-Rest-v1-Authenticate) - POST Returns a list of users: (https://myabsorb.com/api/rest/...

Answers: 2

Connect denodo with Synapse using MFA Login
answered 14-02-2022 07:19:51 -0500

Hi, I'm trying to create a data source for connect to Azure Synapse using for authentication Azure Active Directory MFA (Multi Factor Authentication), but when I try to test the connection I'm getting error message Unable to establish connection: Cann...

Answers: 2

Backup Denodo Server and Cache
answered 14-02-2022 07:15:43 -0500

I wanted to know what files/folders to backup for Denodo Server. We are using Denodo VDP, Scheduler and Data Catalog. Also how to backup the denodo Cache db?

Answers: 1

DATA not matching with redshift source table and Denodo base view
answered 11-02-2022 08:14:44 -0500

Hi Team, DATA type is differrent than source table column which is created from redshift spectrum table. in source it is float but in denodo it is round off. source value: 12.85,20.11 Denodo: 12,20

Answers: 1

Power BI dashboard report with Dax queries are performing slow on Denodo
answered 11-02-2022 05:03:57 -0500

I am having slow performance issue in Power BI dashboard built on top of denodo. Denodo is on top of HANA. Trying to figure out where it went wrong. One of the PBI dashboard built on top of Denodo is taking 16 sec to show the data. There are 20+ que...

Answers: 1

Power BI Slow Query Response DAX formulas

Denodo connect
answered 11-02-2022 04:21:40 -0500

How i can connect denodo db in java

Answers: 1

vqlserver for Denodo Express on MAC not starting
answered 11-02-2022 02:50:54 -0500

I have a user who needs to install and run Denodo Express on MAC. He was told via the community to download and install the version without JRE included. He installed that version of Denodo Express but is getting an error when starting the vqlserver. ...

Answers: 1

MAC os

scheduler and scheduler index import problem
answered 10-02-2022 07:42:17 -0500

i recently testing the upgrade from vers 7.0 to vers 8.0 on linux centos 7 between import file process (vdp, data catalog, scheduler, scheduler index, ITPilot) , only scheduler and scheduler index got the warnings. i don't create any jobs on scheduler ...

Answers: 3

Import Denodo Scheduler 8.0

Denodo Scheduler - Passing Parameter values at run time
answered 10-02-2022 06:54:05 -0500

We have to create extract from views into a file based on data columns. Parameterized query: Select * from <view> where creation_date >= '@PREV_RUN_DATE' I need to give the value of "@PREV_RUN_DATE" to the parameterized query at run time, li...

Answers: 5

Text Processing Function
answered 10-02-2022 06:38:25 -0500

What would be the best way to put this function in Denodo as split_part isn't supported in Denodo? ltrim(split_part(split_part(unique_geo_id, '-', 1), ':', 1), 'T') Also, we need to ensure the translated code in Denodo gets delegated to Redshift.

Answers: 1