Extract, Transform, and Load with SQL Server Integration Services: With Microsoft SQL Server, Oracle, and IBM DB2
By 作者: Thomas Snyder – Vedish Shah
ISBN-10 书号: 1583478809
ISBN-13 书号: 9781583478806
Edition 版本: First
出版日期: 2018-06-04
pages 页数: 396
Readers will learn by example how to use Microsoft SQL Server 2016 Integration Services (SSIS) as they design and implement extract, transform, and load (ETL) solutions to support a business application that integrates with a data warehouse and an online Web store across a heterogeneous system. This volume describes proven methods to support common ETL needs, such as databases communicating directly with each other, using files to exchange data, or performing database operations using Web services.
Contents
Acknowledgments
Chapter 1:Introduction
Chapter 2:Installation:Stocking the Toolbox
Chapter 3:Overview:Understanding the Toolbox
Chapter 4:Database Setup
Chapter 5:Data Source Base Project
Chapter 6:Extract,Transform,and Load
Chapter 7:Exporting Data to Files
Chapter 8:Importing Files
Chapter 9:Logging
Chapter 10:Using SPs,Expressions,Scripting,and
Package Parts with SSIS
Chapter 11:Flow Control,Exceptions,and
Notifications
Chapter 12:Web Services
Chapter 13:Configurations,Parameters,and
Deployments
Chapter 14:Executing an SSIS Package
Appendix A:Additional Resources
Index