Great news: we have just introduced support for stored procedures as a data target for all our ETL Products.

Stored procedure data transformation

Also

Performance improvements for MS SQL Server Connection
Various Bug Fixes
Documentation Update

A Stored Procedure is an important tool for working with databases. They allow greater flexibility than SQL statements, ETL developers and programmers use stored procedures for various tasks within databases.

When to use a stored procedure as an ETL data-target?
  1. For complex calculations
  2. Loading data into multiple target tables<
  3. Very large lookup transformations
  4. Validation against a large list of values, for example, validating postcodes
Direct link, no registration required.