BimlStudio User Guide
BimlStudio is the integrated development environment (IDE) for building enterprise data solutions using Biml. It provides visual editors, IntelliSense, build automation, and deployment tools for creating data warehouse solutions.
Key Features
- Visual Editors - Design tables, packages, and other assets using intuitive visual designers
- BimlScript Support - Write and preview BimlScript with full IntelliSense
- Build Automation - Generate SSIS packages, SQL scripts, and documentation
- Source Control Integration - Work with Git, Azure DevOps, and other version control systems
- Cloud Platform Support - Connect to Azure SQL, Snowflake, Databricks, and Microsoft Fabric
Supported Platforms
BimlStudio generates artifacts for multiple target platforms:
| Platform | Output Types |
|---|---|
| SQL Server | Tables, stored procedures, SSIS packages |
| Azure SQL Database | Tables, stored procedures |
| Azure Synapse Analytics | Tables, stored procedures |
| Microsoft Fabric | Tables, SQL scripts |
| Snowflake | Tables, stored procedures |
| Databricks | Delta tables, SQL scripts |
Documentation Sections
Getting Started
- AdventureWorks LT Walkthrough - Step-by-step tutorial using the AdventureWorksLT sample database
Visual Editors
- Visual Editors Overview - Complete reference for all BimlStudio editors
- Package Editor - Design SSIS packages
- Table Editor - Define database tables
- Connection Editor - Configure data connections
Reference Topics
- Miscellaneous Topics - Additional guides and configuration options
- Git Integration - Source control workflows
- Cloud Connections - Connect to cloud data platforms
- Microsoft Fabric Integration - Working with Fabric
Release Notes
- Release Notes - Version history and updates
Quick Start
- Create a project - Start with File > New Project
- Add connections - Define source and target database connections
- Import metadata - Use the Import wizard to bring in existing database schemas
- Design transformations - Create packages to move and transform data
- Build and deploy - Generate SSIS packages or SQL scripts for your target platform
System Requirements
- Windows 10 or later (64-bit)
- .NET Framework 4.8 or later
- Visual Studio 2019 or 2022 (optional, for SSIS development)
- SQL Server Data Tools (for SSIS package deployment)
Support
- Documentation - Browse this user guide
- Email Support - support@varigence.com
- Community - Varigence Community Forums