Limitless Connectivity - Connect to nearly any data source, from traditional relational sources (including Oracle, SQL Server, Sybase, DB2, Teradata, Access, and any ODBC-compliant platform) to non-database sources (including Excel and SharePoint) to non-SQL systems (including Salesforce.com, Business Objects, and Oracle Business Intelligence platforms). Run SQL queries against any of these sources. Data Integration - Simplify data integration through cross-platform SQL queries. Automation Engine - Automate and schedule routine tasks to increase your productivity; develop sophisticated workflows to support advanced projects. Local Data Store - Capitalize on the embedded database to become more flexible and agile with your data sets. SQL IDE - Write SQL statements in a robust, customizable editor that provides SQL Complete, automatic formatting, instant SQL recall, as well as a variety of other features that make writing SQL easy. Visual Query Builder - Develop advanced single-platform and cross-platform SQL queries through an easy-to-use drag and drop interface. Advanced Analytics Library - Access advanced mathematical and statistical functions through SQL. Data Visualization - Navigate interactive data visualizations to better understand your result sets. Compare and Sync - Compare and synchronize data between different data sources to ensure consistency and validity. Data Cleansing Area - Transform and cleanse your result sets (add calculations, columns, and groupings, find duplicates, and more) with a straightforward interface. ER Diagrammer and Data Browsers - Visualize and annotate table relationships to create your own relationship templates; view master-detail relationships; browse database tables and objects. Charts and Reports - Design professional charts and graphs to share your data results. Import/Export Utility Wizard - Load and unload data efficiently. Easily export and publish data to Excel, .CSV, .TXT, HTML, PDF
What's new in this version:
Version 3.0: Data Compare and a Grouping activity added.