About bimlSnap

Table Driven Design,   No .Net Code,   No huge fees

Advantages At a glance: 

Business Logic

Developers can focus on business logic, rather than worrying about the drudgery and minutiae of data movement and transformation programming

Methodology

All developers working on the platform adhere to the same development methodology. This is extremely effective for standardized SSIS package development, code reuse, as well as ease and predictability of your ELT/ETL project maintenance

No Programming

There are no requirements to learn additional programming languages such as C# or VB.Net. Only standard SQL programming skills are required

ROI

The ROI for using BimlSnap is crazy quick, with low monthly subscription fees

Typical SSIS package development  can be difficult and time consuming.  An ELT/ETL project can take weeks if not months depending on the number of  tables, complexity of transformations, and the ‘solution framework’ requirements. With no meaningful code re-use provided out-of-the-box, SSIS developers spend a far too much time doing repetitive clicks, drags and drops, and constantly re-creating the wheel. This approach invariably produces complex, non-standard and buggy code.

That’s where bimlSnap can revolutionize your ELT/ETL process.  As one of our clients told us:

​

“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.”

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!

How does bimlSnap work?

Standardized Patterns & 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.

BimlSnap includes an on-premise copy of the open source BimlSnap SQL Server database. The solution includes automated SSIS project/package creation, Data-warehousing package patterns (for Fact and Dimension tables), elegant code generators (for both T-SQL and snowSQL), a fully integrated database Metadata Management system, and a 'template driven' run-time framework, extending the standard SSISDB database.