Skip to main content

Software and Hardware Requirements

BimlStudio

BimlFlex App

BimlFlex Excel Add-in

Databases

Server installation

  • A supported version of Microsoft SQL Server

The base requirements for installing Microsoft SQL Server can be found here: https://docs.microsoft.com/en-us/sql/sql-server/install/hardware-and-software-requirements-for-installing-sql-server

The SSIS Server where SQL Server SSIS is used to execute SSIS packages requires the installation of the Varigence SSIS Custom Components using either the Varigence BimlFlex Developer installer or BimlFlex Runtime installer.

The SQL Server where the Data Warehouse databases are deployed requires no specific installations or configurations. The developers and analysts must have adequate access to building the Data Warehouse.

The SQL Server where the BimlFlex metadata databases are deployed requires no specific installations or configurations. It is required that the developers and analysts have adequate access to work with the metadata and target databases.

Database requirements

BimlFlex

The BimlFlex environment requires a metadata database installed/configured and available on SQL Server.

All developers and analysts using either BimlStudio, the BimlFlex Applicationor the Excel-based metadata management plugin need access to and rights to the metadata database. These access rights can be defined through AD accounts or SQL Logins.

The database must be backed up as required in case of database server failures or for rollback requirements

More information: BimlFlex metadata database

BimlCatalog

BimlFlex also requires an orchestration database for all orchestration, logging, and auditing to be installed/configured and available on SQL Server.

For installations and configurations using SSIS with package deployment methods (such as SQL Server 2008R2), there is also a requirement for an SSIS logging table. This is integrated into the BimlCatalog database.

The database must be backed up as required in case of database server failures or for rollback requirements

More information: BimlCatalog database