Table Driven Design, No .Net Code, No huge fees
BimlSnap will revolutionize your SSIS Package development. Leveraging the magic of BIML (Business Intelligence Markup Language), BimlSnap enables a code-reuse paradigm in SSIS, yielding a 10x acceleration in the creation, and maintenance of your ELT/ETL projects. BimlSnap includes an on-premise copy of the BimlSnap SQL Server database (open source!). 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.
Advantages At a glance:
Developers can focus on business logic, rather than worrying about the drudgery and minutiae of data movement and transformation programming
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
There are no requirements to learn additional programming languages such as C# or VB.Net. Only standard SQL programming skills are required
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.