{"product_id":"9781430247920","title":"SQL Server 2012 Data Integration Recipes: Solutions for Integration Services and Other ETL Tools","description":"\u003cp\u003e\u003cem\u003eSQL Server 2012 Data Integration Recipes\u003c\/em\u003e provides focused and practical solutions to real world problems of data integration. Need to import data into SQL Server from an outside source? Need to export data and send it to another system? \u003cem\u003eSQL Server 2012 Data Integration Recipes\u003c\/em\u003e has your back. You'll find solutions for importing from Microsoft Office data stores such as Excel and Access, from text files such as CSV files, from XML, from other database brands such as Oracle and MySQL, and even from other SQL Server databases. You'll learn techniques for managing metadata, transforming data to meet the needs of the target system, handling exceptions and errors, and much more.\u003c\/p\u003e\u003cp\u003eWhat DBA or developer isn't faced with the need to move data back and forth? Author Adam Aspin brings 10 years of extensive ETL experience involving SQL Server, and especially satellite products such as Data Transformation Services and SQL Server Integration Services. Extensive coverage is given to Integration Services, Microsoft's flagship tool for data integration in SQL Server environments. Coverage is also given to the broader range of tools such as OPENDATASOURCE, linked servers, OPENROWSET, Migration Assistant for Access, BCP Import, and BULK INSERT just to name a few. If you're looking for a resource to cover data integration and ETL across the gamut of Microsoft's SQL Server toolset, \u003cem\u003eSQL Server 2012 Data Integration Recipes\u003c\/em\u003e is the one book that will meet your needs.\u003c\/p\u003e\u003cul\u003e\n\u003cli\u003eProvides practical and proven solutions towards creating resilient ETL environments \u003c\/li\u003e\n\u003cli\u003eClearly answers the tough questions which professionals ask \u003c\/li\u003e\n\u003cli\u003eGoes beyond the tools to a thorough discussion of the underlying techniques \u003c\/li\u003e\n\u003cli\u003eCovers the gamut of data integration, beyond just SSIS \u003c\/li\u003e\n\u003cli\u003eIncludes example databases and files to allow readers to test the recipes \u003c\/li\u003e\n\u003c\/ul\u003eWhat you’ll learn\u003cul\u003e   \u003cli\u003eImport and export to and from CSV files, XML files, and other text-based sources. \u003c\/li\u003e   \u003cli\u003eMove data between SQL databases, including SQL Server and others such as Oracle Database and MySQL. \u003c\/li\u003e   \u003cli\u003eDiscover and manage metadata held in various database systems. \u003c\/li\u003e   \u003cli\u003eRemove duplicates and consolidate from multiple sources. \u003c\/li\u003e   \u003cli\u003eTransform data to meet the needs of target systems. \u003c\/li\u003e   \u003cli\u003eProfile source data as part of the discovery process. \u003c\/li\u003e   \u003cli\u003eLog and manage errors and exceptions during an ETL process. \u003c\/li\u003e   \u003cli\u003eImprove efficiency by detecting and processing only changed data. \u003c\/li\u003e  \u003c\/ul\u003e  Who this book is for      \u003cp\u003e     \u003cem\u003eSQL Server 2012 Data Integration Recipes\u003c\/em\u003e is written for developers wishing to find fast and reliable solutions for importing and exporting to and from SQL Server. The book appeals to DBAs as well, who are often tasked with implementing ETL processes. Developers and DBAs moving to SQL Server from other platforms will find the succinct, example-based approach ideal for quickly applying their general ETL knowledge to the specific tools provided as part of a SQL Server environment.         \u003c\/p\u003e     Table of Contents\u003col\u003e   \u003cli\u003eMS Office Data Sources \u003c\/li\u003e   \u003cli\u003eFlat File Sources \u003c\/li\u003e   \u003cli\u003eXML Data Sources \u003c\/li\u003e   \u003cli\u003eSQL Database Sources \u003c\/li\u003e   \u003cli\u003eSQL Server Sources \u003c\/li\u003e   \u003cli\u003eMiscellaneous Data Sources \u003c\/li\u003e   \u003cli\u003eExporting Data from SQL Server \u003c\/li\u003e   \u003cli\u003eMetadata \u003c\/li\u003e   \u003cli\u003eData Transformation \u003c\/li\u003e   \u003cli\u003eData Profiling \u003c\/li\u003e   \u003cli\u003eDelta Data Management \u003c\/li\u003e   \u003cli\u003eChange Tracking and Change Data Capture  \u003c\/li\u003e   \u003cli\u003eOptimising Data Import \u003c\/li\u003e   \u003cli\u003eET Process Acceleration \u003c\/li\u003e   \u003cli\u003eLogging and Auditing \u003c\/li\u003e   \u003cli\u003eAppendix A: Data Types \u003c\/li\u003e   \u003cli\u003eAppendix B: Sample Databases and Scripts \u003c\/li\u003e  \u003c\/ol\u003e","brand":"Apress","offers":[{"title":"Default Title","offer_id":47153939611888,"sku":"9781430247920","price":39.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0737\/7593\/9824\/files\/9781430247920_p0.jpg?v=1763750976","url":"https:\/\/shop-qa.barnesandnoble.com\/products\/9781430247920","provider":"Barnes \u0026 Noble (DEV)","version":"1.0","type":"link"}