Software and Hardware Requirements

Software and Hardware requirements for installation components

BimlStudio

BimlFlex Excel Plugin

Databases

Developer installation

A developer installation is assumed to be either on a development database server with SQL Server installed or a client Windows installation (local or hosted) where the developer will use both BimlStudio, BimlFlex Excel Metadata editor, Visual Studio SSDT BI and SQL Server Management Studio to develop the Data Warehouse solution.

The developer installation required full development licensing including both BimlStudio and BimlFlex for each developer.

Considering the recurring requirement to be able to run all these applications at once it is recommended that the machine used is high-powered.

The developer also needs internet access for license key validations as well as network access to all required databases. This normally includes source systems, BimlFlex databases, Data Warehouse databases. All BimlFlex work requires access to the BimlFlex metadata database.

More information on the Developer Installation can be found here

Analyst Installation

An Analyst installation is assumed to be on a client Windows installation where the Analyst uses BimlFlex Excel Metadata editor to prepare the required metadata and source to target mappings so that the destination Data Warehouse aligns with the necessary business requirements.

It is the Analysis job to translate the system of origin schema and data into the target models such as Raw and Business Data Vaults and presentation layer. This typically requires access to modeling and analysis tools such as SQL Server Management Studio. Some modeling can be done without access to source/destination databases, but it is recommended to maintain access to the origin and target databases for analyst work. All BimlFlex work required access to the BimlFlex metadata database.

More information on the Analyst Installation can be found here

Server installation

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 the Varigence Product Suite installer.

The Varigence SSIS Components can also be installed using the XCOPY scripts provide by contacting BimlFlex support.

The SQL Server where the Data Warehouse databases are deployed requires no specific installations or configurations. It is necessary that the developers and analysts 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.

More information on the Server installation can be found here

Database requirements

BimlFlex

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

All developers and analysts using either BimlStudio or 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.

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.