Getting Started > Connection configuration > 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.
    1Configure 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.
    2Configure 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.
    3To 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.
    4Click Save to save the connection.