We are thrilled to introduce the latest release of IBM Query Management Facility (QMF) 13.1.2, following the successful launch of QMF 13.1.1. In the previous release, we introduced native support for IBM Cloudant, enabling our users to query and manage Cloudant data with ease. Now, with the release of 13.1.2, we’ve added a major feature designed to further streamline your data management workflows: Cloudant Data Import/Export.
Recap: QMF 13.1.1 and Native Cloudant Support
In QMF 13.1.1, we took a significant leap by integrating Cloudant native support. This allowed users to directly connect to their Cloudant databases, giving them the ability to run SQL queries and generate reports on Cloudant data without needing to move it into a relational database first. Whether you were working with JSON documents or leveraging Cloudant’s flexible NoSQL structure, QMF became the tool to unlock the value of that data for analytics and decision-making. For more details on the QMF 13.1.1 release, you can refer to the official blog post here.
What’s New in IBM QMF 13.1.2?
With QMF 13.1.2, we are building on that foundation with the introduction of data import/export functionality. Here’s a closer look at the new capabilities:
1. Cloudant to Relational Database Data Import
Now, users can import Cloudant data directly into relational databases (such as Db2, Oracle, MySQL, Spark, Hive, and others). This new feature offers:
- Seamless migration of Cloudant data into traditional relational systems for deeper, structured analysis.
- Hybrid analytics: Once the Cloudant data is in a relational format, it can be combined with existing relational datasets, enabling more complex queries and reports across different data sources.
- Data consolidation: You can centralize all your NoSQL and SQL data, making it easier to apply business intelligence tools, manage data consistency, and develop a single source of truth.
2. Relational Database to Cloudant Data Export
Conversely, QMF now allows users to export relational data into Cloudant. This functionality is invaluable for:
- Building cloud-native applications: Developers can move data from relational systems into Cloudant to leverage its scalability, JSON document storage, and distributed architecture.
- NoSQL transformation: Data stored in relational databases can be moved into Cloudant to take advantage of the flexible schema and document-based structure.
- Improved agility: Organizations working on microservices, and cloud-first strategies can rapidly shift data between relational and NoSQL environments to meet application needs.
Why This Matters: Bridging NoSQL and SQL Worlds
The addition of this import/export feature addresses one of the most common challenges organizations face: managing data across disparate environments. Many businesses have a mix of traditional relational databases and modern NoSQL solutions like Cloudant. Until now, these systems often operated in silos, making it difficult to share data and create a unified analytics strategy.
With QMF 13.1.2’s import/export feature, you can now:
- Migrate data effortlessly: Whether you're moving data from a cloud-native environment like Cloudant into a structured relational system, or exporting data to the cloud for scaling applications, the process is streamlined and efficient.
- Combine structured and unstructured data: Run queries that span both relational and Cloudant datasets, enabling more comprehensive insights and powerful reporting.
- Simplify hybrid cloud architectures: QMF now enables easy data movement between on-premises relational databases and cloud-based NoSQL systems, simplifying hybrid cloud deployments.
Real-World Use Cases
Let’s look at how different teams can benefit from this release:
- Data Engineers can now migrate Cloudant data into relational systems for more advanced analytics, ensuring that business intelligence teams can access the data in the format they are familiar with.
- Developers working with cloud-native applications can easily export legacy relational data into Cloudant, where it can power agile, modern applications.
- Business Analysts can now create reports and visualizations using data from both Cloudant and relational systems, giving them a broader view of the business.
Looking Ahead
The release of IBM QMF 13.1.2 reaffirms our commitment to delivering the tools one need to efficiently manage and analyze data in an increasingly complex and hybrid data landscape. We will continue to enhance QMF to support customer needs, whether they're working with relational databases, cloud-based NoSQL solutions, or a mix of both.
To explore the powerful new features of QMF 13.1.2, we encourage you to refer to the following resources for additional information and support:
IBM documentation
IBM Program Directory
QMF Product Support page
What’s new in QMF 13.1.2
To try out these new features, upgrade now to QMF 13.1.2.
Thank you for your continued support. Happy reading!
#Db2QMF#QMF#cloudant#Db2Tools#IBMCloud