Release Date: Friday, February 13, 2009
BlueFinity International
, a member of the Mpower1 Group of Companies, is pleased to add a brand 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 Service
s product.
Microsoft SQL Server Integration Service
s (SSIS
) is a sophisticated, 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, natural extension to the native SSIS
environment allowing developers to seamlessly 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
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 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
."
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'.
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 initiated using mv.NET
's ability to monitor the database for significant events. These events, once detected by a .NET application using mv.NET
, can then be serviced by the execution of SSIS
packages.
"mv.SSIS
is another piece in the jigsaw of allowing MultiValue developers to participate as first-class citizens in the Microsoft world," says Cooper. "Its by no means the final piece, but its an important one and we are certainly experiencing a huge amount of interest in mv.SSIS
since its launch."
BlueFinity
products provide the developer with the greatest flexibility to ensure that applications can be deployed across the widest 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, Colorado on Friday, March 27th at the Westin Westminster Hotel to showcase the product set and take an in-depth technical look at the advanced functionality by way of live demonstrations and presentations with
BlueFinity
developers.
About BlueFinity International
BlueFinity International, part of the Mpower1 group of companies, supplies leading-edge software development tools and consultancy services to the MultiValue database and Microsoft developer communities. Founded in 2002, BlueFinity has created a series of products. Its flagship product - mv.NET - is a comprehensive solution for developers wishing to access MultiValue databases from within Microsoft's .NET environment.
For more information, visit http://www.bluefinity.com/
About mv.NET
A suite of components designed to provide the MultiValue developer with
a comprehensive solution to the challenge of creating Microsoft .NET
based applications requiring access to MultiValue databases
For more information, visit http://www.bluefinity.com/v4/Products/mvnet/index.html
About mv.SSIS
MultiValue / SQL Server integration and data warehouse developments.
For more information, visit http://www.bluefinity.com/v4/Products/mvssis/index.html
About D3
The D3 DBMS embodies the best and most desired features for developers and users. It is simple in its structure but allows for complex definitions of data structures and program logic. The built-in development environment allows applications to be rapidly prototyped, developed, and modified on the spot. Custom applications and on-site enhancements are common in the D3 community. Everything required for development is already in D3, making D3 much more than a typical database environment. Site administration requires a fraction of the staff of other environments of the same size - a large proportion of sites running D3 do not have an IT staff.
D3 is developed and supported over the many environments indicated on these pages. All code and data easily migrates between environments without modification, so both developers and users can work on their platforms of choice.
Other products from TigerLogic include connectivity tools like FlashCONNECT for web, the D3 Class Libraries, the Open Systems File Interface for Oracle and other environments, and XML technologies to exchange data with other XML-compliant programs or environments.
For more information, visit http://www.rainingdata.com/products/dbms/d3/index.html
About jBase
A multidimensional database, a development environment including a
development language, and a middleware component allowing other
mainstream and standards-based products to communicate with the jBASE
products. The unique jEDI middleware enables access to other databases
such as Oracle, DB2 and SQL Server. Microsoft Windows, all major Unix
platforms including Linux, and IBM's e-Servers are supported.
For more information, visit http://www.jbase.com/products/jbase.html
About Mentor/PRO
Mentor PRO is a portable, 32-bit protected mode database and native
operating environment for Intel-compatible processors which supports
up to 256 users. The integrated database environment makes it an
ideal business application environment with many ease of use features.
Mentor PROs BASIC compiler and run-time are optimized for the
database application environment and offer the best performance
available in a database environment of its kind.
PicLan, included with Mentor PRO, expands the
application environment to the network providing network connectivity
as well as network file transfer and printer sharing.
For more information, visit http://www.Tigerlogic.com
About mv*Base
mv*Base for Windows is the database environment that offers the easiest high-performance path for MultiValue database developers and users to move their applications into a Windows Client/Server environment.
mv*Base is a multivalue-compliant Windows database environment which makes the migration of multivalue applications to a Windows client/server environment fast and easy. mv*Base offers a high-performance multi-dimensional database engine including such features as multi-valued field and unlimited item size providing maximum flexibility for data organization. B-tree indexing provides enhanced performance for sorting and selecting data from BASIC applications.
For more information, visit http://www.rainingdata.com/products/dbms/mvb/index.html
About OpenQM
OpenQM is a high performance multivalue database environment with a
low price tag and close compatibility with other products.
Available for Windows, Linux, Mac, AIX and PDA, a commercial QM
licence includes the AccuTerm terminal emulator at no extra cost.
The QMClient API allows development of VB, C and web front ends.
OpenQM is the only multivalue database available both as a fully
supported commercial product and in open source form under the
General Public Licence.
For more information, visit http://www.openqm.com
About Reality
A MultiValue and relational(SQL)-enabled database, it allows users to maximise the use of existing technologies while ensuring their customers needs are met, now and in the future. While maintaining its virtual machine concept, Reality now has open interfaces - using integrated ODBC/JDBC SQL, Web Services, HTML, TCP/IP Sockets and simple extensions to DataBasic - an extended Dartmouth BASIC language with exceptional database and string handling abilities. Remote calls can also be made in order to provide integration with open Java applications and Microsoft Visual Basic/C/C++/C# and .net.
For more information, visit http://www.northgate-reality.com/
About UniData
Secure and Available 24 X 7
Tuned for business
The current economic climate demands more from your technology than ever before. While easy-to-use, high-performance solutions have always offered a faster return on investment, they may be a matter of survival today. And for businesses prepared to take advantage of changing times to position themselves for the future, they offer a competitive advantage.
UniData(r) comes into its own at times like these, delivering the capabilities you need to develop, enhance and deploy comprehensive business applications rapidly and with minimal cost.
UniData is an extended relational database ideal for embedding in vertical solutions. It allows multiple nested tables within a table, while maintaining support for ANSI SQL access. Data modeling is more intuitive and fewer tables are created compared with a traditional relational database.
Using UniData, developers can create solutions quickly and easily for a wide variety of markets. The product's real-world approach to application development and deployment minimizes time to market, which in turn saves you money and helps you compete more effectively.
Highlights
- Delivers low TCO and exceptional scalability to meet the challenges of on demand business in the SMB and large enterprise market
- Provides intuitive design and high-performance queries using extended relational data model
- Enables use of standard protocols including ODBC, OLEDB, ADO.NET, JDBC, XML and SOAP
- Supports security and robustness via encryption, authentication and high availability features
- Features native, high performance interfaces for .NET, Java(tm) and more
- Leverages application investment with flexible data storage
For more information, visit http://www.rocketsoftware.com/u2/
About UniVerse
Reliable and Flexible Foundation for Business Solutions
Successful businesses continually push themselves to find ways to maximize their effectiveness and reduce costs. UniVerse maximizes return on investment and is built to keep costs low, delivering uncompromising reliability and power with the features that successful businesses need.
UniVerse offers a unique combination of an intuitive development environment and a powerful, reliable data engine. It is easy to embed in an application and delivers high-performance and high scalability in a small footprint. On top of that, it's very easy to use and administer.
Based on technology newer than the relational model, UniVerse uses XML-like data structures resulting in fewer tables, fewer joins and better performance.
Highlights
- Provides intuitive database design and high performance data access
- Secures data through encryption and authentication
- Ensures high availability through data replication
- Enables access via a variety of APIs, protocols, frameworks and architectures
- Provides flexible data storage choices for maximum interoperability
- Accelerates time to market and lowers TCO for business solutions
For more information, visit http://www.rocketsoftware.com/u2/
About UniVision
UniVision is an industry-leading DBMS integrating powerful, high-performance MultiValue database management and Client/Server technologies in a single product.
UniVision, a significantly enhanced Pick R83, AP and D3 compatible multi-user DBMS integrates powerful, high-performance MultiValue database management and Client/Server technologies in a single product.
It offers exceptional database engine flexibility combining unparalleled multi-user connectivity with superior price/performance, and ease of use in an open systems world with integrated SQL technology.
For more information, visit http://www.viasystemsinc.com/external/univision.htm
Related Articles: