concentric 1.2

a simple connection manager for connecting to various rdbms (mostly legacy)

a connection manager for python for connecting to various databases.

supported databases:

• oracle

• netsuite

• mssql

• mysql

• vertica

• redshift

• postgres

• db2 i-series

overview

concentric is based off of waddle for secrets management, which means it is strongly coupled to aws kms for its key management.

quick start

1. create a waddle configuration file

oracle:
  host: localhost
  user: scott
  password: tiger
  sid: xe

1. waddle in the password for security

waddle add-secret -f /path/to/config.yml oracle.password

1. use it

from concentric.managers import setup_concentric
from concentric.managers import CachingConnectionManager as ccm

setup_concentric('/path/to/waddle_config.yml', '/path/to/another_config.yml')
conn = ccm.connect('oracle')
with conn.cursor() as cursor:
    cursor.execute('select sysdate as dt from dual')
    results = cursor.fetchall()

contributing

Sample configuration files:

1. db2

2. hp3000

3. mysql

4. netsuite

5. oracle

6. postgres

7. redshift

8. snowflake

9. sql server

10. vertica