Access Data Sources — Connect natively to over 40 relational and NoSQL DBMS platforms (Oracle, SQL Server, Db2, Sybase, Hive, MongoDB, MySQL, Snowflake, and many more) from one easy-to-use IDE interface. Access your diverse data sources whether they are hosted on premises or in the cloud (including Amazon, Azure, and Google).
Manage Database Objects — Browse database objects (including tables, indexes, triggers, users and roles, and stored procedures) and visually edit them with a few simple clicks. Create, alter and delete without having to write a single line of code.
Administer Databases — Manage core aspects of your servers. Manage instances, storage, security, and sessions. For Oracle, manage rollbacks, logs, and system global area (SGA). For SQL Server, manage agents. For Amazon Redshift, Netezza and Vertica, view query history.
Compare — Compare the data definition language (DDL) of schema objects from different database platforms in an easy to navigate graphical interface. See database and object level differences. Also compare query results and folders and files on local machines.
Synchronize — Synchronize the data definition language (DDL) of schema objects from same database platforms in an easy to navigate graphical interface. Synchronize source to target schema.
Model Entity Relationship Diagrams — Create and manage entity relationship (ER) diagrams. Reverse engineering existing databases, and design detailed physical ER diagrams involving thousands of entities. Annotate, forward engineer, compare ,convert, and generate reports.