Newsletters




BlueFinity Enables Seamless Data Transfer Between MultiValue Databases and SQL Server Using mv.SSIS


Bookmark and Share

BlueFinity International, a member of the Mpower1 Group of Companies, has added a new product to its range of Microsoft development tools for MultiValue users. BlueFinity's 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. "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.

BlueFinity's 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.

BlueFinity is planning a one-day technical seminar in Denver, Colo., on Friday, March 27, at the Westin Westminster Hotel to showcase the product set. More information is available here.


Sponsors