PowerExchange for Lotus Notes User Guide for PowerCenter

10.4.0
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5.4
- 10.5

Back Next

Importing a Source Definition from a Lotus Notes Mail Database

When you import a source definition from a Lotus Notes mail database, you import the email metadata. You cannot view or edit the column information for a mail database source definition. The Designer lists the source definition in the Import List. The naming convention for the source definition is <DSN name>:<Mail database name>. For example, the Import List displays the source definition name as MailDB:SHarris, where MailDB is the DSN name and SHarris is the Lotus Notes mail database name.

The following table describes the options that you can use when you import a Lotus Notes mail database as a source definition:

Field	Description
To	Contains all email IDs specified in the To field.
From	Contains email ID in the From field.
Cc	Contains all email IDs specified in the Cc field.
Bcc	Contains all email IDs specified in the Bcc field.
Transfer Attachments	Transfers attachments in binary format.
Sent Date	Contains the date on which an email was sent.
Subject	Contains the subject of the email.
Body	A rich text field that contains email data.
Transfer Text	Transfers a rich text field as text.
Transfer Images	Transfers .BMP and .GIF images in binary format.
Transfer Tables	Transfers the text in tables as a comma-separated list.

In the Source Analyzer, click Sources > Import from Lotus Notes.

The Import Lotus Notes Source dialog box appears.

Select a DSN from the list.

If you need to create or modify a DSN, click the Browse button to open the Create DSN dialog box.

Click the Browse button.

The Create DSN dialog box appears.

Select Import Mail Database.

Click Authenticate.

The Import Mail Database dialog box appears.

Enter the name of the Lotus Notes mail database to import.

Select at least one field to import from the Lotus Notes mail database.

By default, the email body is a rich text field. To transfer the text of the email body, select the Body and Transfer Text options.

Click OK.

In the Create DSN dialog box, click OK.

The Import Lotus Notes Source dialog box displays the selected mail database in the Import List.

Rename Saved Search

Table of Contents

PowerExchange for Lotus Notes User Guide for PowerCenter

PowerExchange for Lotus Notes User Guide for PowerCenter

Importing a Source Definition from a Lotus Notes Mail Database

Importing a Source Definition from a Lotus Notes Mail Database