Database.ca SQL Server Blog

My Blog

Friday, February 14 2014

Keywords: SQL Server BI, Business Intelligence, B.I., Analysis Services Project in VS2012, Visual Studio 2012 BI Project, SSDT

Getting Started With SQL Server BI and SSDT on Visual Studio 2012, Part 1

This is part one of a series to come on installing and using SQL Server Data Tools and creating Business Intelligence projects in Visual Studio 2012.

 

In this first blog, I would like to show you exactly how to get your workstation ready and what you require to start developing SQL Server B.I. solutions with Visual Studio 2012.

 

Here is the list of what you would require:
 
1) SQL Server In my examples I will be using SQL Server 2012, but you could use other versions as well.

 

2) Visual Studio 2012 various editions.
 
3) SSDT for Visual Studio 2012 also known as SQL Server Data Tools, you need to get the Visual Studio 2012 edition from the official download page

 

4) SQL Server Data-Tier Application Framework On the download page you could be given the choice of downloading 32bit or 64bit versions of several files. You need to download the specific version of this framework that matches your version of SQL Server, and the bit-width you need.
 
Get SQL Serer 2012 framework from here.
Get SQL Server 2014 CTP2 framework from here.
Search for SQL Server 2008 and 2008 R2 Data-Tier Application Framework in your favorite search engine.

 

SQL Server BI, Business Intelligence, B.I., Analysis Services Project in VS2012, Visual Studio 2012 BI Project, SSDT

5) Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2012 Microsoft really went out of their way in order to complicate the life of B.I. developers...this used to be certainly easier done with Visual Studio 2010...SSDT was all that was needed at the time...Don't despair, we are almost done. You could download this very important tool from here.
 
Tip for when installing this tool: When prompted, select 'Perform a new installation of SQL Server' as opposed to 'Add features to an existing instance of SQL Server'. Do not worry, the installation will only install shared components and not a whole near instance of SQL Server.

 

SQL Server BI, Business Intelligence, B.I., Analysis Services Project in VS2012, Visual Studio 2012 BI Project, SSDT

6) Update your SQL Server 2012 I have greatly simplified this step for you. To know exactly what version you have installed and what is the latest version out there, take a look at Database.ca's very own SQL Server Builds Reference Table.

 

7) Update your Visual Studio 2012! Make sure your VS is up to date.

 

SQL Server BI, Business Intelligence, B.I., Analysis Services Project in VS2012, Visual Studio 2012 BI Project, SSDT

 

SQL Server BI, Business Intelligence, B.I., Analysis Services Project in VS2012, Visual Studio 2012 BI Project, SSDT

 

SQL Server BI, Business Intelligence, B.I., Analysis Services Project in VS2012, Visual Studio 2012 BI Project, SSDT

Written by Ramin Haghighat