|
 BlueFinity's mv.SSIS
Extending MultiValue Data
Integration
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. |
