DataGate Studio Reference Manuals

Creating and Opening Database Connections

To perform most database management tasks in DataGate Explorer, you must first create a connection to the database. An open connection allows you to browse objects and their properties, view and edit data, import and export objects, create files and many other management tasks.

Note that in addition to the procedures detailed below, you can use clipboard commands to create connections based on database names.

To Create and Open a New Database Connection

  1. Select DataGate Explorer from the DataGate menu. The DataGate Explorer tool window will display.

  2. Right-click on the Database Name you'd like to connect to (if no Database Names are visible, click the arrow to the left of "Database Names" to expand the list.) A context menu will appear.
  3. Click Open Connection. If a connection has previously been set up under that database name, it will open and appear under the Connections heading in DataGate Explorer. If one has not been set up, DataGate Explorer will configure and create one.
    • If a username and password are required by the database, a prompt will appear.
    • If errors occur DataGate Exception Assistant will provide a verbose message box to assist in troubleshooting.

To Add a Connection without Opening it

  1. Select DataGate Explorer from the DataGate menu. The DataGate Explorer tool window will display.
  2. Click the Add New Connection button on the toolbar at the top of DataGate Explorer window (or alternately, right-click the Connections node and select Add New Connection on the context menu). The New Database Name dialog will be displayed.
  3. Select one of the two primary radio buttons: “Use registered Database Name” or “Enter Connection Details”. The edit controls on the form associated with your choice are enabled, and the other controls are disabled.
  4. Select the parameters for the connection, as explained here.
  5. After clicking OK, the dialog will close and a new connection node will be added to the Connections node in DataGate Explorer.

Connection Nodes

Connection nodes are shown in DataGate Explorer using a color-coded icon. A yellow icon represents a non-database name-based connection. A purple icon represents a database name-based connection.

Note that non-database name-based connections are initially displayed with an identifier that represents a concatenation of server name, database label, and user name. You may however, rename the connection node to any other unique identifier, by first selecting the node, then selecting the Rename Object command on the DataGate menu. Database name-based connection nodes use the database name identifier for the connection name, and can only be renamed by changing the database name identifier.

Section summary: