What's New in Studio 3T 2021.6 | Integrating Hackolade, code folding, and more

2021.6.1 update: We have fixed an issue that sometimes returns exceptions when connecting to Replica Set or DNS Seedlist connections.

Support for Read Preference Tag Sets, integrating Hackolade, code folding for JSON documents, and much more in the latest release of Studio 3T.

Headline Features

Connection Manager | Now supporting MongoDB Read Preference Tag Sets

When working with replica sets, it may be important to configure your Read Preferences to specify geographic locations, retain stale data for analytics, or maintain a fallback server. Sometimes, the default options aren’t specific enough, and it’s necessary to use Read Preference Tags. We’ve added compatibility in our Connection Manager to do that.

When editing a connection, choose an option from the Read Preference dropdown and the Read Preference pane will appear, allowing you to configure your Tags accordingly.

Read more about Read Preference Tag Sets in Studio 3T.

Export Wizard | Support for placeholders in target file and folder names

Making backups and sifting through old files can be a pain. We’ve made it easier. Now, you can dynamically add date and time properties to your exported files. Use it in conjunction with automated tasks in Task Manager to power up your workflow and organization.

Learn more in our Export Wizard documentation.

JSON Editor and Viewers | Collapse and expand sections

You asked, we listened. When working with documents which contain multiple nested fields or with potentially thousands of lines of data, it’s necessary to limit your view to just the important parts. To that end, we’ve made it possible to collapse and expand sections in both the JSON Editor and JSON Viewer.

Read more about the JSON Editor and Viewer in our d ocumentation.

SQL Migrations | Hackolade and Studio 3T

We’ve added an integration with the polyglot data-modeling tool Hackolade to make migrations from legacy SQL systems to MongoDB even more appealing. Now your migration schema can be mapped out visually using Hackolade’s denormalization feature, before importing the Hackolade file into Studio 3T and running the migration.

For full documentation on how to use this new feature, visit our Knowledge Base. You can also learn how to import a SQL Database to MongoDB in 5 steps with Studio 3T.

Fixes and Improvements

User Shoutouts

We’d like to thank the many users of Studio 3T for reaching out for their own needs: Abdelrahman Hafez for reporting an issue when navigating a nested result tree with the left and right arrow keys; Marc Donis for requesting the code folding feature; Faizal Martinus for requesting the upgrade to the 4.3 version of the mongodb driver; William Luo and Erik Martin for suggesting support for read preference tag sets; and to everyone else who made this release possible.

App-wide

Added option to “Open recent” script in IntelliShell, SQL Query tab, Aggregation Editor, and Map-Reduce tab
Added support for the UUID function without arguments in all JSON documents
Upgraded to the latest MongoDB Java driver of version 4.3, compatible with MongoDB 5.0
Fixed issue with blurry data type icons, e.g. as shown in Table and Tree Views
Fixed issue when navigating a nested result tree with the left and right arrow keys
Fixed issue where the JSON formatter compressed queries erroneously

Aggregation Editor

Support $out stages that write to Data Lake with Amazon S3
Added $search operator to aggregation pipeline, and other aggregation improvements released with MongoDB 4.4

Connection Manager

Added support for connecting to a serverless Atlas instance
Added option to set initial page size on a per-connection basis
Added support for customizing Read Preference Tag Sets
Fixed issue of replica set members not shown in the Connection Tree

Data Masking

Fixed crash occurring when editing a Data Masking task and the source connection is deleted

IntelliShell

Optimized IntelliShell startup time and improved startup UI
Added support for using index specification documents when creating an aggregation hint
Fixed issue where saving an IntelliShell script would not update its respective tab title
Fixed issue with code formatting that could break shell helper commands that contain names with special characters
Added support for more find query cursor methods in Query Assist

Export and Import Wizard

Fixed an issue where exports with mongodump and imports with mongorestore would report an unclear status after execution, resulting in a success icon with an error icon overlay

MacOS Big Sur

Fixed issue with JSON editor not displaying first lines of content
Fixed issue with last row of Table/Tree view not displaying
Corrected the width of the Connection Manager window on macOS BigSur

SQL Query

Fixed pop-up menu appearing in the SQL tab, even when there is no document present

SQL to MongoDB Migration

Drastically improved speed of SQL operations with Oracle SQL. Migrations are up to 44 times faster and in testing, one migration of two million records was reduced from over four hours to just six minutes.