Installation

Python libraries

ETL Helper is availabe on the Python Package Index and can be installed via pip.

pip install etlhelper

Database driver packages are not included by default and should be specified in square brackets. Options are oracle (installs oracledb), mssql (installs pyodbc) and postgres (installs psycopg2). Multiple values can be separated by commas.

pip install etlhelper[oracle,postgres]

The sqlite3 driver is included within Python’s Standard Library.

Operating system drivers

Some databases require additional drivers to be installed at the operating system level.

MS SQL Server

The pyodbc driver for MS SQL Server requires ODBC drivers provided by Microsoft.

On Linux, these can be installed via the system package manager. Follow instructions on Microsoft SQL Docs website, or see a working example in our Dockerfile.