Home > Data Modeler Dialog Boxes > Database Connection Editor
This dialog box is displayed if you add or edit a database connection while using the Data Dictionary Import (Metadata Extraction) wizard. The specific fields depend on the connection type that you select; this topic describes the fields for an Oracle connection.
Type: Type of database to which to connect: Oracle, Microsoft SQL Server 2000 or 2005, IDB DB2 or UDB, or JDBC ODBC Bridge.
For a third-party database connection, you must have specified the appropriate driver in Third Party JDBC Drivers under General Options (see Data Modeler).
Name: A descriptive name or alias for the connection. Example: HR_Local
Host: Host system for the Oracle database. Example: localhost
Port: Listener port. Example: 1521
SID: Database name. Example: orcl
Username: Name of the database user for the connection. This user must have sufficient privileges to perform the tasks that you want perform while connected to the database.
Password: Password associated with the specified database user.