Seamlessly Transfer MultiValue Data into Microsoft SQL Server
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 database. 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 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 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 SSIS environment. This opens up the entire SQL Server set of tools and utilities to MultiValue database users.
mv.SSIS allows the functionality of the standard drag-and-drop 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.
"mv.SSIS ensures that the way in which MultiValue data is accessed within SSIS is a natural extension to the SSIS way of doing things," explains David Cooper, Lead Developer at BlueFinity. "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."
BlueFinity will demonstrate how to create a simple SSIS transformation to move MultiValue data into MS SQL Server using mv.SSIS in a free webinar on November 30th.