PowerExchange for Email Server User Guide for PowerCenter

PowerExchange for Email Server User Guide for PowerCenter

Creating a DSN for an Email Source Definition

Creating a DSN for an Email Source Definition

Create a DSN for each connection to the mail server and provide information specific to the mail server. This information changes for every DSN. You cannot modify a DSN after it is created. You need to create a new DSN to modify any information in the DSN.
  1. In the Source Analyzer, click Sources > Import from Email Server.
    The Import Email Source dialog box appears.
  2. Click the Browse button.
    The DSN Creation dialog box appears.
  3. Enter a name for the DSN.
  4. The following table describes the options that you can use to connect to a mail server or a PST file:
    Connectivity Option
    Description
    IMAP
    Uses IMAP to retrieve email data from a mail server.
    POP3
    Uses POP3 to retrieve email data from a mail server.
    MAPI
    Uses MAPI to retrieve email data from Microsoft Exchange Server. When you select this option, the Server Name, Password, and SSL Enabled options are disabled.
    PST
    Uses MAPI to retrieve email data from a PST file. When you select this option, the SSL Enabled option is disabled.
  5. The following table describes the DSN attributes that you need to enter:
    DSN Attribute
    Description
    User Name
    Use the following formats to enter user name:
    • IMAP. User name that precedes @ in the email ID.
    • POP3. User name that precedes @ in the email ID.
    • MAPI. User name in the username@domainname format. The User Name field can contain a maximum of 58 characters.
    • PST. This option is disabled.
    Password
    Email account password or PST file password. The PST file password is required when you retrieve data from a password protected file.
    When you use MAPI to extract data from Microsoft Exchange Server, the Password and Server Name options are disabled.
    Server Name
    Name of the server you want to connect to.
    PST File
    Absolute path to the PST file from which you want to extract data.
  6. Optionally, select the SSL Enabled option to extract emails from a mail sever over the POP3S or IMAPS secure protocols.
    The SSL Enabled option is disabled when you use the MAPI or PST Connectivity options.
  7. Click Add Certificate to specify a certificate file.
    The Designer adds the certificate to the keystore.
    When you import the certificate from a file for the first time, you might get a failed authentication error. This error occurs because the JVM may fail to reload the keystore. Open the Import Email Source dialog box again.
  8. Click Authenticate.
    After authentication, if you modify any of the DSN attributes, you must authenticate the updated attributes to connect to the mail server or PST. If you do not authenticate the updated attributes, the Designer uses the previously authenticated attributes to connect to the mail server or PST.
    If you have selected the MAPI option, the Designer verifies whether the profile for the specified user name exists.
  9. Click OK.