ETL ity

ETLity Speed up your ETL development! faster time to market guaranteed quality fix price development

ETLity - generate Quality • ETLitysupports your work with INFORMATICA PowerCenter. • ETLityis the fastest and most inexpensive approach for generating arbitrary numbers of similarly structured mappings. • Your Benefit is a reduction of the original • development effort up to 99% • time up to 99% • save a significant amount of money 300 Mappings, each 2 days = 600 days using ETLity : 5 days ≙ 1%

ETLity - generate Quality • ETLity generates mapplets, mappings, sessions, workflows, parameter files and SQL scripts bases on your requirements. • ETLitysupports agile approaches. You can enrich your mappings in a later project stage. • ETLityis used in 3 simple steps: • Example • Template and Scope • ETLity code generation

The example is made with Powercenter. • It is fully functional and represents your ETL logic • including all objects you want to generate. 3 Steps Example • The template is based on the example and is a generalized representation of your ETL logic. • It is also made with Powercenter. • You can also benefit from our template stock (e.g. with full delta detection and complete history). Template • ETLity generates the requested files based on the Template and your generation scope (the source tables you want to load). • You can import the generated XML-files into your Informatica Repository. You can simply copy the parameter files to the required location and run the SQL files against your database. ETLity

Demo: pass-through mapping Example Template scope: departments ETLity

Demo: pass-through mapping ETLityWorkbench Wfl Template Mapping Template Source Table Columns Alias Data type scope: departments

Demo: pass-through mapping Example Template ETLity

ETLity Use Case ‘Full History’

Use Case ‘Full History’

Use Case

ETLity - generate Quality Find out more! Web: www.ETLity.de Email: info@etlity.de

ETL ity

Télécharger la présentation

Plus de contenu associé