Seamless Data Transfer Between MultiValue Databases and SQL Server Using mv.SSIS
jBASE International, a member
of the Mpower1 Group of Companies, has added a new
product to its range of Microsoft development tools
for MultiValue users.
mv.SSIS allows MultiValue users to extract data
from any major MultiValue database (in both bulk
and filtered export mode) into MS SQL Server using
Microsoft's SQL Server Integration Services (SSIS)
product.
“mv.SSIS effectively opens up the entire SQL Server
set of tools and utilities to MultiValue database
users,” explains David Cooper, Lead Developer at
BlueFinity International.
BlueFinity are the creators of mv.SSIS and
sister company to jBASE International under the
Mpower1 umbrella. "With our mv.SSIS product we have
ensured 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 email 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.”
Microsoft 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).
Once designed, these processes are compiled into
‘packages’ which can then be distributed and run on
any machine with the SSIS tools installed to address
complex business needs.
The new mv.SSIS product provides a tightly
integrated extension to the native SSIS environment,
allowing developers to incorporate MultiValue data
sources into their existing or new SSIS workflow
packages. It allows drag-and-drop creation of
standard SSIS packages within the SSIS design
studio, providing seamless transfer of data between
MultiValue databases and SQL Server 2005 and 2008 by
utilizing SSIS.
mv.SSIS provides two new objects within the SSIS
toolkit and utilizes BlueFinity's mv.NET product to
connect to a MultiValue database: mv.NET Connection
Manager and 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.”
BlueFinity products provide developers with
flexibility to ensure that applications can be
deployed across a range of databases. They are
currently available on D3, jBASE, mvBASE, Reality,
Power95, QM, UniData, UniVerse and UniVision and
others by request.
##
About jBASE International
jBASE International, a member of the Mpower1
group of companies, is a leading supplier of
database management software and web enabling
tools for developing, deploying, and maintaining
business applications solutions. The flagship
product, jBASE, was designed from the ground up
to be an open database product that would bring
the strengths of MultiValue technology into the
mainstream computing market. With exclusive
worldwide distribution rights, jBASE
International offers technologies and assistance
that allow businesses to thrive into the
future.