Q&A

Tableau CRM / Einstein Analytics with Denodo possible?
answered 06-12-2021 06:19:02 -0500

Hi, we would like to connect our Tableau CRM (formerly Einstein Analytics) Datasets to denodo. Is there a built in connector in denodo to connect to Einstein Analytics? I have not found any relevant information in the documentation. There is a salesf...

Answers: 3

Distinct clause issue
answered 03-12-2021 08:12:37 -0500

Hi Team, I'm using Denodo 7.0 Facing issue with Distinct function. we have a join view which is working fine without Distinct clause. When we apply Distinct in code and saved, we getting error while executing which says something like ' 75576 limit e...

Answers: 1

Distinct

How to get the usage statistic of the interface view/ other views called by other application in Denodo
answered 03-12-2021 04:57:49 -0500

Hi Team, We are trying to fetch the usaage statistic of the inetrface view , which is used by they application like powerbi reports, connceting via jdbc drivers. Could you please let us know will be able to collect the usage statistic of the view used...

Answers: 1

DENODO connection to .NET(Entity Framework/ADO .NET)
answered 03-12-2021 02:01:54 -0500

Hi, I'm currently trying to access Denodo VDP server from .NET. Currently I'm using the samples we have on the installation folder. Sadly I couldn't make it run since there's an error occuring. Here's the app.config on my .NET project: <c...

Answers: 2

todate from text string
answered 02-12-2021 08:05:41 -0500

I have a string with date in the following format: 2017-02-08T16:17:10Z tried to use this function but it is NOT working to_timestamp('yyyy-MM-dd''T''HH:mm:ssZ', createdat) I also tried this: to_timestamp('yyyy-MM-dd''T''HH:mm:ss''Z', createdat) Wha...

Answers: 5

Date Conversion

Is it possible to connect to Oracle Stored Procedures?
answered 02-12-2021 07:31:22 -0500

Trying to create base view from an Oracle Stored Procedure... following message appears "Unsupported type PL/SQL RECORD type for database: Oracle Stored Procedures". Anyone has solved this?

Answers: 1

Stored Procedure Oracle

Denodo connector to a Kyligence OLAP cube
answered 02-12-2021 07:09:47 -0500

Hi Team, We have a request from an application to use Denodo to access two different Kyligence workspaces and get the cube data on the models virtualized through Denodo. Is there a custom connector for Kyligence? Regards, Nuray

Answers: 1

Kyligence OLAP

Connect multiple google analytics page in denodo
answered 01-12-2021 07:06:15 -0500

Hi Team, Currently I am accessing single google analytics web page passing the following parameters in google_analytics_templates_denodo.properties file and imported the same into VDP admin tool to establish the connection between GA and Denodo and cre...

Answers: 2

mtd and last week
answered 01-12-2021 04:21:58 -0500

Hi Team, I am trying to find the logic for mtd and last week in a field expression but the logic does not comes in denodo as in spotfire we ahve. Could you please help in this. lastweek: (Week(Date([Date]))=Week(dateadd("week",-1,Date(DateTimeNow()))...

Answers: 1

mtd

Express License and ODBC sources
answered 30-11-2021 05:58:30 -0500

I want to demonstrate Denodo to my colleagues. Therefore I downloaded and installed Denodo Express. However, when I try to create a new source from SQL Server or from MySQL, I get the error message that this is not allowed by the license. What am I doi...

Answers: 1