A high level JDBC API
Project description
pyJDBCConnector
pyJDBCConnector
is a high level JDBC connection API that was designed to provide a further abstraction for jdbc connections in python.
This package is designed as an introduction to jdbc connections in Python and as such provides much less customizability with a focus on
accessibility.
Motivation
This package came about due to intricacies of dealing with the Denodo JDBC driver with SSL enabled.
The jaydebeapi
package that this package is heavily reliant on doesn't provide the ability to specify
the location of a Trust Store file at JVM start-up. This was a big problem for us and we needed to solve this
for analysts with less engineering experience and enable them to get an introduction to Python programming
with familiar data.
Limitations
- Currently this package has only been tested for the Denodo JDBC driver
Examples
Installation/Usage:
This package is currently on PyPi and can be installed through:
pip install pyjdbcconnector
This package is driven primarily through config files. To understand how config files are set up please see the Documentation
Connect to a Denodo JDBC with SSL enabled
"""
This example demonstrates how to use the DenodoConnector
api for connecting to a Denodo based JDBC with a Trust Store
file
"""
import pandas as pd
from pyjdbcconnector.connectors import DenodoConnector
# Initialize a DenodoConnector object
# the DenodoConnector object acts as
# a builder.
dc = DenodoConnector()
# Here, we build the connection using the built-in
# builder functions
conn = dc\
.from_config("path/to/denodo_config.ini")\
.connect()
# this connection acts as a normal sql connection and we can use it
# as we would use any other connection in Python
# Assuming we want to read a table into a pandas dataframe
SQL_QUERY = "select * from tablename"
data = pd.read_sql(SQL_QUERY, conn)
To connect to a JDBC without SSL, omit the lines that require a Trust Store.
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.