Differences

This shows you the differences between two versions of the page.

Link to this comparison view

sprockit.20190113 [2019/04/07 16:20] (current)
Line 1: Line 1:
 +====== Sprockit ======
 +
 +Sprockit is a powerful but lightweight ETL process controller for managing SSIS package and T-SQL stored procedure execution. It's **free**, **open-source** and written purely in T-SQL.
 +
 +The difference between good ETL process control frameworks and great ones is how they perform when things go wrong. Desirable behaviours – like fault tolerance, quick fault finding and easy resume after error – often aren't available and sometimes seem hard to achieve. ​
 +
 +[[.:​sprockit:​differences|Sprockit is different]] -- it provides all this using only TSQL and the SQL Server Agent, while at the same time supporting parallel processing, adapting to evolving workloads, providing a breadth of monitoring and diagnostic information and a [[.:​sprockit:​differences|host of other benefits]].
 +
 +<WRAP group>
 +<WRAP 40% column>
 +===== Get started =====
 +
 +<WRAP round download 80% >​[[.:​sprockit:​download|Download Sprockit]]</​WRAP>​
 +
 +  * [[.:​sprockit:​introduction|Learn about Sprockit]]
 +  * [[.:​sprockit:​differences|Find out what makes Sprockit different]]
 +  * [[.:​sprockit:​tutorial|Try the tutorial]]
 +
 +</​WRAP>​
 +
 +<WRAP half column>
 +===== More information =====
 +
 +  * [[sprockit:​dd:​sprockit_tables:​sprockit_tables|Sprockit tables and views]] (interactive database diagram)
 +  * [[.:​sprockit:​configuring_processes]]
 +  * [[.:​sprockit:​process_lineage|Process lineage tracking]]
 +  * [[.:​sprockit:​pipeline_visualisation|Pipeline visualisation]]
 +  * [[.:​sprockit:​index_maintenance|Index maintenance]]
 +  * [[.:​sprockit:​custom_logging|Custom logging]]
 +  * [[.:​sprockit:​utilities]]
 +  * [[sprockit:​faq|FAQs]]
 +
 +  * Slides from my //​{{etl_metadata.pptx|Metadata-first ETL process control}}// talk ([[https://​sqlbits.com/​|SQLBits]],​ March 2nd 2019).
 +
 +</​WRAP>​
 +</​WRAP>​
 +
 +
 +Sprockit is Copyright © 2015-2019 ​ [[richard@RichardSwinbank.net|Richard Swinbank]] and licensed under [[https://​opensource.org/​licenses/​MIT|The MIT License]].
 +
 +{{tag> sprockit etl tsql}}
 +
 +