etl ity
Download
Skip this Video
Download Presentation
ETL ity

Loading in 2 Seconds...

play fullscreen
1 / 18

ETL ity - PowerPoint PPT Presentation


  • 154 Views
  • Uploaded on

ETL ity. Speed up your ETL development!. faster time to market guaranteed quality fix price development. ETL ity - Generate Quality. ETLity supports your work with INFORMATICA PowerCenter .

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' ETL ity' - blaise


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
etl ity

ETLity

Speed up your ETL development!

  • faster time to market
  • guaranteed quality
  • fix price development
etl ity generate quality

ETLity - Generate Quality

  • ETLitysupports your work with INFORMATICA PowerCenter.
  • ETLityis the fastest and most inexpensive approach for generating arbitrary numbers of similarly structured mappings and workflows.
  • 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%

100 %

1 %

With

ETLity

Without

ETLity

slide3

ETLity - Generate Quality

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

ETLity

Workbench

Template

Generated

Code

Generated

Code

Generated

Code

Generated

Code

Scope

Scope

Scope

Scope

3 steps

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 PowerCenter 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

Demo: pass-through mapping

Example

Template

scope: departments

ETLity

etl ity workbench

Demo: pass-through mapping

ETLityWorkbench

Wfl Template

Mapping Template

Source Table

Columns

Alias

Data type

scope: departments

demo pass through mapping1

Demo: pass-through mapping

Example

Template

ETLity

etl ity1

ETLity

Use Case ‘Full History’

etl ity generate quality1

ETLity - Generate Quality

ETLityis generating XML, parameter, and SQL files

ETLityhas been perfected for the last five years

ETLitycauses no risk for your project

ETLityguarantees 100% quality

ETLityalready has satisfied customers in insurance and telco industries

ETLityworks at fixed price for full customer satisfaction

slide18

ETLity - Generate Quality

Find out more!

Web: www.ETLity.de

Email:[email protected]

ad