We’ve done a lot in Toad for Data Analysis to make it user friendly and intuitive. Naturally, what’s user friendly to one person may be a bit confusing to someone else. This article will show you how Toad for Data Analysis can be changed to something more comfortable or familiar.
For those of you familiar with tools like Toad for Oracle or Microsoft’s©Query Analyzer or SQL Navigator© there’s a quick and easy way to change the look and feel – even the keyboard shortcuts! – of Toad©for Data Analysis. All you need to do is navigate to Tools > Configuration Wizard and select the product you’re familiar with:
If the product you’re familiar with is not listed then you can choose “Custom” and start making changes.
Document Groups and Document Hiding
One of the option pages in the Configuration Wizard allows you to make changes to the way Toad© for Data Analysis manages documents (i.e. – the tabs for SQL Scripts, Query Builder files, the Database Browser, etc). By default, these documents are grouped into the 1 – 4 categories at the top of the window: 1. Understand, 2. Query, 3. Report, and 4. Automate. This helps to keep the UI clean and uncluttered, but if you’re not used to working with these groups, it may be confusing at first.
Another type of grouping that’s done by default is at the connection level. If you have two connections open in Toad© for Data Analysis you’ll only be able to see the documents owned by that connection when that connection is the active one. The only exception here is the Query Builder. This document type supports cross-platform queries, so naturally you will want to see that document in each of the active connections.
Changing the options here allow you to change this default behavior.
If you’re a brave soul - not easily intimidated by many, many documents - just uncheck each of these boxes to see all of the documents… all of the time. To some it’s clutter, to others it’s simpler. Your choice.
--Daniel