Microsoft Office Tutorials and References
In Depth Information
Figure 1-13. Executing a simple OLTP SQL query in SSMS
SQL Server Data Tools
While Visual Studio is the developer’s rapid application development tool, SQL Server Data Tools or SSDT (formerly
known as Business Intelligence Development Studio or BIDS) is the equivalent development tool for the database
developer. (See Figure 1-14 .) SSDT looks like Visual Studio and supports the following set of templates, classified as
Business Intelligence templates:
Analysis Services Templates
Analysis Services Multidimensional and Data Mining Project: The template used to
create conventional cubes, measures, and dimensions, and other related objects
Import from Server (Multidimensional and Data Mining): The template for creating an
analysis services project based on a multidimensional analysis services database
Analysis Services Tabular Project: Analysis service template to create Tabular Models,
introduced with SQL Server 2012
Import from PowerPivot: Allows creation of a Tabular Model project by extracting
metadata and data from a PowerPivot for Excel workbook
Import from Server (Tabular): The template for creating an analysis services Tabular
Model project based on an existing analysis services tabular database
Integration Services Templates
Integration Services Project: The template used to perform ETL operations
Integration Services Import Project Wizard: Wizard to import an existing integration
services project from a deployment file or from an integration services catalog
Search JabSto ::

Custom Search