Business Intelligence Development Studio

Business Intelligence Development Studio (BIDS) is the former IDE from Microsoft, and was used to develop 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 customized with the SQL Server services-specific extensions and project types, including tools, controls and projects for reports, ETL dataflows, OLAP cubes and data mining structure.

BIDS functionality can be augmented with BIDS Helper, a Visual Studio add-in with features that extended and enhance business intelligence development functionality in SQL Server 2005, 2008, and 2008 R2 BI Development Studio (BIDS) and SQL Server 2012 SQL Server Data Tools (SSDT). BIDS Helper is hosted on Microsoft's open source project hosting website CodePlex.^[1]

Business Intelligence Markup Language (Biml) can be used in BIDS to create end-to-end BI solutions by translating Biml metadata into SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS) assets for the Microsoft SQL Server platform.

BIDS is not supported with Visual Studio 2010 and later, and has been replaced by SQL Server Data Tools - Business Intelligence.

References

↑ "BIDS Helper-Home Page". Retrieved November 5, 2012.

External links

SQL Server Data Tools
Introducing Business Intelligence Development Studio
BIDS Helper - Microsoft Visual Studio and SQL Server extension
bimlscript.com - Biml online community

Microsoft development tools

Development
environments

Visual Studio	Code Express Lab Management Team System Profiler Test Professional Tools for Applications Tools for Office

Others	.NET Compiler Platform App Studio Blend Expression Web GW-BASIC Microsoft Pascal MSBuild Robotics Developer Studio SharePoint Designer FrontPage PowerShell ISE QuickBASIC QBasic QuickC Small Basic WebMatrix Windows SDK CLR Profiler ILAsm Native Image Generator XAMLPad

Languages

Major APIs and
frameworks
(See all)

Windows API Silverlight XNA DirectX Managed DirectX Xbox Development Kit Windows Installer

.NET Framework	ASP.NET ASP.NET Core ASP.NET AJAX ASP.NET Dynamic Data ASP.NET MVC ASP.NET Razor ADO.NET Entity Framework CardSpace Communication Foundation Identity Foundation LINQ Presentation Foundation Workflow Foundation

Device drivers	WDK WDF KMDF UMDF Windows Hardware Certification Kit WDM

Database

SQL Server	Express Compact Management Studio Business Intelligence Development Studio MSDE

SQL services	Analysis Reporting Integration Notification

Other	Visual FoxPro Microsoft Access Jet Engine Extensible Storage Engine Azure DocumentDB

Source control

Delivery

This article is issued from Wikipedia - version of the 5/23/2016. The text is available under the Creative Commons Attribution/Share Alike but additional terms may apply for the media files.