PowerExchange for SAP NetWeaver User Guide for PowerCenter

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

Back Next

Step 3. Create a Table to Process Empty DataSources

Create a table in any relational database to handle SAP DataSources with no data. Configure the listener workflow and the send request workflow sessions to write and read data from the relational table.

The default table name is BCILookupTable. Use the example syntax to create the table in the database:

CREATE TABLE BCILookupTable (Request_Id varchar(30), DataSourceName varchar(30))

If you create a table name with another name, you must use same table name that you created in the send request and the listener workflow sessions.

To change the table name in the send request source definition, open the Source Analyzer and click Sources:

Select the

SAPALEIDoc

and click

BCI_Listner

In the

Edit Tables

dialog box, click the

Metadata Extensions

tab.

In the

Edit Metadata Extension Value

dialog box, edit the table name.

To change the table name in the listener workflow, open the Target Designer and select Targets:

Select the target definition for the listener workflow.

In the

Edit Tables

dialog box, click the

Metadata Extensions

tab.

In the

Edit Metadata Extension Value

dialog box, edit the table name.

Business Content Integration

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

PowerExchange for SAP NetWeaver User Guide for PowerCenter

PowerExchange for SAP NetWeaver User Guide for PowerCenter

Step 3. Create a Table to Process Empty DataSources

Step 3. Create a Table to Process Empty DataSources