What's new in QMF 13.1.1

The QMF family brings you more business intelligence functionality and value in QMF 13.1.1, while providing improvements on traditional features and functions.

QMF for Workstation

Workstation configuration rollout simplification

The configuration rollout of QMF for Workstation that is related to Repository Connections and the JDBC library has been simplified. Administrators can push the configuration updates to multiple workstations at a time by clubbing them into a Message Group. All Workstations that are connected to the QMF Server receive a notification for the new configuration. Administrators can monitor the new configuration rollout on the QMF Server UI by using the Message Groups view.

IBM Cloudant native support

QMF now supports the Cloudant database. You can perform all the CRUD operations on Cloudant documents and Cloudant indexes. You can query Cloudant data by creating Cloudant queries with indexes and use Cloudant data sources in combination with other SQL based data sources.

Apache Spark data source integration

QMF now supports the Spark data source. The current JDBC interface for Spark only supports running queries and fetching results. All the QMF objects are supported with Spark.

Support for Cloud data sources

QMF now also supports Snowflake along with Amazon Athena and Amazon RedShift. All QMF objects are supported by these data sources. Repository storage creation for these data sources is not supported.

Support for Apache Avro and Apache Parquet file formats file formats

QMF now supports importing and exporting data in the Avro and Parquet file formats. These file formats provide substantial performance improvement while importing and exporting data as compared to the traditional file formats, such as CSV.

User productivity enhancements

QMF for Workstation can be installed on the Windows 11 operating system.
QMF for Workstation can be installed on the Linux 8 operating system.
QMF for Workstation is supported with the Java 11 runtime environment.
Error messages for QMF procedures are enhanced with line numbers and the error cause for better troubleshooting.
A new view called JS Procedure log view is added to improve the error reporting of JavaScript procedures.
You can now see the application name of the current client when you run a query on the Db2 database. To see the application name, specify the application name in the clientprogramName field on the JDBC Advanced Properties dialog box.
The global variables of QMF for TSO and CICS® that begin with DSQ are now better handled in QMF for Workstation.

QMF for WebSphere