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

Converting varchar to timestamp
answered 06-08-2018 16:10:33 -0400

Hello, I wanted to convert a datetime field I have to a unix timestamp. This thing is - that the datetime values are stored as varchar on the DB. Is there a way to convert a varchar to unix timestamp on Denodo? Thanks, Itay.

Answers: 4

Insert is not working when I use Join with Insert
answered 06-08-2018 05:44:03 -0400

Hi Team, I am trying to insert data into my target table based on source table as I used below code for that but Iam facing error like this (INSERT INTO only available for materialized and temporary tables). My scenario is: I have 2 tables src_typ1 an...

Answers: 1

I have installed Denodo 7.0 Express,But could not able to upload licence file.
answered 06-08-2018 01:13:03 -0400

Could you please help me with licence file and why i am getting this error?

Answers: 1

What privileges are needed to connect to the Data Catalog
answered 03-08-2018 12:23:11 -0400

Hello, I'm an admin on one Denodo 7 database, not a "full admin." My admin created a second user for me to test with. I granted the second user all the priviledges to the database, and can conenct as the second user using VDP admin. When I try to conn...

Answers: 8

data catalog connect

Denodo base view times out in 15 minutes (Microsoft SQL Server 2014 (MS Driver))
answered 03-08-2018 12:20:58 -0400

Denodo Server times out when I try to access the base view that takes more than 15 minutes to execute. Since query timeouts are a client side concept only, I have already altered below settings on BOTH the clients: Admin Tool Preference -> Connect...

Answers: 1

JDBC QUERY_TIMEOUT

Support for Azure AD Graph API?
answered 03-08-2018 07:12:06 -0400

Does Denodo support authorizing / authenticating users via the Azure AD Graph API or the Microsoft Graph (https://docs.microsoft.com/en-us/azure/active-directory/develop/active-directory-graph-api)? If not, there any plans to do so in the future?

Answers: 3

Need information on Denodo features
answered 03-08-2018 06:01:07 -0400

Hi All, i have below questions. Is Denodo supports DB2 and Sybase? Can we create synthetic data using denodo? Is denodo having data visulation capabilities ? is it possible to do book marks and baranching on data virtulation ? Is it possib...

Answers: 1

Loading Data into a datasource from Denodo
answered 03-08-2018 05:50:43 -0400

We are using a Vertica Datasource. Normally the tables/schemas are created in the Vertica datasouce and the data is loaded by the managers of the datasource. In this case the schema has been created but there is no data in the Vertica table. I have a ...

Answers: 1

How to monitor, block and authenticate REST APIs?
answered 03-08-2018 05:49:33 -0400

How to monitor Denodo REST APIs. Suppose if I want to block a particular API, how can I do that? Is there any UNIQUE API Key for each REST API? Are there any other ways to autheticate the APIs? ( Not HTTP Basic, HTTP Basic with LDAP, HTTP Basi...

Answers: 1

REST API API

How to access Denodo 7 (express) with Power BI?
answered 02-08-2018 04:30:32 -0400

How to access denodo with Power BI Desktop? Do I need to download driver?

Answers: 1