PowerExchange for SAP NetWeaver User Guide for PowerCenter

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

Back Next

Step 1. Import an InfoSource or a DataSource

In the Target Designer, you can connect to an SAP BI data source, browse its contents, and import selected transfer structures as targets.

From the Target Designer, click

Targets

Import from SAP BW

In the

Import SAP BW Metadata

dialog box, enter the login information.

The following table describes the login information:

Field	Description
Connect String	Required. DEST parameter defined in the client sapnwrfc.ini file for a connection to a specific SAP application server. When you import an InfoSource or a DataSource for the first time, the Designer reads the sapnwrfc.ini file and displays the first DEST entry as the connect string. After the first time you import an InfoSource or a DataSource, the Designer stores and displays the DEST entry used for the previous import. Select the DEST parameter that specifies the SAP BI source system from which you want to import InfoSources or DataSources.
User Name	Required. SAP BI user name.
Password	Required. Password for the user name.
Client	Required. SAP BI client number.
Language	Required. The language in which you want to receive messages from the SAP BI system while connected through this dialog box. Use a language code valid for the SAP BI system you are connecting to. If you leave this blank, PowerCenter uses the default language of the SAP system to connect to SAP BI.
DataSource Version	The version of the data source that you want to import. You can import a 3.x data source or a 7.x data source.

Click

Connect

to view the available InfoSources or DataSources.

From the list of transfer structures, find the InfoSource or DataSource you want to import.

If you import an InfoSource or DataSource from the Master Transfer List, you can select to import Attribute and Text InfoSources or DataSources.

Select the InfoSources or DataSources you want to import.

Hold down the

Shift

key to select blocks of sources.

Hold down the

Ctrl

key to make non-contiguous selections within a folder.

Use the

Select All

button to select all tables.

Use the

Select None

button to clear all selections.

Click

Add To Import List

To view the list, click

View Import List

The

Import List

dialog box appears.

To remove items from the list that you do not want to import, select the item and click

Delete

Click

to close the

Import List

dialog box.

You cannot include multiple InfoSources or DataSources with the same name from different source systems when you select InfoSources or DataSources to import. Import multiple InfoSources or DataSources with the same name from different source systems separately.

When the Import List is complete, click

The InfoSource or DataSource definitions display as target tables in the Target Designer. SAP BI may add /BIC/ to the InfoObject name.

If the target displays the correct InfoSource or DataSource name, but no ports display, make sure you correctly followed the steps to create an InfoSource or a DataSource.

Rename Saved Search

Table of Contents

PowerExchange for SAP NetWeaver User Guide for PowerCenter

PowerExchange for SAP NetWeaver User Guide for PowerCenter

Step 1. Import an InfoSource or a DataSource

Step 1. Import an InfoSource or a DataSource