Do your business apps access different data sources? This book shows you how to make that task easier
by Steven Cole
As a developer, I have often worked with business applications that pull in data from various sources, such as files or databases, and send that data to multiple destinations. This sounds simple enough, but clients and/or applications typically do not send or receive data the same way. So, what happens when you must update that data for the destination to take it in? There are multiple tools you can use to modify (transform) this data—essentially, the extract, transform, and load (ETL) concept. Wouldn’t it be great to have one tool to handle multiple ETL scenarios? That’s where Extract, Transform, and Load with SQL Server Integration Services: With Microsoft SQL Server, Oracle, and DB2 comes into play. This book is exactly what the title states. In it, authors Thomas Snyder and Vedish Shah dive into how to use Microsoft’s SQL Server Integration Services (SSIS) to accomplish these tasks.