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.0.11.tar.gz
(11.8 kB
view hashes)
Built Distribution
Close
Hashes for etl_pbshop-0.0.11-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | d587f2fe5b57603baec75705bf1bfea0d6f9ef54174c79e4d6c9d80ba539dced |
|
MD5 | ed6646f678b776ccfbc038234152c265 |
|
BLAKE2b-256 | 6753abe7f08ef6869452253b54a54280262ad3aeca6086bd6b75f39377a97f11 |