SAP PI Encrypt Soap request with private certificate

I’ve been working to secure the information with a SOAP web service with SAP PO and It’s an expensive and frustraiting task for me because I don’t have enough knowldege about TLS protocol and certificates.

In this entry I want to share my experience to do it.


  1. Create a keypair certificates in Keystore (Private key and public certificate) and export them
  2. Configure the SOAP sender communication Channel
  3. Configure the Integrated Configuration Scenario (ICO)
  4. Configure web service client (SOAP-UI)

1.Create a keypair certificates in Keystore (Private key and public certificate) and export them

Go to NWA> Configuration > Security > Certificates and keys, then on Key storage tab Add View, give it a name for key storage (it’s selected by default). Now on View Entries tab select create and set a name for your key pair, leave the options by default  and check Store Certificate optionand click next. Fill out the data for your certificate, something like this:

Seguir leyendo

SAP PI Proxy to JDBC to get millions of records

Recently I’ve had to develop a scenario  with Proxy to JDBC communication to extract a lot of records (millions of records), the strategy to achieve this is get a bunches of records in packages until transfer all records from database to SAP.

I’ve developed a Service Interface with tree operations:

  • Count: to get the number of records to extract
  • Transfer: to get records in packages
  • Delete: clear the table if the prrocess completes successfully

The execution logic is simple, first, SAP counts all record in DB to know how many of them will be extract, next an ABAP program calculate the size of packages and start to extract the records in packages, and count the transfered data per package, at last, if the transferred data is equal to initial count the source table is deleted.

The interesting point is on Message mapping, let’s review them: Seguir leyendo

JDK 8: Lambdas and Streams Introduction

I was enroll since 2014 in Oracle Learning to take a massive online course (MOC) named JDK 8: Lambdas and Streams Introduction, but I leaved it for the scholar activities and my work, I don’t had time to take it.

If you don’t know it, Oracle Learning has published a few free courses about Oracle Technologies, it looks very complete and interesting, may be you want give a try.

Well and now that I took the course to learn about new features about JDK 8 (I know, currently Java 8 is an old version, but I want to know it).

The video lessons are really good and very concrete, and I’m happy with the result, unaunfortunately the tests had expired, I don’t care too much becase the important is the content of the course, the maximum score that I could get is 88%:

2018-07-03 17_53_07-Learning Path Finder

I’m really happy with the result I want to know more about the Functional Programming and the best practices to use the Stream API and Lambdas, I think is very usefull aproach for Java language.

The next course that I want to take is the JVM Troubleshooting.


Maestro ¡Al fin! 2018

Este blog nació en 2008 cuando recibí mi título profesional, no tenía en claro que esperaba de esta página web, ya que solo quería escribir sobre mis pensamientos e ideas, pero me doy cuenta que ha sido una gran actividad que me ayudó a mejorar algunos aspectos en mi vida.

Nueve años después, en 2017, concluí un posgrado y 16 meses después he obtenido mi cédula profesional de la Dirección General de Profesiones. Me parece absurdo que tomará demasiado tiempo, esperar mi título tomó 7 meses,  tramitar la cédula otros 9 meses, quiero pensar que tuve mala suerte por el sismo del 19S, pero aun así estoy satisfecho de poder cerrar este logro y un ciclo en mi vida.

Además es divertido ver cómo han pasado los años y como he cambiado, pero sobre todo mi forma de pensar es muy diferente, mis metas han cambiado e incluso comencé a estudiar otra profesión, no con el objetivo de trabajar (gracias Robert Kyosaki).

Así que para honrar el primer post voy a dejar este hito con este logro en el blog.

Gracias a mi familia y a las personas cercanas que he conocido por animarme llegar hasta aquí, el hambre por aprender cosas nuevas se convirtió en un hábito.

2018-07-03 14_29_01-Clipboard



Java 8 Streams performance comparing

I’ve read in this post about the performance using Streams in Java 8 and this one from DZone with recommendations to improve functional programming, I want to do single performance test of the Stream API using funtional programming opatterns. Each one is very interesting, I recommend you read them.

To test this I’m going create a Student list with 900,000 instances, each one with ramdom scores and I’m get the maximun score with different loops for the Students graduaded on 2011.

And I want to show different variants to iterate my list

  • Loop with classic “for” instruction (old school style)
  • Loop Stream API with anonymous lambda
  • Loop Stream API with named functions
  • Loop Stream API with anonymous lambda (Optimized)
  • Loop Stream API with named functions (Optimized)
  • Loop Stream API, reduce function with anonymous lambda
  • Loop Stream API, reduce function with named function
  • Loop Stearm API, forEach with anonymous lambda
  • Loop Stearm API, forEach with named function

Seguir leyendo