BlueFinity Extends MultiValue Data Integration with New mv.SSISmv.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 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 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" 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. |
About BlueFinity International BlueFinity International supplies leading-edge software development tools and consultancy services to the MultiValue database and Microsoft developer communities. The flagship product, mv.NET, is a comprehensive solution for developers wishing to access MultiValue databases from within Microsoft's .NET environment. mv.NET provides a 100% native .NET interface to all MultiValue database platforms, allowing .NET developers to access all aspects of MultiValue systems, data and program code,from within their .NET application. As a thriving member of Mpower1 International's Business Management Programs, BlueFinity is backed by a forward thinking organization with an excellent and dedicated management team, clear vision, strong mission and the financial backing required for future development.
|
Home | About Us | Our Business | Mpower1 Companies | Press | Contact Us | Giving Back | View our Privacy and Cookie Policy |