The Leading Educational Resource for IT Professionals
 

Extract, Transform, and Load with SQL Server Integration Services

Thomas Snyder and Vedish Shah

urn:uuid:851f6ede-0423-4046-872f-963da832e8b3

Continue Shopping or Checkout

  • 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:

    • Use industry-standard software tools to build ETL solutions for business applications.
    • Apply ETL solutions across a variety of databases.
    • Import and export database content to/from files in multiple formats, such as Excel, CSV, and XML.
    • Create modular, reusable SSIS parts and scripts.
    • Implement exception handling with logging and notifications.
    • Provide common data exchanges across the network with SSIS using Web services.


    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.

  • Item Number: 5177
    Author Name: Thomas Snyder and Vedish Shah; Illustrations by Traci Phillips Healey
    Publication Date: May 25, 2018
    Edition: First
    Pages: 400
    ISBN-10: 1583478809
    ISBN-13: 9781583478806
    Format: Paperback
    Product Dimensions: 7 x 0.8 x 9 inches
    Shipping Weight: 1.2 pounds
    Language: English




Related Items