
Data Integration Life Cycle Management with SSIS
A Short Introduction by Example
Andy Leonard(Autor*in)
APress
Erschienen am 27. November 2017
Buch
Softcover
XIII, 185 Seiten
978-1-4842-3275-0 (ISBN)
Beschreibung
Build a custom BimlExpress framework that generates dozens of SQL Server Integration Services (SSIS) packages in minutes. Use this framework to execute related SSIS packages in a single command. You will learn to configure SSIS catalog projects, manage catalog deployments, and monitor SSIS catalog execution and history.
Data Integration Life Cycle Management with SSIS shows you how to bring DevOps benefits to SSIS integration projects. Practices in this book enable faster time to market, higher quality of code, and repeatable automation. Code will be created that is easier to support and maintain. The book teaches you how to more effectively manage SSIS in the enterprise environment by drawing on the art and science of modern DevOps practices.
What You'll Learn
Database professionals working with SQL Server Integration Services in enterprise environments. The book is especially useful to those readers following, or wishing to follow, DevOps practices in their use of SSIS.
Data Integration Life Cycle Management with SSIS shows you how to bring DevOps benefits to SSIS integration projects. Practices in this book enable faster time to market, higher quality of code, and repeatable automation. Code will be created that is easier to support and maintain. The book teaches you how to more effectively manage SSIS in the enterprise environment by drawing on the art and science of modern DevOps practices.
What You'll Learn
-
Generate dozens of SSIS packages in minutes to speed your integration projects
-
Reduce the execution ofrelated groups of SSIS packages to a single command
-
Successfully handle SSIS catalog deployments and their projects
-
Monitor the execution and history of SSIS catalog projects
- Manage your enterprise data integration life cycle through automated tools and utilities
Database professionals working with SQL Server Integration Services in enterprise environments. The book is especially useful to those readers following, or wishing to follow, DevOps practices in their use of SSIS.
Weitere Details
Auflage
1st ed.
Sprache
Englisch
Verlagsort
Berkeley
USA
Zielgruppe
Für Beruf und Forschung
Illustrationen
6 s/w Abbildungen, 173 farbige Abbildungen
XIII, 185 p. 179 illus., 173 illus. in color.
Maße
Höhe: 235 mm
Breite: 155 mm
Dicke: 12 mm
Gewicht
318 gr
ISBN-13
978-1-4842-3275-0 (9781484232750)
DOI
10.1007/978-1-4842-3276-7
Schweitzer Klassifikation
Weitere Ausgaben
Andere Ausgaben

E-Book
11/2017
APress
46,99 €
Als Download verfügbar
Person
Andy Leonard
is Data Philosopher at Enterprise Data & Analytics, and SSIS trainer, consultant, and developer. He also is a Business Intelligence Markup Language (Biml) developer and BimlHero. Andy also is an SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of
The BIML Book
(Apress), and
SQL Server Integration Services Design Patterns
(Apress).
Inhalt
1. Introduction to DIML.- 2. SSIS.- 3. Source Control.- 4. Deploy to the SSIS Catalog.- 5. Configure the SSIS Catalog Project.- 6. Catalog Browser.- 7. SSIS Catalog Compare.- 8. SSIS Framework Community Edition.- 9. Catalog Reports.- 10. BimlExpress Metadata Framework.- 11. Conclusion.- 12. Appendix A: Links.