Business Intelligence Development Studio

November 12, 2008

Business Intelligence Development Studio is Microsoft Visual Studio 2008 with additional project types that are specific to SQL Server business intelligence. Business Intelligence Development Studio is the primary environment that you will use to develop business solutions that include Analysis Services, Integration Services, and Reporting Services projects. Each project type supplies templates for creating the objects required for business intelligence solutions, and provides a variety of designers, tools, and wizards to work with the objects.

Business Intelligence Development Studio (BIDS) is an application developed by Microsoft used for developing data analysis and Business Intelligence solutions utilizing the Microsoft SQL Server Analysis Services, Reporting Services and Integration Services. It is based on the Microsoft Visual Studio development environment but customizes with the SQL Server services-specific extensions and project types, including tools, controls and projects for reports, ETL dataflows, OLAP cubes and data mining structures.

Business Intelligence Development Studio, the 32-bit development environment for Analysis Services, Integration Services, and Reporting Services projects, is not designed to run on the Itanium 64-bit architecture and is not installed on Itanium servers.

Tags: Analytical Tool, Business Intelligence, Data Mining, ETL, Integration Services, OLAP, Reporting Services