Welcome Guest | My Membership | Login

More MultiValue Database and Products Articles...

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

BlueFinity’s mv.SSIS allows MultiValue users to extract data from any major MultiValue database into MS SQL Server using Microsoft's SQL Server Integration Services product.

Conference Schedule

Florida 2018 - April 23rd-26th
More Info

 

 

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/​site/​mvnet.html

About mv.SSIS

MultiValue / SQL Server integration and data warehouse developments.

For more information, visit http:/​/​www.bluefinity.com/​site/​mvssis.html

About D3

Rocket D3 Database Management System is a powerful multidimensional database management systems that are the choice of thousands of application developers worldwide.

Powerful development environment designed for today's business critical transactional and analytical database applications, providing:

  • Scalability
  • Flexibility
  • Seamless interoperability
  • Connectivity
  • Low system management cost

For more information, visit http:/​/​www3.rocketsoftware.com/​rocketd3/​database/​index.jsp

About jBASE

What is jBASE?

jBASE is a database and a set of programs and libraries that allows normal MultiValue (MV) applications to become native Windows, Unix or Linux programs. All of the traditional MV features are supported, including BASIC, Proc, Paragraph, Query and Dictionaries (Pick and Prime style).

What are the benefits of jBASE?

Because existing MV apps are converted to native executables and shared objects, they run fast and take advantage of the latest compiler optimizations available for Windows, Unix and Linux platforms.

Flexible licensing models support cost-effective application deployment for traditional character-based applications and include models suited for efficient deployment of web and graphical-based applications.

A key differentiator is that jBASE architecture tends to make sense to technical hires who may not have prior MV experience. jBASE organizes itself much like other mainstream applications, with full support for pathing and threading. Because it is native, business objects created in jBASE, even those based on legacy code, can be wrapped with other languages. jBASE is a platform that respects the investments made in custom-built legacy apps while allowing non-MV programmers to build next-generation applications using the latest design tools and methods.

jBASE also has one of the lowest support and maintenance costs among enterprise-level MV databases.

Who actually controls jBASE?

In 2015, Zumasys purchased the jBASE intellectual property and development from Temenos, as well as jBASE sales and support from MPower1. Zumasys now controls and markets jBASE internationally with full time developers located in England and North America. jBASE interested us not just because of its worldwide install-base of loyal customers but also because it is a technology that will utilize the Zumasys Cloud to help those customers move to a SaaS business model. We can serve up MV applications running on a multi-tenanted database architecture with unrivaled price and performance and include unique features such as browser-based access.

What does the future hold for jBASE?

Being a native architecture, the future for jBASE is bright. Advancements in technology outside of jBASE tend to benefit jBASE simply because it has a native architecture. This leaves our engineers with time to focus on internal feature and functions and leave other work such as performance tuning and connectivity to vendors of operating systems.

Developers can continue to develop using traditional MV languages and data or choose to develop in new languages. They can choose whether data should be stored in traditional high-performance MV files or in virtually any other database, such as SQL Server, Oracle, DB2 or modern object data stores and noSQL databases.

For more information, visit http:/​/​www.jbase.com/​

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

Rocket mvBase Database Management System is a powerful multidimensional database management systems that are the choice of thousands of application developers worldwide.

High-performance, multidimensional database engine with MuliValued fields, unlimited items sizes and maximum flexibility for data organization.

For more information, visit http:/​/​www3.rocketsoftware.com/​rocketd3/​database/​mvb.jsp

About OpenQM

Effective 1/1/15 Zumasys is the Worldwide Distributor for OpenQM. Users with licenses issued prior to 1/1/15 should visit the Ladybridge website.

OpenQM is a high-performance, self-tuning database with an extremely efficient footprint. At less than half the price of comparable databases, OpenQM comes bundled with AccuTerm and provides incredible value for MultiValue resellers and end users alike. Auto-sizing of database files, object oriented programming, class and exception handling, simplified web development and more can be yours with a move to OpenQM.

Why OpenQM

OpenQM has long sought to revolutionize the MultiValue industry, taking MultiValue to new heights of performance and expectation. OpenQM support and maintenance is now available for the first time directly from Zumasys, one of the largest development and engineering teams in the MultiValue market. With technical support engineers located across the United States and England, you'll always be able to reach someone who knows the importance of keeping your MultiValue application up and running.

Their software developers, technical support engineers, infrastructure experts, and cloud engineers will work with you to support, protect, and modernize your OpenQM database-whether on site or in the cloud. Their cloud platform is optimized for MultiValue database applications using industry-leading technologies from VMware, NetApp, and Cisco, and housed in the world's most secure data center, The SuperNAP, managed by expert engineers who understand your business. They take care of everything including backups, system administration, and monitoring so you can focus resources on your core business while maintaining complete control of your data and applications.

OpenQM In The Cloud

The Zumasys cloud platform has been optimized with Flash memory at multiple tiers to address the disk I/O requirements of OpenQM and other MultiValue databases. If you're interested in leveraging the efficiency, security, and performance of MultiValue in the cloud, Zumasys can help.

Since 2006, Zumasys has provided enterprise-class cloud hosting for Oracle, SQL and Pick MultiValue applications. They have the depth and experience to keep your systems running. Visit www.zumasys.com/cloud for more information on their architecture, monitoring and customer references.

OpenQM At A Glance

OpenQM began in 1993 as an embedded database from Ladybridge Systems. It was released in its own right in mid-2001 on Windows systems and extended to Linux in 2003 and FreeBSD in 2004. In 2015, OpenQM announced a partnership with Zumasys to provide worldwide distribution, to create a comprehensive telephone support/maintenance program and to multi-tenant OpenQM on the Zumasys Cloud. This allows customers to quickly provision OpenQM servers in the cloud and benefit from a convenient, affordable monthly fee for the database, operating system and underlying infrastructure.

Zumasys helps companies of every size transition their infrastructure and applications to the cloud. With Zumasys cloud services, customers can easily access the latest software and hardware technologies over the Web, allowing them to focus on growing their core business instead of managing their IT infrastructures. Zumasys delivers personalized service, integrated disaster recovery and the confidence companies need to outsource the hosting of all their databases including SQL, Oracle and Pick MultiValue systems.

For OpenQM inquiries please visit: http://www.openqm-zumasys.com/ Users with licenses issued before 1/1/15 please visit: www.ladybridge.com

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.nps-​reality.com

About UniData

Power and Performance without the Maintenance.

Deliver Even Better Availability, Interoperability and Security for Your Data.

UniData is an extended relational data server ideal for embedding in a variety of industry-focused solutions. Its extended relational model, with NoSQL access to data, is perfect for rapid cost-effective applications serving the needs of businesses from SMB to the enterprise where outstanding performance, reliability, scalability and manageability are needed.

Product Highlights:

  • Delivers low TCO and exceptional scalability to meet the challenges of on demand business in the SMB and large enterprise markets
  • Provides intuitive design and high-performance queries using an extended relational data model
  • Supports security and robustness via encryption, authentication and high availability features
  • Features native high-performance interfaces for .NET, Java and more
  • Includes U2 Dynamic Objects for easier exchange of data with web services

Emerging Technologies:

  • Data Type Enforcement provides an optional check on data written to a file in order to assure only valid data is stored.
  • Replication with External Database Access (EDA) can be used to replicate your data to a SQL database on the same server.
  • U2 MetaData Manager (U2 MDM), a user-friendly tool, quickly and easily builds and maintains mappingsfor your SQL tools accessing UniData.

For more information, visit http:/​/​www.rocketsoftware.com/​products/​rocket-​unidata

About UniVerse

Fast and Flexiblefor the Enterprise.

Modern data. Managed.

UniVerse is an extended relational data server optimized for embedding in vertical applications. UniVerse offers a nested relational (MultiValue) data model , with NoSQL access to data, means intuitive data modeling and fewer resulting tables.

Product Highlights:

  • Delivers high performance to business solutions through super-efficient database structures
  • Speeds your time to market while providing a lower total cost of ownership
  • Advanced management with audit logging and account-based licensing
  • Protects your data and provides around-the-clock availability to your enterprise application
  • Integrates easily with third party software and external data sources

Emerging Technology:

U2 MetaData Manager (U2MDM), a user-friendly tool, quickly and easily builds and maintains mappings for your SQL tools accessing UniVerse.

For more information, visit http:/​/​www.rocketsoftware.com/​products/​rocket-​universe

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.edp.co.uk/​solutions/​univision.htm

Related Articles:


Return to top