Add a SQL connection profile

Demo

Note: The OpenEdge Release 10.2B demos have not been updated for OpenEdge Release 11.0. Since 10.2B, OpenEdge Architect has been renamed as Progress Developer Studio for OpenEdge. In addition, OpenEdge Release 11.0 includes some feature enhancements and other changes. Despite the differences between 10.2B and 11.0, the demos are still a useful introduction to Progress Developer Studio for OpenEdge.

When you create a new database connection using the connection profile wizard, you are prompted to create a new SQL connection, or assign an existing connection to the database. The Add SQL connection profile page allows you to define a new SQL connection. This page appears when you select the Define SQL Connection checkbox and the corresponding Add new SQL connection radio button, then click Next.

Note: By default, the Define SQL Connection checkbox and the corresponding Add new SQL connection radio button are enabled.

The following options are available on the Add SQL connection profile page:

Connection name	This is a unique name that describes the connection. This field is automatically populated if you defined the connection name in the first page of the database connection wizard.
Driver	Specifies the JDBC driver for the connection profile. Select the driver that is appropriate for the database from the drop-down menu. For more information, see Configuring a JDBC driver.
User ID	Specifies the User ID for the SQL connection profile. This field is automatically populated if you defined the user ID in the first page of the database connection wizard. You can omit both the user ID and the optional password from the connection profile if the auto-login checkbox is not selected. However, you will be prompted for the user ID and password every time you make a connection.
Password	Specifies the password to access the database.
Open on Eclipse startup	Opens the database connection when Progress Developer Studio for OpenEdge starts. Note: If you enable this option, you still must enter a valid user ID and an optional password. This option slows the startup of Eclipse. If you select the Auto-start a database server on the next page of database connection wizard, you can not use this option; the system will attempt to connect before the database automatically starts.
Auto-Login on connect	Automatically logs into the database when OpenEdge Architect starts. The system attempts to log in using the provided user ID and password.
URL details	Allows you to edit URL information for your system. Selecting this checkbox enables all URL fields.
Host name	The host name must be localhost when you are using the OpenEdge Personal RDBMS database (which is the default RDBMS packaged with Progress Developer Studio for OpenEdge). You cannot connect to an OpenEdge Personal RDBMS database that is running remotely. This value defaults to the host name entered on the first page.If you are connecting to an OpenEdge Workgroup or OpenEdge Enterprise RDBMS, you can specify the host name of the system where the database server process is running. If the database is running on the local system, you can use localhost in place of the host name.
Service/port	Identifies the service or the port number to use on the host machine when connecting to a broker process. Note: If you are connecting to an OpenEdge database, you can find appropriate values by checking the configuration settings for the database in Progress Explorer.
Database name	Represents the name of the database. Note: If you are connecting to an OpenEdge database, check for the correct name in the Databases folder in Progress Explorer.
SQL parameters	Displays any additional SQL parameters delimited by a semi-colon in the format key1=value; key2=value.

See OpenEdge Data Management: SQL Development and OpenEdge Data Management: SQL Reference manuals for more information on SQL connections. You can find OpenEdge manuals in the Product Documentation section of the Progress Software Developer's Network Web site.