Q&A BY TAG 'Python'

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

Using com.denodo.scheduler
answered 20-10-2020 04:06:40 -0400

Hi, I'm using Denodo 7.0 update 20200803 and attempting to use the scheduler api via Python/Jpype. Is there a particular jar file I need for the Scheduler? The code below is my attempt. import jpype import jpype.imports from jpype.types import * jp...

Answers: 1

Denodo Scheduler 7.0 API Python

Properties of ODBC driver
answered 06-10-2020 08:28:10 -0400

We are developing a project where we have to connect to our Denodo server from a Python script. We basically load the ODBC driver dynamically, connect to the server and then send the query. Very standard process. Here is the snippent of code where we d...

Answers: 1

C# ODBC Python

python to run vql shell (select , create view, desc view)
answered 31-08-2020 07:20:47 -0400

Hi Team, I am using python to connect Denodo ad want to run some vql, I am using JDBC connection to connect denodo with python library "jaydebeapi", when I ran some select vql query, it works. But I encounter below two problems, can you help check: ...

Answers: 1

vql shell python create view desc view

SqlAlchemy
answered 15-04-2020 13:19:11 -0400

Hello, Thank you for explain that, that's very usefull. Is it possible to use SqlAlchemy instead of those connectors ? If yes can you have a document wich explain that ? Yesterday i tried to do that but it's not work. Thx.

Answers: 1
Related to: How to connect to Denodo from Python - a starter for Data Scientists

Denodo data catalog SQLAlchemy Python

Connection from Python to Denodo
answered 13-01-2020 03:33:12 -0500

Hello, I want to access data from denodo using python3. My code looks like the following: import jaydebeapi hostname = '####################' port = '####' driver = 'com.denodo.vdp.jdbc.Driver' user = '#####' password = '#####' path = '/home/I011404...

Answers: 9

Python

Python JDBC access to Denodo
answered 20-11-2019 06:50:00 -0500

Hi, I have been trying connect our Denodo Server via python, I have been trying from windows and now from MacOs Mojave. I have read other JAYDEBE API posts, which basically Denodo Support team didn't/couldn't help. My code is below user = #### pasw ...

Answers: 1

JDBC Python

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