A lot of times you have data in different database platforms (Oracle, Sql Server, Access, etc.) and you need to query that data. Not generally an easy task.
Using the Toad for Data Analysis Query Builder you can now complete this task simply and quickly.
Open Toad for Data Analysis and connect to a database. Go to the QUERY BUILDER tab at the top of the screen. Once you have opened the Query Builder you will see a NAVIGATION MANAGER panel on the left.
The upper portion of the Navigation Manager shows you a list of databases you can access. The lower left portion will display an OBJECT PALETTE where you will see a list of tables you have access to for your current database connection.
You can double-click, or drag-and-drop, one or more tables from you current connection into the Query Builder panel on the upper right of the screen. Once you have the table(s) you want to use from this connection simply click on the second database you wish to connect to (using the Navigation Manager panel) and double-click or drag-and-drop the table(s) you want to use from the second database into the Query Builder panel.
The background of the Query Builder panel will now change to say “Heterogeneous Query” (pretty cool, huh?).
Now you simply click the fields on the tables you want to use, create joins between the tables if you need to (this is done by simply highlighting one field and using the left mouse button, drag that field over to the other field you want to join to), and the query will be written for you (see the “Generated Query” tab).
Once you have the generated query you can click on the “Criteria” tab and add WHERE clauses, GROUPing and SORTing functions, etc., so your query is customized to your needs.
Now that you have the query the way you want it, simply click on the RUN QUERY button at the bottom of the page and your query will run.
After executing the query you can view the results by clicking on the RESULT SETS tab.
When you are happy with the results you can then save them, print them, or generate a report.