Q&A

Python SQLAlchemy and connecting to Denodo
answered 07-03-2019 08:03:02 -0500

Has anyone had any luck in connecting to Denodo via SQLAlchemy (ORM for Python)? Are there any python drivers that with both SQLAlchemy and Denodo? For example, I am able to run queries against Dendo using Python's Psycopg2 driver. However when I try...

Answers: 3

SQLAlchemy Python

Denodo Scheduler Exporter section options missing
answered 07-03-2019 07:55:11 -0500

Hi Team, In Denodo 7.0 in Scheduler Job in "Exporters Section" when I click on "New Exporter" I see only of csv,JDBC,SQL,XML but these : ARN-Index,DsrExcelExporter,Excel2007,File-Repository,TDESchedulerExporter are missing in 7.0 when compared to Deno...

Answers: 1

Not able to access the Data sources option (Json or SQL)
answered 07-03-2019 05:39:05 -0500

I want to create the jason and SQL base view in Denodo 7.0. When i go to the sources I see only Excel and LDAP option. Other option is there but not able to use.

Answers: 1

SQL Server #HTTP #Post #Rest_API #webservice

iDoc Listener
answered 06-03-2019 08:17:35 -0500

Hi I would like to be able to receive iDocs using a custom implementation or similar mechanism, has anybody developed any iDoc connector to receive iDocs from a SAP system?. The problem I see is that the iDoc connector should be able to receive iDocs p...

Answers: 1

different type fields
answered 06-03-2019 07:20:29 -0500

Hi Team Issue with follwoing statement , i am getting error `QUERY [JDBC ROUTE] [ERROR] Received exception with message 'DB2 SQL Error: SQLCODE=-581, SQLSTATE=42804, SQLERRMC=null, DRIVER=4.19.26' case when A.a is not null then A when B is not nu...

Answers: 1

files not available for on-demand course
answered 05-03-2019 08:25:39 -0500

Good morning, We are doing online training for developers ‘DEN70EDUD01 Data Virtualization Developer (Introduction) - On-demand’. Almost all the files that are to be downloaded to run the tutorials tests are not reachable. Is it possible to have all th...

Answers: 1

Import script-How to pass folder names that contain spaces when importing a repository elements.
answered 05-03-2019 07:55:10 -0500

Hi, Using export.sh I exported some of the views from a database into a repository. During the process the export utility has also created a folder named 'folder.base views' and create folder 'views' inside it. so if my view name is v1 which is prese...

Answers: 1

Can we connect Denodo from SAP HANA SDI using JDBC drivers? If so, can you please provide instructions?
answered 05-03-2019 06:49:35 -0500

Please help in these two quesitons. They are most critical to prove Denodo as tool which can connect from SAP HANA SDI also.

Answers: 1

Denodo 6.0 JDBC

Cache Error Modifying View
answered 05-03-2019 06:48:57 -0500

Hi - we have been having intermittent problems with our cache. Randomly, when I try to change the cache mode on any view, I receive the error: Error modifying view: Error getting valid table name At this point, I have to ask our admin to reboot or res...

Answers: 2

Cache

connection with phyton
answered 04-03-2019 11:47:46 -0500

we install the ODBC and it does not mark us any error, nevertheless when executing from the Python (version 3.6) it marks us error for lack of the file denodoodbc.so: import pyodbc pyodbc.dataSources() {} cnxn = pyodbc.connect('DRIVER=Deno...

Answers: 1