Business Intelligence Development Studio

Developer(s)	Microsoft
Operating system	Windows
License	Proprietary

Business Intelligence Development Studio (BIDS) is the former

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 BI Developer Extensions (previously known as 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). Business Intelligence Development Studio is hosted on Microsoft's project hosting website GitHub.^[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

^ "BI Developer Extensions". Retrieved 14 February 2022.

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

This article about software created, produced or developed by Microsoft is a stub. You can help Wikipedia by expanding it.

[1] "BI Developer Extensions". Retrieved 14 February 2022.

[1]

Visual Studio		Code Express Team System Profiler Tools for Applications Tools for Office
Others	Blend Expression Web FxCop GW-BASIC MACRO-80 Macro Assembler MSBuild Pascal QuickBASIC QBasic QuickC Robotics Developer Studio Roslyn SharePoint Designer FrontPage Small Basic WebMatrix Windows App SDK Windows App Studio Windows SDK CLR Profiler ILAsm Native Image Generator WinDiff XAMLPad

Native	Windows API Silverlight XNA DirectX Managed DirectX UWP Xbox Development Kit Windows Installer WinUI
.NET	ASP.NET Core AJAX Dynamic Data MVC Razor Web Forms ADO.NET Entity Framework MAUI CardSpace Communication Foundation Identity Foundation LINQ Presentation Foundation Workflow Foundation
Device drivers	WDK WDF KMDF UMDF Windows HLK WDM

SQL Server	Express Compact Management Studio Business Intelligence Development Studio MSDE
SQL services	Analysis Reporting Integration Notification
Other	Visual FoxPro Microsoft Access Access Database Engine Extensible Storage Engine