BlueFinity Extends MultiValue Data Integration with New mv.SSIS

mv.SSIS is a SQL Server Integration Services (SSIS) component which provides complete integration of the mv.NET ADO.NET provider with the SSIS environment.  This allows drag-and-drop creation of standard SSIS packages within the SSIS design studio, providing seamless transfer of data between MultiValue databases and SQL. 

mv.SSIS allows MultiValue users to extract data from any major MultiValue database (in both bulk and filtered export mode) to other data repositories using Microsoft's SQL Server Integration Services (SSIS) product.  The definition, testing and execution of these extraction processes is performed entirely from within the standard SSIS environment and ensures data consistency, eliminates redundant data and saves time.

Introduction
Microsoft SQL Server is delivered with a sophisticated tool set called SQL Server Integration Services, SSIS, to enable data from multiple sources to be consumed. BlueFinity’s mv.SSIS product is designed to provide a seamless integration between a MultiValue database(s) and Microsoft SQL Server 2005 and 2008 by utilizing SSIS. SSIS is a graphical based integration tool which allows data flow processes to be built for purposes such as data mining, data migration, reporting and OLAP (OnLine Analytical Processing).

The new BlueFinity product, mv.SSIS, allows data to be read from MultiValue databases into the SSIS environment.  This opens up the entire SQL Server set of tools and utilities to MultiValue database users.

SSIS in Brief
SSIS provides a graphical front end to design control flow data processing logic.  Once designed, these ‘packages’ are compiled into ‘.dtsx’ packages which can then be distributed and run on any machine with the SSIS tools installed.

Packages contain two main logic flows, a ‘Control Flow’ which defines a sequence of logical operations which are processed in sequence. Each step is completed before the next starts e.g.

Empty out work tables in a database

Populate the work tables with data

Perform calculations and update the values in the work table

Update OLAP cubes with the data from the work tables

Run reports against the OLAP cubes.

This level of control also allows processing loops to be defined e.g.

For each file in a specified folder, read the contents of the file and write it into a specified table.

The second main logic flow is the ‘Data Flow’.  This allows for the processing of data at the record level. Data is read from a ‘Data Source’ and passes down a series of ‘Data Transformations’ to a ‘Data Destination’. These transformations can be as simple as changing the data type of fields e.g. varchar(4000) to varchar(2000) or decimal(18,2) to decimal(8,2), or can be more complex like data merges, joins, pivot tables, multicasts etc. Each transformation is represented by an icon in the designer and the icons are linked together to define the logic path.

BlueFinity's SSIS Solution

mv.SSIS provides two new objects within the SSIS toolkit and utilizes BlueFinity's mv.NET product to connect to a MultiValue database:

An "mv.NET Connection Manager"
An  "mv.NET Data Source"

The Connection Manager provides an SSIS-aware connection to an mv.NET-based data provider which then can be used throughout an SSIS package.

Data sources are used within ‘Data Flows’ and use a Connection Manager to connect to a data provider and then feed data into the rest of the ‘Data Flow’.

To connect to a MultiValue database from within an SSIS package, the user must first add an mv.NET Connection Manager to the package then within a ‘Data Flow Task’ add an mv.NET Data Source.

From within the custom mv.SSIS data source editor the user can define what data they want to read into the process.  The rest of the transformations and destinations are then defined as per the user's requirements using any of the standard SSIS ‘Data Flow Transformations’ and  ‘Data Flow Destinations’.

SSIS provides comprehensive facilities to enable schedules to be configured to manage the data transfers.  However on MultiValue databases that support ‘triggers’ transfers can be actioned based on these advanced features in the database and supported by mv.NET.

For more information, email sales@bluefinity.com.

  Home |  About Us  |  Our Business  |  Mpower1 Companies  |  Press  |  Contact Us  |  Giving Back  |                                  View our Privacy and Cookie Policy