mv.SSIS: MultiValue Integration with SQL

BlueFinity International's mv.SSIS product allows data to be read from any major MultiValue database directly (with no intermediate file processing) into the Microsoft SSIS environment. It ensures that the way in which MultiValue data is accessed within Microsoft SSIS is a natural extension to the SSIS way of doing things. Mv.SSIS provides a seamless and natural extension to the standard Microsoft SSIS environment, for SQL Server-based capabilities such as data mining, data migration, reporting and Online Analytical Processing.

 


Using SSIS to integrate MultiValue data into Microsoft SQL

What is SSIS? How does BlueFinity integrate with SSIS? What kind of things do customers do with it?

Technical Overview and User Guide

The contents of this Guide are designed to allow a developer to easily install, configure and use the wealth of functionality provided by the mv.SSIS product.

Download



mv.SSIS makes SQL Server 2017/2019 based capabilities within your MultiValue environment a reality!

Microsoft SQL Server includes a sophisticated tool set called SQL Server Integration Services (SSIS) which provides a rich environment for developers to define how external data is to be imported into a SQL Server database.  Microsoft SSIS is a graphical based tool which runs inside Visual Studio and allows you to define data import activities (termed 'data transformations') in order to control the transfer of data into Microsoft SQL Server.   Once data is within SQL Server, a host of SQL-based tools may be utilized for purposes such as data mining, data migration, reporting services and OLAP (Online Analytical Processing), allowing company decision makers to slice and dice data enabling them to make intelligent business decisions.

BlueFinity International's mv.SSIS product allows data to be read from any major MultiValue database directly (with no intermediate file processing) into the Microsoft SSIS environment. It ensures that the way in which MultiValue data is accessed within Microsoft 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 Microsoft 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 Microsoft SSIS environment, mv.SSIS makes SQL Server-based capabilities within your MultiValue environment a reality.  

mv.SSIS allows the functionality of the standard drag-and-drop Microsoft SSIS transformation design environment to be used to create powerful and flexible data transfer definitions. This promotes rapid and error-free transformation creation and leverages existing SSIS skills and knowledge.

  • Easy to learn and use - no programming needed

  • We do the MultiValue integration leaving you to develop the Microsoft SSIS packages

  • Deploy developed and tested Microsoft SSIS packages on to your live system

  • Bulk data transfers and "delta-data" update functionality supplied

  • Excellent performance

  • Multi-value and sub-value data normalization handled automatically

  • All MultiValue databases supported

Take advantage of the world's most widely used product when it comes to moving data into Microsoft SQL Server - Microsoft SSIS. Using Microsoft SSIS combined with BlueFinity's mv.SSIS and mv.NET products you can build complete database synchronization solutions - quickly and easily.

Be it a simple, single direction data export or a full blown bi-directional data synchronization requirement, these tools allow you to build a solution tailored to your specific needs.

For more information, please contact us or request a free trial with the documentation set.