PowerExchange for Email Server User Guide for PowerCenter

PowerExchange for Email Server User Guide for PowerCenter

Importing an Email Source Definition

Importing an Email Source Definition

  1. In the Source Analyzer, click Sources > Import from Email Server.
    The Import Email Source dialog box appears.
  2. Select the DSN used to connect to source system.
    If you extract metadata from Microsoft Exchange Server, a dialog box prompts you to enter the password. Enter the password and click OK.
  3. Enter the password to connect to the mail server.
    You must have mail server administrative permissions to view the object. You do not require mail server administrative permissions when you use MAPI to extract metadata from Microsoft Exchange Server.
  4. Click Connect.
    A list of folders on the mail server or in the PST file appears.
    The list of folders that appears in the Select to Import tree view contains all the folders available in the PST file and mail server, such as Calendar and Tasks. These folders can contain non‑email data. The PowerCenter Integration Service retrieves only the email data from these folders.
    The PowerCenter Integration Service uses MAPI to retrieve Contacts data from Microsoft Exchange Server.
  5. Select the folder you want to import.
    When you use POP3, you can access the INBOX folder.
  6. Click the right arrows (>>) button to add the selected folder to the import list.
    The Field Selection dialog box appears.
    The Fields list displays the fields present in the selected folder.
  7. Enter a new folder name if required.
  8. From the Fields list, select the fields to map and click the right arrows (>>) button.
    The mapped fields appear in the Mapped Fields list.
    Email body is retrieved through the Content field with MIME parts separated by the character string “--=__=\.”
  9. To change the column name or precision, double-click the field name in the Mapped Fields list.
  10. Enter a name for the column.
  11. Enter the precision for the column.
  12. Click OK.
  13. To retrieve attachments along with the email data, select
    Retrieve Attachments
    .
    When you select the Retrieve Attachments option, the Attachment and AttachmentName columns are added to the Mapped Fields list. AttachmentName stores the attachment name along with extension. An Attachment stores the data in binary format. Attachments of up to 100 MB are supported.
    The PowerExchange for Email Server can extract multiple attachments regardless of the type of file. The PowerExchange for Email Server extracts nested attachments as single attachment in the binary format.
  14. Click Filter to filter email data.
    The Filter dialog box appears.
  15. Specify the filter criteria for fields.
    You can define one condition for each field.
  16. Click OK.
  17. Optionally, click Data Preview in the Field Selection dialog box to preview data for the mapped fields.
    You can preview data if the email source definition is based on the email folder.
  18. Click OK.
  19. In the Import Email Source dialog box, click OK to import the email source definition.
    You can import multiple source definitions from the folders on a mail server or in a PST file.