DB Lookup

[Former Member]

Hi all,

Can anybody tell me what is meant by DB Lookup?

Regads

Krishna.

[Former Member]

Krishna,

From the source values if you want to find any value for the corresponding input which is stored externally to XI we will use Lookup. There are various lookups like RFC, JDBC etc. If you want to do lookup your SP should be atleast SP13. Please see this help:

http://help.sap.com/saphelp_nw04/helpdata/en/c9/9844428e9cbe30e10000000a155106/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/en/cf/406642ea59c753e10000000a1550b0/frameset.htm

Regards,

---Satish

[Former Member]

Hi

Lookup in XI is used to call the target data storage system and get data from there to your mapping programme.

In XI you can do Lookup in Message Mapping, Java Mapping and in XSLT Mapping. Previously Lookup in XI was system dependent. But now what ever the system are i.e. SAP system or non-sap system(Oracle,MS SQL etc) lookup API are same.

<b>Overview of Lookup</b>

- Lookups are used to identify/request the data from mapping program.

- It interrupt the process and looking for data which was stored in target system.

- It get that data and comeback to process and continue with that data.

<b>Types of Lookups in XI</b>

- JDBC Lookup: JDBC lookup is used for accessing data from database (non SAP).

- RFC Lookup: RFC lookup is used for accessing the SAP Data.

- SOAP Lookup: SOAP lookup is used for accessing data from Webservice

<b>Steps to perform Lookup in Mapping</b>

Import package com.sap.aii.mapping.lookup.*;

Create connection to the target Database system.

// Determine communication channel created in ID

Channel channel = null;

channel = LookupService.getChannel("DB-SYSTEM-NAME","DB-CHANNEL-NAME");

// Get system accessor for the channel.

DataBaseAccessor accessor = null;

accessor = LookupService.getDataBaseAccessor(channel);

Build the Query String.

Getting Result

// Execute Query and get the values.

DataBaseResult resultSet = null;

resultSet = accessor.execute(Query);

[Former Member]

Hi Krishna,

Accessing data from an external database is the objective of DB lookup.

When it is used : -

The data required to be accessed from an external database residing on some other system.

How it is called:

Called from within the XI Mapping Program.

Introduction

Objective:

Data LookUp from an external database.

Proposed Solutions:

1) Import the data from the external system perform a value-based-transformation.

2) Execute a call to an external database with the purpose of accessing the desired data.

3) BPM can be used to perform Data Look Ups.

Business scenario

Simple Data lookup.

Source:

Inbound Document contains “EN”.

Target:

Outbound Document should reflect the value “ENGLISH” as an expansion for “EN”.

How?

The translation data or logic is contained in external database. Mapping program calls it through Data LookUp.

Hope this helps

Regards

Kiran..

[justin_santhanam]

Krishna,

Refer the blog :/people/siva.maranani/blog/2005/08/23/lookup146s-in-xi-made-simpler

If you have doubts then reply back.

Best regards,

raj.