Toad Data Modeler Reviews

I am able to develop the back-end database functionality and look up schema information when we are having design meetings. It really is the software that we are developing/maintaining that is the improvement for the business.

Better documentation would be a benefit.

I’ve used Toad for most of the last seven years, but that really doesn’t make me an expert by any means.

No issues encountered.

Generally no, although I have had a couple minor issues with large scripts and memory errors.

No issues encountered.

I haven't had to use it.

I haven't had to use it.

No previous solution was used.

The only hassle was the EUA process.

In-house, via an EUA request, and we used a software center to install.

I don't know the financials, but I wouldn’t be able to do my job (build applications/databases) without it.

It works well for Oracle design and development.

Our primary use case of this solution is for support.

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

Many users don't know how to add licensing to Toad, or where it is shown, so they could make that easier. 

The software is very stable.

I'm not a database administrator, so I'm not sure about this aspect of the solution. I understand that Toad can take on about 600 licenses.

The initial setup of the solution is complex. Deployment involves an EXE file and you choose your operating system and click-through, so that part of the user installation is easy. It takes a few hours.

I don't work with Toad, I support Toad because I work in a distributor company. I deal mostly with the on-premises version of the solution.

I would recommend Toad but I think it would be a better solution if it had one platform or if it was an all-in-one tool.

I would rate this solution nine out of ten. I'd rate it higher, but right now, for example, if I want to work with the database I must load Toad for Oracle or Toad for MySQL, etc. But if I want to work with the Toad Modeler, I don't want another Toad installation. If there was a one-stop solution, it would be a ten.

• Report/Query automation
• Cross database queries
• Ability to query multiple data sets

• It's moved us away from MS Access.
• Automated report processing

We sometimes have issues with multiple nested queries. They take a long time to run, and it would be nice to have them run faster.

I've used it for seven years.

It was a bit tedious to set up the computers that run the software. We needed to download Oracle thin client, and set up computer variables. It took a while to do so.

No issues encountered.

No issues encountered.

It's very good.

From Good to very good, depending on who you get to help you.

MS Access. We switched because we were accessing an Oracle DB in the cloud with lots of data. Access needed to download the data in order to process queries which ended up either taking forever or not working at all. Toad allowed us to run the query on the cloud DB and, return data from the query. Made things much faster.

It was a bit tedious to set up the computers that run the software. We needed to download Oracle thin client and set up computer variables. Took a while to do so.

We did it in-house.

Each license costs a bit of money, and you need to purchase maintenance for each license in order to get updates and use tech support.

• MS Access
• Crystal Reports

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.

It allowed us a better look at the big picture of the state of our server environment.

I've not used a product that I could compare it with.

I used it for a month.

The program did not crash or have other intermittent problems or issues. It worked as expected.

The program worked flawlessly whether pulling information for 10 or 1000 servers.

I didn't need to contact them.

I didn't need to contact them.

This is the only solution I've used.

Corporate standard installation process was as expected and went smoothly. It was a standard windows client installation, which connected without issues to our asset management database on the mainframe.

We did an in-house standard corporate windows client application installation.

I was not involved in the purchase agreement, from a personal point of view, a good working tool is well worth it if priced competitively.

I did not. My role was as an end user, not of evaluation.

See if the program features meet your task, do so with competitive pricing and their history of quality customer / technical service provided.

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

1. Toad crashes sometimes and it will lose all the saved database information
2. We cannot the execute SQL, offline easily (If you are creating a MV and if you shut down your laptop it won't create it)

Mostly the database administration feature.

Database slowness was an issue, but Toad helps us to find the ADDM, AWR and stats-pack reports very quickly. It's a cool product enriched with a lot of excellent features.

I've been using it for 10 years.

I've never had any issues.

Sometimes, Toad crashes without a clue as to why, and it needs an immediate restart.

No issues encountered.

8/10.

8/10.

We started with Toad, and stayed with it.

It was very simple.

It's very straightforward.

100%.

It's a must-buy, and both pricing and licensing is well in the range of every organization.

Among others, we looked at SQLDeveloper and FogLight.

You should implement this product.

• Data comparison
• Imports from various sources

Reverse engineering the physical schema is complex and can be made easier. Schema diagrams which depict relationship is clumsy when the schema is complex. Presenting the complex schema in Toad with clear relationship between tables, etc.

I've used it for over six years.

Just some minor niggling issues.

No issues encountered.

No issues encountered.

9/10

9/10

I've used Toad from the beginning.

It wasn't complex.

We did it in-house.

We should be able to do it within two to three months.

It depends on your requirements and number of users.

No other options were evaluated.

Look for comparatively ETL tools available in market and you pick the one which suits your needs.

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

It saves time by allowing automated, as opposed to manual, data entry into databases.

I have used the product for about three years in total, at two different employers.

The issues I had in installation were due to database access restrictions.

It was straightforward from the software side.

I had the software implemented through in-house teams.

It is a very good option for creating and editing SQL scripts, especially large ones that I have run in support of government billing applications.