Features and Benefits

Toad® for Data Analysis gives business and IT professionals the power to:

• Access data directly from any database with one tool
• Join data across all platforms
• Streamline data collection
• Efficiently create custom reports
• Collaborate with team members
• Export data into a variety of programs, including Microsoft Excel
• Automate and schedule tasks

The robust features of Toad for Data Analysis will enable you to:

• Connect to any database, including Oracle, SQL Server, DB2, Sybase, Excel and Access. Refer to Release Information for more details.
• Create SQL statements that join data across multiple database platforms
• Make data loading and unloading easy and efficient with the Import/Export Utility Wizard
• View a graphical representation of tables and views using the ER Diagram tool
• Quickly create SQL statements, add tables, automate join definitions, and more using Query Builder
• Easily view, navigate and edit SQL statements using SQL Editor
• Compare and synchronize data to ensure validity
• Quickly export data to Microsoft Excel, .CSV, .TXT. HTML and XML
• Automate and schedule tasks and report distribution