microsoft access 2013 tutorial level 1 part 06 of 12

You need to transform, modify, integrate, etc. What I am going to use is SSIS because if you are doing serious ETL work, you are not going to rely heavily on a simple data movement tool like BCP or a migration wizard. I give this entire discussion much more attention in my MSSQLDUDE blog here. Works great, using BCP and takes care of lot of the SQL Azure-specific house-keeping things like creating clustered indexes for all tables that you are transferring to Azure that do not have clustered indexes. It’s a great free tool, very simple, very engineer-based. The classis Codeplex project called SQL Azure Migration Wizard moves data & schemas from on-prem SQL Server to SQL Azure. The newest CTP of the Data Sync framework will now move SQL databases from prem to cloud, back & forth, cloud data centers, etc. This is the classic starting point of a business intelligence solution: move the data from transactional systems into a data warehouse or data mart for analysis and reporting.įor SQL Azure, you can get your data and schemas to the cloud with several different tools. We have transactional data from our stores in Adventure Works stored in a centralized data-center based SQL Server 2008 R2 database.

Let’s start with the assumption that we’ve built a data mart in the Cloud using SQL Azure. But I can build a Cloud-based application and dashboard in Azure that is using data from SQL Azure, in the cloud, and I can now create cloud-based reports using Azure Reporting Services (CTP). If I want to build an analysis cube around my data, I can store the data in SQL Azure in the cloud, but my cube will have to be on-premises in SSAS or PowerPivot.

By then end of the series, I will probably not be able to put a complete solution “in the Cloud”. Starting here in part 1, I am going to walk through a complete example of building a Cloud BI solution using only Microsoft technologies from SQL Server, Azure and Office.

I’m going to try to expand a bit on the posting that I did last month describing different definitions of “Cloud BI” and what that means in Microsoft-speak.

Microsoft access 2013 tutorial level 1 part 06 of 12