Knowledge Base

Tool/Feature Documentation

Connection Tree: Aliases and Notes

Studio 3T 2022.7 and later supports the creation and display of aliases and notes for items in the Connection Tree. It allows items in the tree to have an alternative name (alias) and have text, such as documentation, attached to it (notes).  You can only create aliases and notes for: Databases Collections Views GridFS Buckets […]

Posted on: 21/07/2022 (last updated: 07/09/2022) • Dj Walker-Morgan • 5 minutes

Regular Expressions in Studio 3T

Regular Expressions are a powerful way of expressing string patterns for matching. Value Search uses them to allow you to home in on particular strings in the database with precision. Regular Expressions are commonly available with many languages and applications and the syntax and capabilities of them have a common core. We recommend regex101.com as […]

Posted on: 23/06/2022 (last updated: 07/07/2022) • Dj Walker-Morgan • 5 minutes

Search In… (aka Value Search)

About Search In… Search In… or Value Search is a wide-range text search on the values stored in a MongoDB collection, database, or server. By default, it scans all documents for text matches (or regular expression matches) in all field values and field names. Search In… scans embedded documents and arrays and shows you the […]

Posted on: 23/06/2022 (last updated: 04/04/2024) • Dj Walker-Morgan • 7 minutes

Date Tags

Date tags are placeholders for different date operations relative to when a query is run. Date tags make date fields easier to work with by saving you from having to perform calculations with the MongoDB Date() function. Studio 3T converts the date tags when the query is run into the appropriate MongoDB query, using greater than and […]

Posted on: 21/04/2022 (last updated: 27/02/2025) • Dj Walker-Morgan • 2 minutes

Incremental Execution for Export and Migration

Incremental execution makes MongoDB exports or migrations from MongoDB to SQL more manageable. Let’s start with the big picture: State. Incremental execution records the state of a particular field as it passes through the Export or Migration process. That field has to be both unique and sortable. As each document passes through, the state is […]

Posted on: 06/01/2022 (last updated: 16/04/2024) • Dj Walker-Morgan • 4 minutes

The Studio 3T Operations Pane

Summary: The progress of Tasks and other operations run in Studio 3T is displayed in the Operations Pane. Inside the Pane is a tree of results, where the leaves of the tree reveal further information about a task. Operations in Studio 3T come from a range of actions: Copying a collection. Running a unit in […]

Posted on: 26/08/2021 (last updated: 06/09/2021) • Dj Walker-Morgan • 4 minutes

Using Hackolade to configure Studio 3T SQL Migrations

Studio 3T has an extensive range of operations it can perform to merge data in a relational schema (and usually SQL) into a document centric schema. For some users, they wish to approach this task using modeling tools such as Hackolade which can assist with the field mappings and leave a documentable pathway and records […]

Posted on: 24/08/2021 (last updated: 09/03/2022) • Dj Walker-Morgan • 4 minutes

Studio 3T Licenses and Troubleshooting

What’s the limits of a Trial license? What’s the difference between the three editions of Studio 3T. Those questions are answered in this article.

Posted on: 02/08/2021 (last updated: 09/02/2024) • Dj Walker-Morgan • 3 minutes

Studio 3T License Manager for Administrators

If you have more than one user of Studio 3T, you will want to manage their usage of Studio 3T so that it is in line with the number and types of licenses that you have. Studio 3T’s web-based license manager makes this easy, giving you one central location for all your license work. Signing […]

Posted on: 23/07/2021 (last updated: 18/10/2021) • Dj Walker-Morgan • 4 minutes