Scribd
Upload
64 views7 pages

Value Mapping and Integration Techniques

Uploaded by

saikrishnatadiboyina
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
64 views7 pages

Value Mapping and Integration Techniques

Uploaded by

saikrishnatadiboyina
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

 Data Store

 HTTP adaptor vs odata adaptor (by default it will write query) but in HTTP we need to write the
query manually
 Exception handling
 Externalize parameters
 Multi cast sequential and parallel
 Splitter and Gather
 Please differentiate Poll enricher and Content Enricher...
 Process Direct
 Value Mapping vs Fixed Values
 Using OData adaptor we are calling OData service
XSD Vs XML :XSD will be holding the element values at runtime. Schema Definiton –
Mandatory.. optional elements.. occurance of an element(Min Max ) ..data type of an element

Value Mapping Interview questions

Value Mapping in sap cpi is a method used to maintain a relationship between different values
representing the same data objects across various systems ..technically it acts as a birectional lookup
table allowing for consistent data transformation during integration process

When do you use value Mapping :

Value Mapping is used when there is a need for data consistency and integrity across different systems it
is particulary useful in scenarios where data needs to be adapted to specific business rules or when
dealing with large data sets

What are different ways to use value Mappings:

 Graphical Mapping
 Import from CSV file
 Using API
Examples of value Mapping Sceanrios:

 Business Partner Translations: translating different business partners


 Country Code Mapping-converting country codes to country names
 Currency Code Mapping-Converting currency codes to currency names.

Fixed Value Mapping: Fixed Value is very useful when you have lots of conditions coming in one source
fields during mapping, then to avoid the IfThenElse or UDF we go for Fixed Value mapping.

Example: if your source field contains 01 or 02 or 03 or.....12 and you want the result as JAN or FEB or
MAR or ......... DEC.

Advantage: Using fixed value table you can see the result immediately in the mapping.

Disadvantage: If you have used the same fixed value mapping at several places in you mapping then in
case of any change in fixed values you have to make the changes at several places. So in short fixed
value mapping is not good from the maintenance point of view.

Value Mapping: Value Mapping also works in the same way as fixed value mapping, only the thing is you
will get the result at run time only. And you have to define the value mapping in Integration directory.

Advantage: If you have used the same value mapping at several places in you mapping then in case of
any changes in values you don't have to make the changes in you mapping, just make the changes in in
value mapping in Integration Directory, that's it.

Scenarios:

 JDBC TO SFTP
 SFTP TO JDBC
 ODATA TO SFTP
 IDOC TO REST API
 Manual and Scheduler Runs in Single iFlow

Poll enrich to pull the file from SFTP server using SFTP adapter Content Enricher to enrich the XML
data from Odata service using Odata/SF adapter

In real time also we cant Poll more than one file using Poll Enricher in Single run...... Poll enrich will pull
only one file real time too

how can we get messages from discarded status to completed status... Based on Worker Node
instances, Discarded messages will be generated

to pick files from 10 different directories of single sftp server using sftp adapter-u have to use multiple
"poll enrich" functions to pull data from multiple folders
Manual and Schedule run in one iflow :

We are pulling the data from OData service via OData adaptor and pushing it to SFTP server
Creation of a variable

In our IFlow, we have to include a ‘Write Variables’ shape to do this. Using simple camel expression as
shown below, we can store values in variables. Please note that we did not need to create a Variable by
going into Operations view first.

As we had discussed earlier, we may wish to store this value only for a particular path of execution
among many. In that case, we can place this shape in only that path.

Reading Variable value

To read the values stored in variables, all we need to do is reference the variables as shown below. This
can be done in Message Exchange Properties as well.

Number Ranges

Now we are going to hop on to the next topic: Number Ranges. We already know it’s a mode of data
persistence, but what exactly does it do and what makes it different?
Number ranges act as sequences which can be used for marking messages, among other applications.
Suppose that in a particular integration scenario, all messages to the destination system must have a
unique sequence number. This is where a number range can be of use.

Creating Number Ranges

Before use, Number ranges have to be created by specifying the following:


 Name: Give a unique name that will be used to reference this Number Range.
 Description: Not mandatory, but generally a good practice to include this information to avoid
any confusion in the future.
 Minimum value: A non negative integer value with maximum 14 characters. Cannot enter
string/characters here.
 Minimum value: A non negative integer value with maximum 14 characters. Cannot enter
string/characters here.
 Field Length: The length of the sequence number returned by this number range.
 Rotate: If the maximum value is reached, the first value is picked as the next number in
sequence.

Using Number Ranges

Number ranges can be used by referencing them in Message Headers/Exchange properties.


Number ranges can be used as per requirement. If they are to be used only under certain conditions and
not in every execution, they can be referenced within the path matching those conditions to avoid
unnecessary wastage of numbers in sequence. This can be done with the use of Routers, for example.

Can the same number range be referenced in multiple IFlows?

Yes, but remember that whenever they are referenced during an execution, the value is incremented by
1. If you are using the same number range for multiple integration flows, it can lead to confusion over
apparently skipped values. Moreover, if the destination systems are expecting a continuous sequence, it
will be problematic to use the same number range in multiple integration Flows.

Can the same number range be referenced at multiple places in the same IFlow?

Yes, this can be done as well. But we can expect skipped values as a result. For example, if a number
range is referenced twice during an execution, the value of that number range will be incremented by 2.
Keeping this in consideration, the same number range be referenced multiple times and even used to
create increments/steps of n instead of just 1.

Can the next value of a number range be changed?

We can manually set the next value of a number range to some specific value. Although this is not
usually encouraged, under some rare circumstances this may be warranted. This can be achieved by
Editing the Number range under Operations view->Number Ranges.

Common questions

Powered by AI

Number ranges in SAP CPI act as sequences used for marking messages, ensuring unique identifiers. They must be created with a name, description, minimum value, field length, and a rotation setting. When a number range is referenced in multiple IFlows, it can cause confusion with skipped values, as each reference increments the sequence. Consistent sequence expectations may lead to issues. Manually setting the next value is possible but not recommended as it can disrupt sequence integrity .

Content enricher is used to enhance XML data from an OData service using an OData or SF adapter, helping enrich the data during processing. Poll enricher, on the other hand, is used to retrieve files from an SFTP server with an SFTP adapter. It pulls a single file per run and is limited to that function. Each serves different purposes depending on whether the task is data enrichment or file retrieval .

SAP CPI handles file retrieval using the SFTP adapter with a Poll Enricher that pulls one file per run from the server. The limitation is that the adapter cannot retrieve more than one file at a time in a single run, requiring multiple Poll Enrichers if files from different directories are needed. This constraint necessitates strategic design for processes involving high file retrieval requirements .

The advantage of fixed value mapping is the immediate visibility of results in mapping, making it useful when a source field has many conditions. However, it has a maintenance disadvantage as changes in fixed values require updates in multiple mapping locations. Value mapping offers easier maintenance since changes are centralized in the Integration Directory, but results are only available at runtime .

Value mapping can handle internationalization issues by translating currency codes to names or converting country codes to country names. The mapping is configured to ensure data consistency, allowing seamless integration across systems requiring different representations of similar data .

Externalizing parameters in SAP CPI is crucial for enhancing configuration flexibility and maintainability. It allows parameters to be managed separately from the integration logic, facilitating easier updates and reusability without altering the core process .

Value mapping in SAP CPI maintains a relationship between different values representing the same data objects across various systems, acting as a bidirectional lookup table to ensure consistent data transformation. This method is particularly useful when data needs adaptation to meet specific business rules or when dealing with large datasets .

In SAP CPI, discarded messages occur due to constraints like fetching from multiple SFTP directories. Worker nodes manage these messages by using multiple Poll Enrichers, preventing loss of required data. This approach necessitates careful flow design to ensure efficient resource use and message throughput .

In SAP CPI, value mapping as a bidirectional lookup table is implemented to maintain a consistent relationship between different values representing similar data objects. This table allows for both forward and reverse lookups, facilitating uniform data transformation across various integration scenarios .

Using the OData adaptor in SAP CPI simplifies integration as it automatically handles query writing, while the HTTP adaptor requires manual query writing. Choosing between them affects integration complexity and adaptability to pre-defined conventions versus custom configurations .

You might also like