Q&A

Creating a Multidimentional Datasource | SQL Server analysis Services
answered 13-05-2020 02:16:57 -0400

Hello, We have created a Multidimentional Datasource of SQL Server analysis Services. I have followed the Denodo article - https://community.denodo.com/kb/view/document/SSAS%20as%20data%20source?category=Data+Sources (have also followed all the Previ...

Answers: 5

Multidimensional Data Source Denodo_SQL_Server DataSource

sspi continuation error the logon attempt Denodo 8009030c
answered 13-05-2020 01:48:57 -0400

Hello, A user is trying to connect to power BI using ODBC driver and while trying to connect she is getting the error as "ODBC: Error [08001] sspi continuation error the logon attempt failed Denodo 8009030c". There is no issue with the network trying ...

Answers: 3

#powerBI connection #Denodo-PowerBI EXCEL ODBC Driver DENODO

How to flatten JSON Source on web returning different number of registers based on parameters
answered 12-05-2020 16:05:41 -0400

Apologies if my query has been answered elsewhere, but I haven't been able to find a relevant article / direction so far. I have an API source that is drawn into VDP as a JSON format. The API accepts dates as input parameters. Based on the dates enter...

Answers: 2

flatten registers Json date parameters

Connecting to Test Drive env from outside
answered 12-05-2020 15:01:56 -0400

I am playing with Test Drive (Denodo trial cloud env). Can I connect my BI tool to this environment? Are the necessary ports opened?

Answers: 1

test-drive free-trial

Install denodo on remote server
answered 12-05-2020 07:15:20 -0400

HI, I install denodo on remote server using command line installer , how I can access denodo platform center as no ui at the remote server , aslo when i download it local and try to connect to VDB on remoter server connection refused , any help please?...

Answers: 2

virtual data port startup from remote

Scheduler- run VQL and send out result
answered 12-05-2020 02:07:37 -0400

Can I create job on scheduler that run a VQL and email out the query result? Thanks if you have any suggestion.

Answers: 1

Denodo Scheduler 7.0

Predefined Stored Procedures not found
answered 11-05-2020 23:25:26 -0400

Hi, In DENODO 6 documentation, i see in Predefined Stored Procedures these two stored procedures: LIST_JDBC_DATASOURCE_TABLES GET JDBC DATASOURCE TABLES But when i try execute, i recive the messages: Stored procedure 'list_jdbc_datasource_tables' no...

Answers: 1

Denodo to S3 connection at a bucket level ( not an object level)
answered 11-05-2020 08:48:34 -0400

Hello Denodo Team, I have a need to connect from Denodo to a S3 bucket. The S3 bucket receives daily incremental files of a specific object ( same structure for all files ). For example, let us say that S3 bucket contains Campaign data. I will continue...

Answers: 3

S3 bucket AWS S3

Denodo installation on Mac
answered 11-05-2020 08:11:41 -0400

Hi how can i install denodo on my mac i saw the following steps > 1-Download the Denodo installer without the JRE 2-Install java 1.6 or 1.7 in your MacOS 3-Set the JAVA_HOME: export JAVA_HOME=$(/user/libexec/java_home) 4-Run ./installer_cli.sh i use...

Answers: 1

UNION VQL throws java null pointer exception
answered 11-05-2020 08:09:37 -0400

Hello all, I am developing a solution which needs below scenario to work. *Select c1,c2,sum(c3) as C3 from A where x = <val1> group by c1,c2 UNION Select c1,c2,c3 from A where x = <val1>, y = <val 2>;* but this is throwing Java n...

Answers: 1

Java Null Pointer