Getting Started : Getting Started Using OpenROAD : Create a Database Connection Profile
 
Share this page          
Create a Database Connection Profile
To use any of the tabs other than the Connect tab, you first must connect to a database through a database connection profile. Therefore, you must create at least one connection profile before you can connect to a database.
You can create connection profiles to connect to existing databases or you can create a new database for the connection. You create database connection profiles on the Workbench Connect tab.
Note:  If this is the first time you have started this version of OpenROAD, the OpenROAD Startup Assistant will prompt you to create a new database connection profile. For more information, see Start OpenROAD Workbench.
To create a database connection profile to connect to an existing database
1. In Workbench, Click File, New, Profile.
The Connection Profile Assistant opens.
Click Next.
2. Choose the Database Management System you want to use and click Next.
3. Select Existing Database and click Next.
Note:  This option is available only if OpenROAD is installed into a local Ingres DBMS installation. If OpenROAD is installed with the Ingres Net client, skip directly to Step 4.
4. Select whether the database is a local or remote connection and click Next.
A vnode is a virtual node, which provides all connection data to connect to an Ingres installation on a remote system. For more information, see the Ingres Network Management Utility (netutil) or Network Utility (ingnet) in the Ingres Connectivity Guide. You can access the latest documentation at http://docs.actian.com/.
5. Select the database and click Next.
6. Specify connection options and click Next.
For more information about connection options, see the SQL command in the Ingres Command Reference Guide.
7. Name the profile and optionally provide a description. Then click Next.
Note:  The profile name must be unique.
8. Click Finish.
The connection profile icon is created in the Connection Profiles portlet.
To create a database connection profile to create a new database
1. Click File, New, Profile.
The Connection Profile Assistant opens.
2. Choose the Database Management System you want to use and click Next.
3. Select Create Database and click Next.
4. Name the database, and specify the owner and any startup flags. Then click Next.
5. Specify connection options and click Next.
For more information about connection options, see the SQL command in the Ingres Command Reference Guide.
6. Name the profile and optionally provide a description. Then click Next.
Note:  The profile name must be unique.
7. Click Finish.
The connection profile icon is created in the Connection Profiles portlet.