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 April 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

Connecting to Tableau, Connection Guide no longer exists
answered 08-11-2018 09:08:12 -0500

Hi, I am trying to setup a connection to denodo within my tableau v 10.5 . Seems like the documentation on how to do this is gone. https://community.denodo.com/kb/view/document/Connecting%20Tableau%20Desktop%20to%20Denodo?category=Northbound+Connecti...

Answers: 2

DENODO Tableau

In my Derived view there is one field message. it's return value in XML. How do I get some field from there?
answered 08-11-2018 06:32:44 -0500

In my message field I got ><ns2:ResponseDateTime>2018-09-20T14:10:26.607-04:00</ns2:ResponseDateTime>><ServiceName>test</ServiceName><ServiceRequestDateTime>2018-09-20T14:10:26.508-04:00</ServiceRequestDateTime&gt...

Answers: 3

VDP XML DENODO

two query in same session.
answered 08-11-2018 06:27:59 -0500

How to run 2 or more queries in same VQL session, getting two result set.?

Answers: 1

to_date function given a week_of_year and year -> influence day selection?
answered 08-11-2018 05:58:27 -0500

Hello, getmonth(to_date('yyyyww', *date)) a wrong month 201831 -> gives 7 but it should be 8, The beginning of this week is in month 7 and the end in 8. How can this be influenced, i.e. by defining the 'first day' it should be converted to?

Answers: 1

Deployment using Solution Manager Best Practice
answered 07-11-2018 19:59:23 -0500

Hello, I'm looking for Best Practices in Deployment using the Solution Manager. Thanks Edwin Wahjosoedibjo

Answers: 1

Promotion Deployment using Solution Manager Best Practice deployment

passing query param for REST service from another view column dynamically
answered 07-11-2018 19:32:52 -0500

Hi, I need to call one REST service by passing dynamic query parameter, this dynamic query parameter would come from database table coulmn. I have tried doing this with interpolation variable but it asking me the value of that on the next step but i n...

Answers: 3

TO_DATE alternative in Denodo 7.0
answered 07-11-2018 12:04:58 -0500

Hi Team, In my Denodo prior version I have a expression as below, to_date('dd-MMMM-yyyy', (((('01'||'-')||bv_assign.assign_month)||'-')||bv_assign.assign_year)) and this returns value as "Fri Sep 01 00:00:00 EDT 2017" but when I try to migrate the cod...

Answers: 1

Still Unable to establish connection
asked 07-11-2018 11:19:17 -0500

I am using Denodo 7 and have followed these instructions and get the following error when I try to test the connection (and, yes, we do use integrated authentication for connecting to our SQL Server databases): Unable to establish connection: This dri...

Answers: 0
Related to: Accessing MS SQL Server using Windows Authentication

Can we run ODATA2.0 with ODATA4?
answered 07-11-2018 06:52:29 -0500

Hello, I have installed ODATA2.0 but I cannot connect to the database using the URL: http://localhost:9090/denodo-odata2-service-7.0/denodo-odata.svc/dbname I get a Error 405 if I just browse to http://localhost:9090/denodo-odata2-service-7.0/denodo-...

Answers: 1

ODATA OData

How to install/set up SAP RFC_READ_TABLE connector
answered 06-11-2018 11:37:19 -0500

Hi, How can I install RFC_READ_TABLE connector? I already go thru the link below, but it seems to show what to do after the connector is already installed and ready for use. https://community.denodo.com/kb/view/document/Creating%20an%20SAP%20extensi...

Answers: 1