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 minutesRegular 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 minutesSearch 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 minutesDate 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 minutesIncremental 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 minutesThe 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: Operations run in the background in Studio […]
Posted on: 26/08/2021 (last updated: 29/09/2025) • Dj Walker-Morgan • 4 minutesUsing 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 minutesData Compare and Sync
Data Compare and Sync shows the differences between any two MongoDB collections side-by-side for an easier, more visual data comparison.
Posted on: 04/12/2020 (last updated: 17/10/2022) • Kathryn Vargas • 5 minutes
