PowerExchange for Lotus Notes User Guide for PowerCenter

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

Back Next

Importing a Lotus Notes Target Definition

When you connect to Lotus Notes to import a target definition, the Import Lotus Notes Target dialog box displays the forms and target definitions associated with the DSN.

The Designer displays the target definitions in the Import List. The naming convention for the target definition is <DSN name>:<Table name>.

You cannot import definitions of the fields that are part of the Layout area.

The following table describes the options that you can use when you import a Lotus Notes target definition:

Field	Description
Transfer Attachments	Transfers attachments in binary format.
Key Field	Transfers the documents that do not contain null value in the column for which you have enabled this option.
Multi-value Field	Indicates whether the target definition contains multi-value fields. The Designer sets this value to 1 if the target definition has multi-value fields. The Designer sets this value to 0 if the target definition does not have multi-value fields.
Transfer as Text	Transfers a multi-value field as text.

In the Target Analyzer, click Targets > Import from Lotus Notes.

The Import Lotus Notes Target dialog box appears.

Select the DSN to connect to the Domino server.

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

Enter the password.

Optionally, enter a filter condition.

Click Connect.

The Designer displays a list of forms, and target definitions associated with the DSN.

You must have permissions to view the forms.

Select the form, and click the right arrows (>>) button.

The Select Fields dialog box appears.

Enter the table name.

Select at least one field, and click the right arrows (>>) button.

The Edit Column Information dialog box appears.

Enter the column information.

Select a rich text field from the list.

Use the rich text field to transfer binary data. When you select the rich text field, the Attachment and AttachmentName columns are added to the Selected Fields area. AttachmentName stores the attachment name along with extension. An attachment stores the data in binary format.

Rename Saved Search

Table of Contents

PowerExchange for Lotus Notes User Guide for PowerCenter

PowerExchange for Lotus Notes User Guide for PowerCenter

Importing a Lotus Notes Target Definition

Importing a Lotus Notes Target Definition