Knowledge Base

Tool/Feature Documentation

Regular Expressions in Studio 3T Reference

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

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 […]

Search In… (aka Value Search) Query & CRUD Operations

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

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 […]

Date Tags Query & CRUD Operations

Posted on: 21/04/2022 (last updated: 30/09/2024) by Dj Walker-Morgan

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 […]

Incremental Execution for Export and Migration Import/Export

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

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 […]

The Studio 3T Operations Pane Getting Started with Studio 3T

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

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 […]

Using Hackolade to configure Studio 3T SQL Migrations Working with MongoDB & SQL

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

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 […]

Studio 3T License Manager for Administrators Studio 3T Licensing

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

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 […]

The License Manager and Proxy Servers Studio 3T Licensing

Posted on: 23/07/2021 (last updated: 04/08/2021) by Kathryn Vargas

When Studio 3T starts up, or when you are changing its license settings, it needs to make contact with a service on the internet. If you’re getting an error message when logging into the Studio 3T License Manager, it could be that your environment only allows communication through a proxy server, as is typical in […]