Create your ETL integrations easy and quickly
Project description
ETL Lib
This is a simple package built for Portobello Shop integrations, and now is available as ETL lib.
Can be used with several services, like:
- Oracle
- Salesforce
- MSSQL Server
- GSuite
- Microvix
- ODBC Drivers: PYODBC and SQLALCHEMY
- And any REST services ...
Basic Usage
Use inheritance and rewrite the three main methods:
from etl_pbshop import ETL, Connectors
class MyETL(ETL):
def extract(self):
# extract the needed data using Connectors
pass
def transform(self):
# do some transformations
pass
def load(self):
# upload your transformations
pass
On the main caller, you can simply:
if __name__ == '__main__':
etl = MyETL()
etl.config.start()
try:
etl.run()
exit(0)
except Exception as e:
etl.get_error(f"ERROR on main: {str(e)}")
raise e
finally:
etl.config.finish()
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
etl-pbshop-0.1.1.tar.gz
(11.8 kB
view hashes)
Built Distribution
etl_pbshop-0.1.1-py3-none-any.whl
(13.4 kB
view hashes)
Close
Hashes for etl_pbshop-0.1.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 9b311fe4fa0efeaef7c0058b5ef7adb51f56da830575f0e44d9f132651d7c61b |
|
MD5 | fa9520a32886c80ade6c3a07025bd6e2 |
|
BLAKE2b-256 | 58c4a791f8c5f69d19313082eee94b66d3be5c56bb9e96933019425d58a557d0 |