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 November 2018.

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.

bad ELF interpreter + SSH Crash
answered 09-01-2018 02:57:31 -0500

Hey, I'm trying to install denodo on a Linux VM via an SSH-Connection. But when I execute the install-command the following happens: [root@sandbox denodo-install-6.0]# ./installer_cli.sh install ./installer_cli.sh: /opt/denodo_install/denodo-inst...

Answers: 2

Cached View Names on Database
answered 08-01-2018 06:13:24 -0500

Hi, In Denodo , when we cache a view to RDBMS the name of the table which is created does not reflect the name of the view but istead is some random combination of characters and numbers. For example Denodo Cached View in VDP = dv_sls Denodo C...

Answers: 1

VDP Date format and REST Service output date format is not matching
answered 08-01-2018 05:53:52 -0500

Hi Team, I seeing different issues here. Please help to fix out. I have one date column in oracle DB and getting data as below Requirement Request Date 11/27/2017 10:59:37 PM 11/27/2017 10:59:37 PM 11/27/2017 10:59:37 PM I brought into Denodo and whil...

Answers: 1

GetQuarter function
answered 05-01-2018 06:52:30 -0500

select ctry_cd, sum(setlmt_amt) from dpd.issr_qtr where getquarter(prch_dt) = 1 group by ctry_cd The above query does not delegate the getquarter function to the database. So Denodo is retrieving several million records on to the denodo server and doi...

Answers: 2

GetQuarter

Start the Denodo job with dependencies using Shell script
answered 04-01-2018 19:26:47 -0500

Hi, Can you please assist me to invoke the Denodo Job with dependecies option using shell schipt. I can see only below options and don't see start-with-dependecies option sh test_schedulerclient.sh -start load_dv_added_current_frozen_vw -h sjgdvappd...

Answers: 1

shell Denodo scheduler admin Denodo Scheduler 6.0

Can I try out Denodo IT Pilot in Denodo Express?
answered 04-01-2018 16:14:08 -0500

Can I try out Denodo IT Pilot in Denodo Express? What license should I be using? I installed Denodo Express on my machine and applied license available on Express page https://community.denodo.com/express/download/, but ITPilot is coming up as disable...

Answers: 1

Denodo Express ITPILOT

Scheduler backup jobs of export.sh script
answered 04-01-2018 14:35:11 -0500

Is it possible to set up a job in the Denodo scheduler tool to run the export.sh script in order to perform routine backup's of the metadata? I saw other questions similar to this, but nothing that distinctfully says 'Yes' or 'No'. I cannot find anythi...

Answers: 2

Denodo Scheduler 6.0 export

Impersonate a Role in Denodo
answered 03-01-2018 16:50:34 -0500

Hi, Being an Admin on a Denodo server ,is there a way I can impersonate a certain role and verify if that Role has all the intended access or not ? thank you !

Answers: 1

Access and Role

Accessing Denodo from Mac OS clients
answered 03-01-2018 10:46:02 -0500

I'm looking for recommendations on the best way to allow Mac Os clients access to Denodo using tools like Excel and Access. What is considered the preferred approach?

Answers: 4

External Client Access Excel For Mac Mac OS

Delegate Cast Function
answered 02-01-2018 17:06:24 -0500

Hi, I am using below sql in denodo to query against DB2. where I see the cast function is not delegated to database. Select cast (settlement_cnt as int8) as sett_cnt from table1 Currently denodo does type converion in "Projection Plan" How do I get ...

Answers: 1