About the Talk
July 18, 2013 3:00 PM
Denver Microsoft Office - DTCDenver Microsoft Office - DTC
In this demo-rich session, we will explore database and ETL architectures that let you smoothly move data from your application databases across the enterprise in real time to your data warehouse. You will see how to use SQL Server features such as replication, Change Data Capture, SSIS, and other techniques to extract, transform, and load fast anddependably. We will develop an actual sample system during the session and discuss and walk through alternative real-time architectures, including the use of Data Vault methodologies. We will then see how to use Reporting Services and Power View to present data with aminimum amount of latency.