Toad Data Modeler Valuable Features

JamesBlack - PeerSpot reviewer
Owner at JRB Software

I’m very happy with the product. It's an excellent product. Auto-complete is the best feature of the solution.

View full review »
it_user275235 - PeerSpot reviewer
Data Warehousing and Business Intelligence Lead at Bank of America

To begin with, it’s got a simple to use yet robust GUI. It’s so easy to connect to any database, and it can connect to heterogeneous DB’s including flat-files.

Querying could not be any easier (Query Builder), as well as learning an optimistic way of writing a query that is generated after selection from simple drag and drop. The wide variety of selections it offers, from data analysis, entity relationships, highlighting reserved words to help understand the query easily, drop-down to pick tables, column names, and explaining the plan for performance tuning the Query and many more are also valuable.

View full review »
RW
Process Data Engineer (Subsurface and Wells) at Shell

SQLBuilder really helps to play with the data and develop SQL queries to extract data from huge databases as per the requirement.

View full review »
Buyer's Guide
Database Development and Management
April 2024
Find out what your peers are saying about Quest Software, IDERA, Oracle and others in Database Development and Management. Updated: April 2024.
768,578 professionals have used our research since 2012.
KQ
Senior engineer at Unit

I found all features valuable and necessary in Toad Data Modeler, particularly how good the solution is for modeling, database schema generation, and database re-engineering.

I also found Toad Data Modeler straightforward to use.

View full review »
Javid Ur Rahaman - PeerSpot reviewer
VP, Infrastructure,Data Management Services & AI Evangelist at a tech company with 51-200 employees

Its compatibility with Windows 10/11 is the most valuable feature for me. This is because all new laptops and news users will be upgrading Windows to 10, and compatibility and stability are mandatory to use the product.

View full review »
it_user499689 - PeerSpot reviewer
Data Warehouse Developer at a comms service provider with 1,001-5,000 employees

This is our main SQL tool; everything is there and makes it efficient and easy to perform the needed tasks on the database. I have it open every day.

View full review »
KD
Senior Software Developer at a logistics company with 1,001-5,000 employees

This product is fast to learn and a user-friendly tool. It's most valuable to me because of its great shortcuts. It really helps on development time. You can even define some quick assist codes and prefixes. Also, you can use this tool for comparing files, debugging, FTP file transfer, etc.

View full review »
it_user751089 - PeerSpot reviewer
Sales Engineer at BAKOTECH LLC

The most valuable features are the database architecture, the good functionality, and the user interface.

View full review »
it_user277041 - PeerSpot reviewer
Director of Information Technology at a healthcare company with 501-1,000 employees
  • Report/Query automation
  • Cross database queries
  • Ability to query multiple data sets
View full review »
it_user277944 - PeerSpot reviewer
System Engineer at a consultancy with 1,001-5,000 employees

It was immensely helpful in collecting SQL database data, especially as I am not a database admin/engineer. Also, the GUI interface has good ease of use for pulling queries and creating links between tables to pull specific server information in a timely manner for someone who may not have database experience.

View full review »
it_user151125 - PeerSpot reviewer
Architect at a tech services company with 51-200 employees
  1. Horizontal layout for each connected database connection
  2. Easy way to generate statements for select,insert and update
  3. Easily identify the locks on the table and processes running on the database and their source information
  4. It is easy to Explain plan
  5. It is easy to optimize the query using optimizer
  6. Table import and export are easy
  7. Formatting of sql also makes it easy to read
View full review »
it_user273741 - PeerSpot reviewer
DBA Team Lead DB2 at a tech services company with 1,001-5,000 employees

Mostly the database administration feature.

View full review »
it_user323601 - PeerSpot reviewer
Sr Program Manager/Data Architect at a tech services company with 51-200 employees
  • Data comparison
  • Imports from various sources
View full review »
it_user273135 - PeerSpot reviewer
Business Systems Project Leader at a marketing services firm with 51-200 employees

I find the script/text editing feature most valuable, as well as the ability to run scripts of any size against databases.

View full review »
it_user273738 - PeerSpot reviewer
Summer Engineering Intern at a healthcare company with 501-1,000 employees
  • Ability to save my custom queries and Macros
  • Faster connectivity to databases than a SQL developer
View full review »
it_user738687 - PeerSpot reviewer
Developer at a tech vendor with 51-200 employees

Running queries, because that's kinda important.

View full review »
Buyer's Guide
Database Development and Management
April 2024
Find out what your peers are saying about Quest Software, IDERA, Oracle and others in Database Development and Management. Updated: April 2024.
768,578 professionals have used our research since 2012.