etl-pbshop 0.0.9

Create your ETL integrations easy and quickly

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()