Q&A

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

Can I store Denodo Metadata information in my own SQL Server ?
answered 24-01-2020 17:52:33 -0500

Team, Can I store Denodo Metadata information in my own SQL Server database rather than default Apache Derby database ? If Yes, what is the process to do the same. We use Denodo Version 7. Thank you, Dilip

Answers: 1

Metadata

DATE fields being converted to TIMESTAMP in Denodo.
answered 24-01-2020 15:28:35 -0500

While creating base views from data source (oracle), denodo converts all DATE fields to TIMESTAMP. When we try to access these date fields from any JDBC client in our case 'DBeaver' we get these fields as TIMESTAMP and not 'DATE' fields. Is there a way...

Answers: 2

Date Conversion Denodo 7.0 Data Type Conversion

Tableau Server Version: 2019.2.2 can't connect to Denodo V7 using SSL
answered 24-01-2020 13:18:35 -0500

Hi, We can't seem to figure out what is causing Tableau Server to be unable to connect to Denodo V7 when the latter is in SSL. Anybody got a similar issue?

Answers: 1
Related to: How to connect to Denodo from Tableau Desktop

ODBC Tableau DENODO Tableau SSL pass-through

Return Data for the past 6 months
answered 24-01-2020 07:32:35 -0500

Hi. I'd like to query the Denodo view via a querying tool (i.e. WinQSL) for the data from the last 6 months. I have tried the following, but I can't seem to get the Denodo syntax correct. select * from denodo_view where transaction_date >= getdate...

Answers: 1

Date Conversion Dynamic Dates Dates Date

ServiceAccount as a Data Base Login account ?
answered 24-01-2020 03:18:45 -0500

Can I use the same ServiceAccount which has used to install as a Data Base Login ? In that case, what kind of access Service Account needed to connect to Data Base ?

Answers: 1

#LDAP-ServiceAccounts

Type of model in the join
answered 23-01-2020 17:01:27 -0500

The Denodo tool has the join function that allows you to join or integrate data from different sources, however, this works by means of PK (primary key) or FK (foreign keys), I would like to know what models are formed. In other words, it is a star mo...

Answers: 2

Why do JDBC escape sequences give an error with the Denodo JDBC driver?
answered 23-01-2020 13:07:55 -0500

We are using SAP Business Objects Xi 4.2 to consume data from Denodo 7.0 using the Denodo JDBC driver. However queries generated by Business Objects that use a filter on a date object return an error. The SQL is generated with the following syntax in ...

Answers: 1

Service Account as a Data Base Login account ?
answered 23-01-2020 05:28:38 -0500

Can I use the same Service Account which has used to install as a Data Base Login ? In that case, what kind of access Service Account needed to connect to Data Base ?

Answers: 1

PHP ODBC Binding issue with numbers/integers
answered 22-01-2020 06:23:18 -0500

Closely related to this question: https://community.denodo.com/answers/question/details?questionId=9060g000000TQpWAAW&title=ODBC+binding+parameters Binding any type of date, datetime, varchar or char seems to work. however when doing integer or d...

Answers: 1

ODBC php

Dynamic Source File Configuration with SFTP
answered 22-01-2020 05:20:43 -0500

Hi I am experimenting with a prototype for my organization thru Denodo Express Virtual Data Port. Here is my problem: 1) Daily files are deposited into sftp via batch upload. 2) I have configured the data source in denodo to point to the sftp but i...

Answers: 1