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

Folder structure using ODBC driver
answered 11-03-2020 08:00:55 -0400

Many of our users connect to Denodo using the ODBC driver, version 7. Our databases have interfaces structured in folders, which are visible through VDP, and certain other tools (such as DB Visualizer). However, most reporting tools (ex. Excel, Power B...

Answers: 1

ODBC folders Driver

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

ODBC binding parameters
answered 23-12-2019 17:54:49 -0500

I'm connecting true the ODBC driver form PHP to the denodo database. I'm using pdo and want to make use of binding parameters in de code. e.q.: This works: $denodo = new DenodoDatabase(); $sql = "SELECT * from orders where ordernumber = 20753852 limi...

Answers: 3

ODBC php Bindparam Windows

Denodo to Informatica PowerCenter through DenodoODBC driver
answered 17-12-2019 22:19:18 -0500

Hi, I am trying to create a connection from Denodo to Informatica PowerCenter. I tried connecting with DataDirect 7.0 PostgreSQL Wire Protocol driver which was unsuccessful(the connection works locally and I was able to import Denodo data source in m...

Answers: 1

ODBC Linux Informatica

Connect to Test Drive instance using ODBC
answered 09-12-2019 20:08:30 -0500

Hello I registered for the Test Drive and the virtual machine is running. For testing, I'l like to connect to it using ODBC from my machine. Is that possible? What I've done so far: Installed the ODBC driver In the Windows ODBC manager: Add new ODBC d...

Answers: 1

ODBC Testing

ODBC with SAP HANA in Linux
answered 29-11-2019 06:32:19 -0500

Hello, In a linux server I have installed Denodo, and I need to create a ODBC datasource to connect with SAP HANA, and I readed that I need to use SAP HANA 2.0 ODBC driver. How can I configure Denodo and how can I create the datasource?

Answers: 1

ODBC SAP Linux SAP BW/4HANA DataSource

Required Parms in Power BI Denodo Custom Connector
answered 28-05-2019 11:15:14 -0400

I am trying to use the Denodo Custom Connector in Power BI but I keep getting errors when the interface I want to use has a required parameter. How can I get around this problem? (there is a similar issue with ODBC and I'm hoping the answer isn't to wr...

Answers: 5

ODBC Power BI Custom Connector Parameter

Power Query doing a different join than set in Denodo
answered 19-12-2018 09:11:32 -0500

Hi - I have a view containing 2 tables being right-joined in Denodo but in Excel, it is automatically doing an inner-join. Besides importing the data, is there any other way around this? I am currently connected to Excel through an ODBC. *edit - I w...

Answers: 2

ODBC Power Query

Connecting MS ACCESS
answered 08-10-2018 12:35:46 -0400

Dear reader, I am trying to connect to a MS ACCESS DB. I followed the instructions in this post: https://community.denodo.com/answers/question/details?questionId=9060g0000000A0OAAU&title=Ms-Access+database+connection I am getting the following err...

Answers: 5

ODBC MS Access

Denodo ODBC driver is causing ODBC msc to crash suddenly
answered 09-07-2018 07:19:06 -0400

Out of the blue, Denodo ODBC driver is causing the ODBC msc to crash when I attempt to open a previously created or to add a new Denodo ODBC System DSN. Have other's experienced this as well?

Answers: 1