Today’s business applications draw data from diverse sources—from Microsoft Excel spreadsheets to enterprise databases like DB2, SQL Server, and Oracle. How can developers and DBAs easily pull that data into their apps, no matter where the data resides? You’ll find the solution in this book: a straightforward method that uses Microsoft’s SQL Server Integration Services (SSIS) to retrieve data using an extract, transform, and load (ETL) process.
In Extract, Transform, and Load with SQL Server Integration Services, authors Thomas Snyder and Vedish Shah explain step by step how to install and use SSIS 2016 with a few other common tools to build packages that let applications access data in any database platform across the enterprise.
Readers will learn by example as they build an ETL solution that integrates with a data warehouse and an online Web store across a heterogeneous system. The book draws on the authors’ extensive experience developing and running the ETL solution in actual business environments and on production systems. You’ll learn how to enable databases to communicate directly with each other, use files to exchange data, and perform database operations using Web services. You’ll also get downloadable database files and code you can use to implement the ETL solution in your environment.
After you’ve read this book, you will know how to:
Book illustrations by Traci Phillips Healey.
Thomas Snyder’s diverse programming background encompasses open source, IBM, Microsoft, and Apple technologies. He has extensive experience in developing applications in various database environments, including using SSIS to support common ETL needs for business intelligence and e-commerce. Tom is a U.S. Navy veteran with over 20 years of development experience and is the author of Advanced Integrated RPG. He is currently involved in JoltRabbit LLC, a mobile application startup company.
Vedish Shah is an enterprise services application developer who has worked with SQL Server Integration Services (SSIS) since he graduated from The Pennsylvania State University (Penn State) in 2012. He began as a novice and immediately built up his knowledge base in SSIS, transforming himself into a well-respected SME at his workplace. This is his first book, as a coauthor, on SSIS, and he hopes to write more in the future.
|Author Name:||Thomas Snyder and Vedish Shah; Illustrations by Traci Phillips Healey|
|Publication Date:||May 25, 2018|
|Product Dimensions:||7 x 0.8 x 9 inches|
|Shipping Weight:||1.2 pounds|
Vendor: Thomas Snyder and Vedish Shah
Subscribe to our newsletter and always be the first to hear about what is happening.
© 2018 MC Press Bookstore.