Getting Started

Getting Started

Configuring a connection

Configuring a connection

You can configure a connection on the
Connections
page, in a wizard as you configure a task or taskflow, or in the Mapping Designer as you configure a mapping.
To access the
Connections
page, in
Administrator
, select
Connections
.
  1. Configure the following connection details:
    Connection detail
    Description
    Connection Name
    Name of the connection.
    Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -
    Maximum length is 100 characters. Connection names are not case sensitive.
    Description
    Description of the connection.
    Maximum length is 255 characters.
    Type
    Type of connection, such as Salesforce or Oracle.
  2. Configure the connection-specific properties. For example, if this is a Flat File connection type, enter the runtime environment to be used with the connection, the directory where the flat file is stored, the date format for date fields in the flat file, and the code page of the system that hosts the flat file. The following image shows the property fields for a flat file connection:
    Specify the connection name, description, and connection type in the Connection Details section, then in the Connection Properties section, select the runtime environment, the location of the object, the date format, and the code page.
  3. To test the connection, click
    Test
    . The results of the test display on the page, as shown in the following image:
    If a database connection fails, contact the database administrator.
  4. Click
    Save
    to save the connection.

0 COMMENTS

We’d like to hear from you!