CODEWITHSUNDEEP
pythonteiid
Vaibav
Vaibav

Reputation: 87

How to connect to teiid VDB in python

I need to connect to teiid datasource in Python and execute procedure, are there any libraries to connect to teiid VDB?

Upvotes: 2

Views: 888

Answers (1)

Vaibav
Vaibav

Reputation: 87

import jaydebeapi
conn = jaydebeapi.connect('org.teiid.jdbc.TeiidDriver', 'jdbc:teiid:VDB@mm://hostname:port;version= ', [usename,password], r'PATH_TO_JAR_FILE\teiid-12.2.0-jdbc.jar',)
curs = conn.cursor()
curs.execute("select * from testtable")
data = curs.fetchall()

This code worked connecting to teiid.

Upvotes: 1

Related Questions