(Article in progress)
New release of OneClickETL (0.3.1) support autogeneration of staging module and processflow which contains all mappings from specification.
To support these features I added three new parameters to target warehouse specification worksheet (StageModule, ProcessFlowModule and ProcessFlowPackage) and also you need define additional worksheet in case of configuration staging module (i.e. if you define StageModule parameter you also must include in Excel file worksheets with specification of source system).
Screenshot of source system specification worksheet
Screenshot of target warehouse specification worksheet
In download section of OWBLand project you can find new MDL file with demo OWB project (ONECLICKETL-0.3.1.mdl) and example of specification file (OneClickETL-0.3.1.xls).
New release of OneClickETL (0.3.1) support autogeneration of staging module and processflow which contains all mappings from specification.
To support these features I added three new parameters to target warehouse specification worksheet (StageModule, ProcessFlowModule and ProcessFlowPackage) and also you need define additional worksheet in case of configuration staging module (i.e. if you define StageModule parameter you also must include in Excel file worksheets with specification of source system).
Screenshot of source system specification worksheet
Screenshot of target warehouse specification worksheet
In download section of OWBLand project you can find new MDL file with demo OWB project (ONECLICKETL-0.3.1.mdl) and example of specification file (OneClickETL-0.3.1.xls).
No comments:
Post a Comment