Table of Contents

Search

  1. Preface
  2. Connectors and connections
  3. Connection configuration
  4. Connection properties
  5. Swagger file generation for REST V2 connections

Data Integration Connections

Data Integration Connections

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:
    • In
      Administrator
      , select
      Connections
      .
    • In
      Data Integration
      , open a source, target, or lookup object in a mapping or task.
  2. Click
    New Connection
    .
  3. Configure the following connection details:
    Property
    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.
  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.