Connections > Connection configuration > Configuring a connection

Configuring a connection

You can configure a connection on the Connections page in Administrator or in a wizard when you configure a mapping or task.
    1. Perform either of the following steps:
    2. Click New Connection.
    3. Configure the following connection details:
    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 of the connection.
    Maximum length is 255 characters.
    Type of connection, such as Salesforce or Oracle.
    4. Configure the connection-specific properties.
    For example, if you configure a flat file connection, enter the runtime environment to be used with the connection, the directory where the files are stored, the date format for date fields in the files, and the code page of the system that hosts the files.
    The following image shows the properties for a flat file connection:
    The connection properties vary by connection type. For flat file connections, you enter the runtime environment, directory, date format, and code page.
    5. To test the connection, click Test Connection.
    The results of the test are displayed on the page, as shown in the following image:
    When you test the connection, the test results are displayed at the top of the New Connection dialog box.
    If a database connection fails, contact the database administrator.
    6. Click Save to save the connection.