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.
Studio 3T Read Preference Tag Sets
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.
Studio 3T Filename Placeholders
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.
Studio 3T Code Folding
Read more about the JSON Editor and Viewer in our documentation.
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.
Studio 3T and Hackolade
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.
Visual Query Builder
- Fixed crash when changing field type to Reference
View the full list on our change log.
Download Studio 3T
Auto-update in the app, or start your free 30-day trial today:
Try Studio 3T 2021.6
