|
BlueFinity's mv.SSIS
Extending MultiValue Data
Integration
mv.SSIS provides seamless
integration between MultiValue databases and Microsoft SQL Server
2005 and 2008 by utilizing Microsoft SQL Server Integration Services
(SSIS).
mv.SSIS effectively opens up the
entire SQL Server set of tools and utilities to MultiValue database
users. It ensures that the way in which MultiValue data is accessed
within SSIS is a natural extension to the SSIS way of doing things.
This brings many advantages to the user/developer, not least the
ability to send e-mail messages in response to SSIS events, update
data warehouses, clean and mine data, and manage SQL Server objects
and data. By providing a tight, seamless and natural extension to
the standard SSIS environment, mv.SSIS makes SQL Server-based
capabilities within your MultiValue environment a reality.
What is Microsoft’s SSIS?
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. SSIS is a platform for building
enterprise-level data integration and data transformations
solutions. You use Integration Services to solve complex business
problems by copying or downloading files, sending e-mail messages in
response to events, updating data warehouses, cleaning and mining
data, and managing SQL Server objects and data.
SSIS Packages
Integration Services includes a rich set of built-in tasks and
transformations; tools for constructing packages to design control
flow data processing logic; and the Integration Services service for
running and managing these packages. You can use the graphical
Integration Services tools to create solutions without writing a
single line of code; or you can program the extensive Integration
Services object model to create packages programmatically and code
custom tasks and other package objects.
These data
‘packages’ can work alone or in conjunction with other packages to
address complex business needs. Integration Services can extract and
transform data from a wide variety of sources such as XML data
files, flat files, and relational data sources, and then load the
data into one or more destinations.
Once
designed, these packages are compiled into ‘.dtsx’ packages which
can then be distributed and run on any machine with the SSIS tools
installed.
BlueFinity's SSIS Solution
mv.SSIS provides the SSIS developer with a tightly integrated,
natural extension to the native SSIS environment allowing them to
seamlessly incorporate MultiValue data sources into their existing
or new SSIS workflow packages.
mv.SSIS
provides two objects within the SSIS toolkit and utilizes
BlueFinity's mv.NET product to connect to a MultiValue database: an
"mv.NET Connection Manager" and 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
scheduling features, allowing the developer to define when data
transfers are to be initiated from within the Windows environment.
Additionally, on MultiValue databases which support file ‘triggers’,
transfers can also be initiated from the MultiValue database
environment based on file updates using mv.NET's existing DBRPC
capabilities.
mv.SSIS is another piece in the
jigsaw of allowing MultiValue developers to participate as
first-class citizens in the Microsoft world.
Free Trial:
Download mv.SSIS
Free Webinar:
Register to Attend
For more information, email
sales@bluefinity.com. |