How it Works
Standardized Patterns and Pure Biml
SQL Server natively holds the metadata for the tables you want to populate. We use Stored Procedures that reference this metadata, apply standardized ETL patterns, and output pure BIML files (simple XML). We then use Visual Studio (SSDT), along with the add-in BIDS Helper, or BIML Express, to emit fully functional SSIS projects and packages.
Testimonials
“Building packages in SSIS before was like walking ten miles to get to the grocery store. Using bimlSnap is making that same trip in a car.”
Anyone Can Use It
One of the most liberating aspects of bimlSnap is that anyone who knows SQL can build professional grade SSIS Packages. Absolutely no .NET coding skills, and practically no SSIS experience are needed to rapidly generate your ELT/ETL packages. The end results are Projects and Packages that are build using SSIS best practices, and which utilize a standard SSIS framework. In addition, BimlSnap provides auto generated documentation, and even a PowerBi dashboard to trend the runtime performance of you ELT/ETL projects.
All this will be accomplished with the least amount of friction, and in a time frame that you may call, well… a snap!