Q&A

VQL statement and visual query formatting
asked 26-01-2021 11:07:17 -0500

Hi, I am wondering if there is a tool or add-on similar to that of RedGate SQL formatting capability to facilitate vql code debugging. The vql formatting appears to be lost when exporting vql code from the VDP admin tool.

Answers: 0

Vql shell format vql

SAML Identity Provider (IdP)
asked 26-01-2021 04:36:03 -0500

Is it possible that denodo express 8.0 trial version can configure a authentication against an external SAML Identity Provider (IdP) ? I would like to download metadata xml and upload to my SAP cloud product.

Answers: 0

Idp Denodo Express 8

Autocomplete for kibana types in kibana-plugins
answered 26-01-2021 02:24:18 -0500

I'm developing plugin for kibana and I'm feeling pain due to absent IntelliSense. Does anyone know how to add to IntelliSense support of kibana types in vscode when I open my kibana plugin folder? Or maybe anyone know how to configure IntelliSense to...

Answers: 1

Error Creating the Base View
asked 26-01-2021 02:03:31 -0500

I tried testing Json data source from SAP using HTTP method 'GET', but it responded below error message when creating base view Unable to obtain the data structure: com.denodo.util.exceptions.InternalErrorException: Error retrieving data from 'http://&...

Answers: 0

Create base view Vitural data port 8 denodo express 8

How to pick the last record from duplicates?
asked 25-01-2021 16:57:18 -0500

Say I have a table with 3 columns: A, B, C. See below. Column A Column B Column C 1 11 21 1 12 22 2 13 23 2 12 24 3 14 25 ...

Answers: 0

VQL

Need syntax how to pass multiple values in restapi url for input parameters
asked 25-01-2021 12:13:57 -0500

I tried this way but didn't work in postman Query1: https://denodo server url /server/inventory/InventorySummaryAPI/views/InventoryOnHoldSummaryAPI? $filter=”fctry_id” in (ABC,EFJ,IJK)& $filter=”opr_id” in (12,13,45) & $filter="strg cd" in (19...

Answers: 0

#denodo 7.0 #API #Rest_API

I am getting an error like "error parsing query" when I am using one VQL in the Extraction section of Denodo scheduler, but the same is working find while executing it in VQL shell. Could anyone please guide me where I am doing wrong.
asked 25-01-2021 09:48:07 -0500

Regarding Gather stat & Denodo scheduling

Answers: 0

DenodoODBC_x86.msi is blocked by Microsoft Defender (due to Unknown publisher)
answered 24-01-2021 00:24:56 -0500

The error message is Windows protected your PC Microsoft Defender SmartScreen prevented an unrecognized app from starting. Running this app might put your PC at risk. App: DenodoODBC_x86.msi Publisher: Unknown publisher

Answers: 1

ODBC Driver

Commands/VQL Statement to manage Scheduler Jobs
answered 22-01-2021 06:18:47 -0500

Hi, Does scheduler support management of jobs through a command line interface or VQL interface? We are ware that Scheduler Client API allows jobs, filter sequences and data sources to be programmatically configured and managed. But its to feasible ...

Answers: 1

Scheduler Jobs

How can we check a specific user/account is created by which account?
answered 22-01-2021 05:12:08 -0500

Hi team, if I have Denodo account in DV, and I want to check who and when created that account, how can we do that? We down the vdp.log but cannot get this kind of information. How can get this information? thanks.

Answers: 1

user account check who create