Connect to a wide range of data sources, including SQL based and NoSQL databases, ODBC, Business Intelligence sources, and Microsoft Excel or Access. Use a single tool for basic querying and reporting needs and get consistent results.
Create Database Diagrams as templates for queries to build reports, and for understanding database relationships between tables.
Create a query without writing or editing SQL statements. Even for those familiar with SQL, the GUI (graphical user interface) makes it easier to create relationships and visualize the query.
Connect to many different types of data sources, including relational databases, business intelligence sources, NoSQL databases, and files.
Locate objects using Object Search, Database Explorer, or using a filter in Object Explorer.
Design professional charts and graphs to share data results.
Use the Cross-Connection Query Builder or the Cross-Connection Editor to create a query that combines data from multiple, dissimilar databases.
The editor combines a powerful SQL and procedure editor into a single interface. Customize options and shortcuts to make the editor look and behave according to your preferences.
The Result Sets tab displays a data grid for executed SQL statements and scripts that return data.
Export to your favorite tools. Access key data quickly, including built-in report and pivot functionality, for in-place analysis and single-click export to an Excel instance.
Use One Click Export to quickly export data to an Excel, csv, txt, pdf, or html report. Exported data can include a linked query in the file, which creates a “live” Excel report that refreshes dynamically.
Save time on database tasks by easily scripting database activities and scheduling them using the Windows scheduler.
Great design starts with people
Learn more about our human-centered design process, sign up to participate in our research studies, and get early looks at products-in-progress.