Welcome Guest | My Membership | Login

International Spectrum
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 - Evoke is a no code/low code rapid app development platform (RADP/MADP) designed to provide for the fast development and deployment of mobile, desktop and web apps for MultiValue and SQL database platforms. Evoke allows developers to build business apps and extend enterprise applications in a fraction of the time and cost of regular methods. All regular devices are supported including the iPad, iPhone and watches; Android and Windows phones, tablets and watches plus Windows, Linux and Apple desktop.

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

D3, part of the Rocket MultiValue Application Development Platform, is the choice of more than a thousand application developers world-wide, serving top industries including manufacturing, distribution, healthcare, government, retail, and other vertical markets. Boasting both stability and security, the D3 data server engine offers superior performance, high availability, and low administrative overhead.

Ease of Use and ROI Drive Loyalty

D3 provides software developers with all the necessary tools to quickly adapt to changes and build critical business applications in a fraction of the time as compared to other databases; without compromising data integrity and with low administration costs. For creating real-world applications, D3 manages information in a way that has proven vastly superior to other database schemas.

Performance Your Application Can Harness

D3 delivers high performance via efficient file management that requires minimal system and memory resources. Based on a true 64-bit architecture, D3 applications provide high performance at both the hardware and application level. The 64-bit version of D3 provides larger addressing space per process, larger core memory and overall enhanced application performance.

Security at Multiple Levels

By enhancing security, a continuous goal at Rocket, D3 boasts modern features such as SSL support, which makes D3 application data in transit more secure.

  • At the application level, for data at rest, D3 provides both file level and field level encryption, making the data secure at any level.
  • D3 also supports IPv6, so our customers and partners apps benefit from a more secure internet protocol that runs end-to-end encryption, making man in the middle attacks significantly more difficult. Plus, IPv6 supports more secure name resolution, delivering an improved level of trust.
  • By harnessing local authentication and LDAP, weve added single sign on which not only improves user experience, but also allows users to move between systems securely without typing their credentials each time.

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

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:/​/​www.rocketsoftware.com/​products/​rocket-​d3/​rocket-​mvbase-​dbms

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

A MultiValue application platform for developing fast, flexible and secure applications

Organizations rely on Rocket UniData, a best-in-class of the MultiValue application platform, for scalable business apps that can evolve as needs change. As a stable, secure, fast data server engine with high availability and low administrative overhead, Rocket UniData is ideal for rapid development using modern tools. On-premises or in the cloud, UniData serves nearly a million users worldwide.

Performance by design

  • A unique and resilient architecture delivers performance advantages compared to traditional SQL databases
  • variable length records and tables within tables simplifies database design, eliminating the constraints of SQL normalization
  • using direct-read capabilities that result in fewer I/O operations than required by SQL, UniData is faster than many other databases
  • variable length records mean less data is transmitted within the entirety of the system which translates to:
    • more responsive mobile applications
    • more efficient replication (for disaster recovery, high availability and more)
  • Rapid development means rapid returns

    UniData includes multiple, easy-to-use programming languages (including Python) with multiple standard supplied interfaces (Node.js, .NET, Java, ODBC, JDBC, RESTful via JSON) for multi-tier solutions. Accelerate your teams productivity by selecting the best development tools based upon your staffs capabilities.

    Security is paramount

    Rocket embeds the most effective security standards for encryption technology deep within the data server, so your data is secure no matter its location, and whether in-transit or stored on disk.

    • SSL/TLS secures connections to the MultiValue server and encrypts data in transit for protection from snooping or eavesdropping. Third parties can also validate and accredit our cryptographic modules for FIPS 140-2 compliance.
    • Automatic data encryption ensures only trusted users with the encryption key can view data. Stolen data is rendered useless without the encryption key.
    • UniData also offers role-based security for users accessing the application. Required DBA maintenance to implement and maintain these capabilities is simple and efficient.

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

    About UniVerse

    Fast, flexible data management and app development for your enterprise

    Rocket UniVerse, a component of the MultiValue application platform, is a fast, flexible data server for developing enterprise apps. Its variable length, table-within-table architecture means speedy data access and low maintenance with user interfaces for Windows, Linux, and UNIX. Deployable to the cloud or on-premises, thousands of customers globally depend on UniVerse to run their businesses.

    Performance to spare

    • Extremely flexible data structures with high-performance data access, storage, and resource management capabilities
    • Industry-proven design with direct read capability means fewer I/O operations and faster access to data
    • Dynamically allocates available resource to maximize processing throughput of available resources

    UniVerse makes it easy for them to build for your success

    Powerful, easy-to-use programming languages with standard supplied interfaces (.NET, Java, ODBC, JDBC, RESTful with JSON) enable your programmers to become immediately productive in this fast environment.

    Efficiency and speed to market mean faster returns on your investment

  • Does not require a large administrative or programming staff to implement, operate, or maintain
  • Accelerates the time to value for applications, and provides exceptional short- and long-term ROI
  • Includes multiple programming languages, including Python, with multiple interfaces for your tiered architecture so you can pick and choose the best development solutions based upon your staffs capabilities
  • Secure and auditable

    • SSL/TLS secures connections to the data server, in addition to securing data in transit from snooping or eavesdropping.
    • Automatic data encryption makes it easy to adhere to the highest security standards, protecting data at rest on the disk.
      • Only trusted users with the encryption key can view data, and stolen data is rendered useless without the encryption key.
      • Access is granted at the user or group level via role-based security, reducing the time required for DBA maintenance.

    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