$ 29.45 $ 79.95
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|
$ 16.95 $ 19.95
Product Look Inside the Book Author Bio Specifications Many organizations recognize the value and benefits Artificial Intelligence (AI) can bring if implemented correctly. This topic is outlined in the...
$ 41.95 $ 49.95
Product Look Inside the Book Author Bio Specifications Mastering IBM i Security provides you with the how-to for using the modern interfaces provided in IBM i 7.5 and recent...
$ 59.95 $ 71.95
Product Look Inside the Book Author Bio Specifications In this new edition of IBM i Security Administration and Compliance, Carol Woodbury provides readers with everything they need to know...
$ 12.95 $ 16.95
Product Look Inside the Book Author Bio Specifications Throughout history, machines have been introduced to society to help automate tasks, improve productivity, and reduce costs. And, in just a...