Connecting to Database Sources and Targets
Go Up to Using ER/Studio Data Architect
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.
Note: Please remember that that ER/Studio Data Architect 32-bit requires 32-bit native client or ODBC drivers and ER/Studio Data Architect requires 64-bit native client or ODBC drivers.