Our tools

MDX Studio

v.0.4.15

MDX Studio is a tool that has been developed by Mosha Pasumansky, a former developer of Analysis Services.

This is an invaluable tool to write a MDX query: you have a code formatting feature, an embedded system to analyze query performance and many other features for writing MDX queries.

DAX Studio

daxstudio-logo_250x250

DAX Studio is an Excel Add-In for Power Pivot and Analysis Services Tabular projects that helps you writing and executing DAX queries.

It includes an Object Browser, query editing and execution, formula and measure editing and syntax highlighting.

DtsToSsis-Prepare

v.1.0

DtsToSsis-Prepare is a command line tool that prepares a DTS package for a better migration to an SSIS package.

This article describes the needs for this tool and how to use it.

The project is freeware, full source code is available.

MirrorManager

Beta 1

MirrorManager is a tool that implements the Mirror phase of the SQLBI Methodology in a semi-automated way. It handles partitioning and aging of imported data.

Visio Forward Engineer

Visio Forward Engineer is an Office 2010 add in that provides Visio the ability to script the database creation of a data model. Even if it contains several limitations, it helps Office Visio users to create simple data models using the Visio interface without the need to install the older 2003 Enterprise Architect version.

SQLBI DtExec

v.1.0

SqlBiDtExec is a tool that makes it easy to launch SSIS packages on a remote server, using WCF as the transport media to both request package execution and fetch all the logs and events from the package in order to use them at the client side.

FlowSync

FlowSync is a component that will make two or more flows of data in an SSIS data flow package run at the same speed, by stopping one flow if the others run too slow.

The project is freeware, full source code is available.

TableDifference

TableDifference is an SSIS custom component designed to simplify the management of slowly changing dimensions and – in general – to check the differences between two tables or data flow with SSIS.

Distinct

v.1.0

Distinct is a partially blocking component that remove duplicates from one flow.

MdxScriptUpdater

v.1.0

MdxScriptUpdater is a simple C# class that simplifies updating MDX Scripts into a cube in a production environment. MdxScriptUpdater is provided in form of a sample source code as is.

DateTool Dimension

v.0.6

DateTool is a special dimension containing regular members that act as calculated members similar to those generated by Time Intelligence Wizard, without some of the limitations of the Time Intelligence Wizard.

SQLBulkTool

v.1.0

SqlBulkTool is a command line utility that is used to quickly create a mirror of a database. It reads its configuration from an XML file containing source and destination command strings and a list of all the tables to mirror and then handles the work of copying the database in an automated and highly parallelized way.