Introducing Toad®︎ Data Studio – Mastering Heterogeneous Database Management

Feature

What it Does

Why it Matters

Connectivity

Data engineers in today’s market must be able to connect to nearly any data source including top on-premises and cloud relational databases, popular NonSQL sources and more.

• Heterogeneity allows organizations to choose the most suitable database technology for their specific use cases

• Enables scalability across multiple data sources

• Increases productivity as you can now manage across a diverse environment in one tool

Data Source Explore and Search

Allows users to quickly and graphically explore the data source environment.

• Simplicity and familiarity with navigation through the tool will build confidence and bolster efficiency

• Increases visibility into the detail on particular objects and the ability to search for particular objects across numerous database sources in one single tool

SQL & DDL Generation

Quickly generate SQL for existing objects with one-click SQL generate for basic statements and easily create DLL.

• Removes the burden and manual process of writing all SQL from scratch

• Accelerates SQL generation

SQL Editor

Full feature SQL editor supports standard SQL syntax as well as data source specific dialects.

• Enables full usage and editing of the primary database language that data engineers come across daily

JSON/XML Viewer Editor

Allows users to read and edit JSON and XML fields directly within table fields or in their own separate editing window.

• Promotes interoperability between relational and NoSQL databases

• Simplifies data management tasks

• Enhances the overall user experience

Data Compare

Provides robust data comparison capabilities across different environments such as comparing SQL results from a data source tree and SQL query results windows or developing comparison templates with highly configurable options.

• Quickly and efficiently obtain a visual representation of data differences or discrepancies for more synchronization and support of version control

• Supports increased accuracy and reliability of data

• Contributes to a more efficient and collaborative development environment

Homogeneous Schema Compare

Allows users to compare schema and generate change statements to help maintain data across pipelines and compare schemas/structures across homogeneous database environments.

• Can result in a more organized and consistent database development, deployment and management process

• Helps to save time in identifying and resolving schema differences that can be time-consuming when done manually

• Minimizes risk during deployment when users can preview changes before applying them

Data Export/Data Extract and Load

Allows users to move data between systems, either ad hoc or through a recurring schedule.

• Enhances the overall efficiency and reliability of data-related processes in the development environment

Desktop Automation

Users can automate on the desktop as well as publishing automation into a server environment and published automations can be shared with other users for visibility into the automated routines.

• Automates repetitive tasks for efficiency gains

• Accelerates development cycles

• Supports collaboration and continuous integration practices

GIT Integration

Allows for best practice version control.

• Enhances version control and collaboration

• Adds a seamless experience for managing code changes