Developer Tool Guide > Connections > Connection Management
  

Connection Management

Create and manage connections in the Preferences dialog box or the Connection Explorer view.

Creating a Connection

Create a connection to access a Hadoop cluster, database, enterprise application, file system, nonrelational database, NoSQL database, social media application, or web service. Create the connection before you import physical data objects, preview data, profile data, or run mappings.
    1. Click Window > Preferences.
    2. Select the type of connection that you want to create:
    3. Expand the domain in the Available Connections list.
    4. Select a connection type in the Available Connections list, and click Add.
    The New <Connection Type> Connection dialog box appears.
    5. Enter the following information:
    Property
    Description
    Name
    Name of the connection. The name is not case sensitive and must be unique within the domain. It cannot exceed 128 characters, contain spaces, or contain the following special characters:
    ~ ` ! $ % ^ & * ( ) - + = { [ } ] | \ : ; " ' < , > . ? /
    ID
    String that the Data Integration Service uses to identify the connection. The ID is not case sensitive. It must be 255 characters or less and must be unique in the domain. You cannot change this property after you create the connection. Default value is the connection name.
    Description
    Optional description for the connection.
    Location
    Domain in which the connection exists.
    Type
    Specific connection type, such as Oracle, Twitter, or Web Services.
    6. Click Next.
    7. Configure the connection properties.
    8. Click Test Connection to verify that you entered the connection properties correctly and that you can connect to the database, application, file system, or URI.
    9. Click Finish.
After you create a connection, you can add it to the Connection Explorer view.

Editing a Connection

You can edit the connection name, description, and connection properties.
    1. Click Window > Preferences.
    2. Select the type of connection that you want to edit.
    3. Expand the domain in the Available Connections list.
    4. Select the connection in Available Connections, and click Edit.
    The Edit Connection dialog box appears.
    5. Optionally, edit the connection name and description.
    Note: If you change a connection name, you must redeploy all applications that use the connection. You must also update all parameter files that use the connection parameter.
    6. Click Next.
    7. Optionally, edit the connection properties.
    8. Click Test Connection to verify that you entered the connection properties correctly and that you can connect to the database.
    9. Click OK to close the Edit Connection dialog box.
    10. Click OK to close the Preferences dialog box.

Copying a Connection

You can copy a connection within a domain or into another domain.
    1. Click Window > Preferences.
    2. Select the type of connection that you want to copy.
    3. Expand the domain in the Available Connections list.
    4. Select the connection in Available Connections, and click Copy.
    The Copy Connection dialog box appears.
    5. Enter the connection name and ID, and select the domain.
    The name and ID must be unique in the domain.
    Note: Before you copy a Hadoop, HDFS, HBase or Hive connection to another domain, create a cluster configuration in the domain with a name that matches the cluster configuration associated with the connection. For example, if the connection is associated with a cluster configuration named XYZ, create a cluster configuration named XYZ in the target domain.
    6. Click OK to close the Copy Connection dialog box.
    7. Click OK to close the Preferences dialog box.

Deleting a Connection

When you delete a connection through the Preferences dialog box, the Developer tool removes the connection from the Model repository.
    1. Click Window > Preferences.
    2. Select the type of connection that you want to delete.
    3. Expand the domain in the Available Connections list.
    4. Select the connection in Available Connections, and click Remove.
    5. Click OK to close the Preferences dialog box.

Refreshing the Connections List

Refresh the connections list to see the latest list of connections in the domain.
    1. Click Window > Preferences.
    2. Select the type of connection that you want to refresh.
    3. Select the domain in the Available Connections list.
    4. Click Refresh.
    5. Expand the domain in the Available Connections list to see the latest list of connections.
    6. Click OK to close the Preferences dialog box.