Q&A

You must sign in to ask a question. If you do not have an account, you can register here

We are excited to announce the availability of a new version of the Denodo Express 7.0 with new features and fixed issues starting in September 2019.

If you want to try it or if you want to migrate your current Denodo Express version you can download the brand new Denodo Express 7.0 at the Express home page in the Denodo Community.

In addition, if you want to enjoy the Denodo experience you can run one of our Test Drives.

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

VCS Error pushing database
answered 11-05-2020 07:03:51 -0400

We team use git for VDP VCS, we can pull, commit, but when we push code to Gitlab, error below will be showing: " Error pushing database XYZ: GitLab: Committer's email '' does not follow the pattern '@*xxxx.com$' " do we need some configuration change ...

Answers: 1

git push error VCS

Unable to connect to Azure SQL because of TCP/IP
answered 11-05-2020 02:28:23 -0400

Hi, I have been unable to connect to my Azure SQL database that i'm running on Azure VM. I am using Denodo Express to tryout the product. It keeps returning the "Unable to establish connection: The TCP/IP connection to the host, port 1433 has failed",...

Answers: 1

Azure Cloud TCP/IP SQL Server

Iam unable to execute NTILE function in denodo
answered 11-05-2020 00:03:55 -0400

Hi, While executing query in denodo by using ntile function is not executing. It is showing as below error.Kindly help on this. SQL Error [50006] [HY000]: Error executing view: Function ntile is not executable Much appreciate if you provide suggesti...

Answers: 1

#Analytic function

Connecting denodo to Hyperion DB
answered 08-05-2020 07:50:17 -0400

Hi Team, Can you please help me with some useful links or information on how to connect denodo to hyperion DB and create base views of the objects inside? Thank you !

Answers: 1

hyperion

Group by clause based on parameter
answered 08-05-2020 03:13:51 -0400

Denodo version 6 My question is I want to use "group by option" based on condition ie if I have parameter say Item, lot then its should group Item and Lot. Only item parameter is provided it should group by Item only...Is there is any way to acheive i...

Answers: 2

Can Denodo connect to files at AL11(t-code) application server of SAP BW
answered 08-05-2020 02:40:01 -0400

Hello Team, Can Denodo consume files at AL11(t-code) application server of SAP BW. When we connect any SAP BW system, it give infoarea structure only. Regards, Vijay

Answers: 2

SAP BW