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, and a variety of other file formats.
Data profiling – Visually profile and sample database tables and data sets for patterns, unique values, duplicates, missing information, min./max. values and more.