loading
Blog

Smart Data Integration (SDI) – source data preparation

SDI provides two data replication approaches. We can use them with the SAP HANA Web-based Development Workbench:

  1. Replication task (To replicate data from objects in a remote source into SAP HANA tables, you must configure the replication process by creating an .hdbreptask file, which opens a file specific to the Replication Editor.)
  2. Flowgraph is a graphical model of data flow which can include numerous objects such as:
  • Tables, views, and procedures from the SAP HANA catalog
  • Transformations such as projections, filters, unions, and joins
  • Functions from Application Framework Modeling (AFM).
  • Attribute views and calculation views, and so on.
  • Runtime behaviours
Read more

How to use predictive search help in SAP?

Nowadays, more and more people focus on the user experience in the IT world. When we visit websites or work with applications, we expect that the usability of the tool will allow us to work or find necessary information in the shortest and the most efficient way. In the SAP you can also increase the user experience by implementing the predictive (type-ahead) search helps.

Read more

SAP EIM – Smart Data Integration (SDI) roles and privileges

Granting correct HANA user privileges is one of main tasks in a data integration process creation. It is possible to achieve this with SAP HANA Web-based Development Workbench or with Eclipse:

Read more

SAP Test Tool (PIT) – SAP PO 7.5 SP14

History

SAP has prepared a first version of a SAP PO upgrade testing tool – PIT. It’s being shipped with SP14 to SAP PO which is currently released.  The tool perfectly complements Int4 IFTT testing tool in one scenario the so please have a look how you can configure it to help you perform an SAP PO upgrade more easily.   

Use cases

SAP Test Tool primarily focuses:

  • help with SAP PO dual stack (ABAP & JAVA) to single stack migrations (JAVA only)

Availability/prerequisites

In order to use SAP Test Tool you need to have SAP PO 7.5SP14 (where you can install it or run test scenarios) but if you just want tofeed the SAP Test Tool with data you can use a system from 7.31 SP17 or 7.5SP06 or higher.

For each message used as a source you need to enable loggingon BI, MS, AM.

Current limitations (this may be subject to change)

  • ICOs with sender/receiver wild cards
  • Sync/async, async/sync bridges
  • Mapping splits
  • Flows with Decentralized adapter engines
  • No adapter modules are tested

Terminology used in SAP Test Tool

Test system – SAPPO system in the landscape which is used for testing – either as source(feeding the Test tool with messages) , target (where sender’s messages areexecuted) – those are used in dual stack to single stack migrations or both(sender and target) which is a typical use case for regression testing on asingle system.

Test Case – SAPPO routing configuration which is being tested (ICO, etc.)

Test Data Set – aset of messages (successfully processed) which is a subject for testing.

Run configuration– specifies on which landscape should the test case be executed

Authorizations

In order to be able to create the configuration and run ityou’d need the following roles: SAP_PIT_TEST_DEVELOPER, SAP_PIT_LANDSCAPE_ADMINISTRATOR.

Configuration

Currently SAP Test Tool is using NWDS as a mainconfiguration tool. The scenario below will describe how to do regressiontesting on a single SAP PO system. We will find a successfully processedmessage, do a mapping change and see what will happen once we reprocess thesame message via the same ICO. Ideally it should display all of thedifferencies between the two runs.

Step 1

Open NWDS and find the new perspective: SAP ProcessIntegration Test.

Step 2

Open preferences and insert connection data to your SAP POwere the SAP Test Tool is installed.

Step 3

In the next step you need to define the systems (source andtarget) where you need to run your tests. In this case it’s the same systemwhere SAP Test Tool is installed.

Step 4

In the next step we can start creating Test Cases.

Select the type of the flow you want to test.

In the next step it’s time to select the routing objectitself (ICO).

Step 5

In the next step the Test case is created so we can populateit with test data. In order to do that select the Test Data tab of the TestCase.

Then select the „Add“ button to add messages to the testdata where you can specify the source system from which you want to fetch thedata.

Next select the time range when the message was created and the message itself.

On the Verification tab of the Test case you can also definewhich parts of the message should not be checked (dates, etc.).

This step finishes the configuration/customizing part of theSAP Test Tool.

Run and validation.

In order to run the test you need to create a new runconfiguration.

Where you need to specify the Test Case and the landscape ofthe execution.

What you can also select here is the checkbox „Stop messagebefore delivering to Receiver“ which will automatically cancel the Test messageafter processing so it will not overload the receiver system.

Once you press Run the Test Case will get executed and theTestRun is executed you can send it for Verification which will compare the old(original) target message with the new one created by executing the Test Case.

As I’ve changed the mapping before running the Test Casewhat we can see is that there are some differences found.

In the Error Overview section we can see a more detaileddescription talling us the what is different between the original message andthe one from the Test Run.

Complementary tools:

SAP Test Tool is a free test tool provided by SAP which can help in some SAP PO Use types mentioned in this article. In case you’d need to Test some other use cases like the ones mentioned below fell free to contact us about a demo of the Int4 IFTT (the only SAP certified tool for testing all SAP middleware scenarios).

SAP Test Tool – PIT and Int4 IFTT scenario coverage

ToolSAP
PIT
Int4
IFTT
Use Case Support
SAP PO dual stack to single stack migrationsYesYes
3rd party middleware to SAP PO migrationsNoYes
SAP PO to 3rd party middleware migrationsNoYes
SAP EDI migrations (B2B add on)NoYes
SAP Cloud Platform Integration (CPI) testingNoYes
Service VirtualizationNoYes
S4/HANA conversions testingNoYes
SAP Backend validations (document field level)NoYes
SAP Backend (IDOC, Proxy) testing, SAP eCATT
integration
NoYes
SAP AIF TestingNoYes
Test Driven DevelopmentNoYes
Continuous testing/DevOpsNoYes
Integration test documentationNoYes
SAP PO Features
Use of successful messages as reference messagesYesYes
XML comparison (including exceptions)YesYes
EDIFACT/ flat files comparison (incl. exceptions)NoYes
Exchanging test cases between environmentsYesYes
SAP PO adapter module testingNoYes
SAP PO multimappingsNoYes
Background (scheduled) validations NoYes
Solman integration, incident managementNoYes
NWDS requiredYesNo
SAPGUI requiredNoYes
Scope
SAP PO only (after 7.31 SP17)YesNo
SAP PO (also versions prior to 7.31 SP17) , SAP CPI,
SAP Backend interface implementation,
3rd partymiddleware
NoYes
License
LicenseFreeLicensed

More videos on the SAP PO upgrades topic – How to upgrade you SAP PO landscape

Smart Data Integration (SDI) initial setup 

Standard architecture of Smart Data Integration product consists of three main parts:

a) Hana Index Server

b) Data Provisioning Server

c) Data Provisioning Agent

Read more

Int4 IFTT SAP PI Migration

With our latest service pack for Int4 IFTT (Interface Testing Tool) we’ve added a new feature to support SAP PO dual stack to single stack migrations. Read more

IFTT: how to set up a test for a message split?

Setting up an API test in Int4 IFTT for an SAP PO scenario with a message split can be a bit tricky due to the fact that message processing staging can be set up in a different way for each ICO. In case we want to regression test our SAP PO scenario we may need to consider the following steps:

Read more

New E-Bite from int4 on SAP AIF

We are happy to announce that our team members together with SAP Press have just published another SAP E-Bite. Interface Monitoring and Error Handling with SAP AIF will guide you how to handle errors and monitor interfaces with SAP AIF. Our three team members: Krzysztof Łuka, Wojciech Eichert and Mateusz Nowak made sure will guide you step by step how to monitor interfaces, handle errors, set up alerts and authorization and integrate SAP AIF with other monitoring tools.
Do you want to learn more about this book? Visit SAP Press website and order the E-Bite now!!

Interface monitoring in business process context with SAP AIF and Process Observer

Have a look at the picture above. What if, this huge jam was a result of a failing interface to or from the warehouse. Whether the root cause of the error is in communication, mapping, or anything else, you could quickly find out using the interface monitors, like the ones provided by SAP PI or SAP AIF. But on the other hand, from those monitors you would not see the implication that these errors have on the company’s business processes. Yes, in this case probably looking out the window would be enough😊 But, it is not always that obvious.
Read more

We love events!

Some weeks ago our company took participate in the Poznan Business Run. This is almost a tradition for our company, because we are part of this charity event every year!

The event was quite huge – over 3500 runners (700 teams) competed in this race! We are proud of our two teams, because both teams completed race as the fastest 30% of all teams!

 

As you know, int4 love events. There’s another opportunity to meet our team in person at SAP Teched Barcelona in 2018 (23rd-25th October).  We will be presenting our SAP certified automated regression testing and service interface virtualization software – IFTT.

Thanks to int4 IFTT you can fully automate testing of all your SAP PO/ SAP AIF/ SAP CPI/IDOC flows in both the middleware and at the SAP backend system. If you want to learn more visit our P01 booth ! Moreover, we have a suprise for you there- our experts will be available for you at our booth everyday from 13:00-14:00 to answer all of your SAP PI and SAP AIF related queries.