Connecting to Database Sources and Targets
Go Up to Using ER Studio DA
In ER Studio Data Architect, you can use the Reverse Engineer Wizard to connect to a database and then create a new data model based on an existing database. You can also connect to a database using the DDL Generation Wizard and automatically generate the SQL source code to build the database. In ER Studio Data Architect you also connect to databases using the Model Compare and Merge facility.
ER Studio Data Architect recognizes the following database connectivity methods:
- Open Database Connectivity (ODBC), using ODBC drivers. (See Configuring ODBC Data Source and Target Connections.)
- Native connectivity, using database client software. (See Using Native or Direct Database Connections.)
- For a list of supported databases, see the Installation Guide or choose Tools > Datatype Mapping Editor to view the default datatype mapping for each supported database.