Friday, November 24, 2023

How to Integrate SAP ERP system and external or Internal API services

 Find our Analysis on how smoothly and seamlessly you can integrate SAP ERP system with different varieties of API services in the market

Click below link for explanation video

SAP ERP and API Integration possibilities



how to SAP ERP system can consume API services provided by external parties or partners 


This integration can be done through 3 ways


1. Direct integration with API services using SAP Netweaver middleware 


This allows SAP ERP systems to connect to API services using a variety of protocols, such as HTTP, SOAP, and XML-RPC

Direct integration can be complex and time consuming but it gives us the high degree of control over the integration process


2. Third party Middlware 


These products can provide a variety of features, such as routing, transformation, and security, which can simplify the process of consuming API services



3. Cloud based Intgration platforms


These platforms will provide hosted environment for integrating SAP ERP systems with API services which

can simplify the process of integration and reduces on-premises cost     




What are the third party middleware software's are using for integration between SAP ERP and API services


There are multiple Third party softwares are available for integration between SAP ERP system and API services

Some of most popular ones as below


1. SAP Cloud Platform Integration


This platform can be used integrate SAP ERP ssystem with wide variety of API services using different communication 

channels like HTTP , SOAP , REST API 



2. Mulesoft Anypoint platform 


it is hybrid middleware platform which can be used to integrate between SAP ERP and different APIs using  

different communication channels like HTTP , SOAP , REST API etc. It is most user friendly software and drag and drop

interface.



3. IBM Websphere ESB 


it is one of middleware platforms which can be used to integrate between SAP ERP and different APIs using  

different communication channels like HTTP , SOAP , REST API etc.



4. Oracle Integration Cloud


This is cloud based Integration platform and this can be used integrate between SAP ERP and different APIs using  

different communication channels like HTTP , SOAP , REST API etc.



5. WSO2 Enterprise Integrator


This is open source Integration platform and this can be used integrate between SAP ERP and different APIs using  

different communication channels like HTTP , SOAP , REST API etc.



There are several cost-effective and dependable third-party middleware software options available for integrating

SAP ERP systems with API services


1. WSO2 Enterprise Integrator (EI)


2. Apache Camel



Commercial products will provide comprehensive set of features , security and support 



Thursday, August 4, 2022

How do we resolved first time FTPS connectivity issue with partner using IBM B2B Sterling Integrator

๐Ÿ˜Ÿ๐Ÿ˜Ÿ๐Ÿ˜ŸBackground of Actual problem :

            I am working for Banking client who is doing business with their partners by sending payment files using different communication channels like SFTP , HTTP , API etc. For first time one partner come up with integration requirement by using FTPS communication which is new to our banking client. My client using IBM Sterling Integrator as B2B/EDI tool to do integration with partners and this is the first partner using FTPS connectivity. While implementing and getting connectivity established with partner , we encountered many issues with their FTPs Server.

๐Ÿ˜ฎ๐Ÿ˜ฎ๐Ÿ˜ฎProblem Statement :

           When we trying to connect and to do list out the files which are available in their remote directory , initially we are getting handshake failure and cannot move forward to do list files operation. We have already opened outbound ports at bank firewall and customer are  also opened bank ports at their side. As part of analysis we have asked partner to provide acceptable ciphers at their side and compare with ciphers which are configured at Bank side.while initial analysis we found that there is Ciphers mismatch at handshake and it causes the issue.

๐Ÿ˜ฒ๐Ÿ˜ฒ๐Ÿ˜ฒSuggestion : 

           To resolve this issue, we have conducted multiple debugging sessions with all the stakeholders  partner , Bank's team (myself) , Network team , operating system admin and B2B application vendor etc. In each session we have implemented below suggestions/changes mentioned at B2B server level by B2B vendor team and did the testing in meeting when all the stake holders are present and do the monitoring the traffic.Initially we asked to do below mentioned changes at their FTPS server side and they didn't aggree to do changes. Partner side they cannot make necessary changes to accepts ciphers which are configured at bank because already they are integrated with their partners and they dont want to expect any issues with their partners by cipher changes.

  • SNI need to be disabled
  • TLS 1.3 version need to disabled if it is enabled already and TLS1.2 version should be default


 Next trouble shooting session we have verified all the settings , logs and configurations with help of IBM vendor. We have found issue with certificates (Intermediate , Root and Leaf) and while importing 
 certificates it is giving error as "Auth chain is incomplete". To resolve this issue, we have directly
 downloaded the certificates from their server using certificate grabber utility in Sterling B2B integrator
and imported into B2B server. Then it resolves the certificates issue. Now we tried to post file but
 it is not successful. at this time we enabled trace at both Network level and OS level. In trace root
 we saw as B2B server sending packets but we are not receiving client hello packets back.

When customer did the CA certificates validity check using openssl it is giving result as OK , but there can still be some problems with the way SI checks additional points in validity beyond whether certificate is expired or properly chained.

To resolve this issue we have conducted multiple trouble shooting sessions with all the integration stake holders. As part these meeting IBM vendor suggested server level changes and we have done those changes and restarted the IBM SI server and verified the connectivity.

Suggestion 1 :

   Change the order of security providers in Java security file in SIB2BInstallationPath/jdk/jre/lib/security/java.security

Existing

#

# List of providers and their preference orders (see above):

#

security.provider.1=com.ibm.crypto.fips.provider.IBMJCEFIPS

security.provider.2=com.ibm.crypto.provider.IBMJCE

security.provider.3=org.bouncycastle.jce.provider.BouncyCastleProvider

security.provider.4=com.certicom.ecc.jcae.Certicom

security.provider.5=com.sterlingcommerce.security.jcae.STERCOMM

security.provider.6=com.ibm.jsse2.IBMJSSEProvider2

security.provider.7=com.ibm.security.jgss.IBMJGSSProvider

 
Change it to

 
security.provider.1=com.ibm.crypto.provider.IBMJCE

security.provider.2=com.ibm.crypto.fips.provider.IBMJCEFIPS

 
And restart the SIB2B server.


Suggestion  2 :

In Properties folder in installation path

Set FIPSMode=true in security.properties


And restart the server


Suggestion 3 : 

You can try putting in customer_overrides.properties: in SIB2B installation path

    security.FactoryTrustManagerAlgorithm=IbmPKIX

This trust manager is more lenient than default IbmX509, if you manage to connect with it might give us additional clue. You need to do this on both nodes.

And restart the SIB2B server.


Finally we are able to connect out client FTP server using security certificate.


Suggestion 4 :

After that we faced files posting issue after connecting their server. To resolve this issue

we have added new configuration in customer_overrides.properties: in SIB2B installation path

 ps_ftpclient.honourPASV=false

 After changing all these configurations then we (Bank) are able to connect their partner FTPS server and post files successfully.  

<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-3718162507869387"
     crossorigin="anonymous"></script>

<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-3718162507869387"
     crossorigin="anonymous"></script>
<!-- MySquareAd -->
<ins class="adsbygoogle"
     style="display:block"
     data-ad-client="ca-pub-3718162507869387"
     data-ad-slot="5896879220"
     data-ad-format="auto"
     data-full-width-responsive="true"></ins>
<script>
     (adsbygoogle = window.adsbygoogle || []).push({});
</script>
             **********************************************************************





Tuesday, March 22, 2022

Amazon Payee Central integration with OMS application running on AWS cloud using Opensource Tools

 Amazon payee Central integration with OMS application running on AWS cloud using Opensource Tools

   

   Recently I had opportunity to work on integration between Amazon Payee Central and OMS running on AWS cloud. 

   Initially we have implemented the Invoice Payment message integration as part of this project. In this 

   implementation there are multiple applications involved to archive the required integration requirement.

   

To implement this integration below mentioned tasks are performed

   

   Pre requisites information for this implementation has been provided to customer .

   

   1. Having Amazon payee central account for generating invoices

   2. Having personal/Business Website with own web space and domain name for your website and Email account if notification are required

       3. Having any commercial Order Management System or own OMS application or any Database with Order Management schemas and tables.

       


       Implementing actual high level integration steps which I have followed    

   1. EDI setup in Amazon payee Central for exchanging EDi files over AS2

   2. Create our own self-signed or CA certified AS2 certificates for our company / business

   3. Create AS2 http/https url (resource) for receiving or sending files to/from Amazon 

   4. Configure our company / business certificates and Website AS2 resource URL in Amazon payee central

   5. Install opensource AS2 software application running on on-premise or on cloud (AWS or Azure or IBM cloud or google cloud)

   6. Configure our company certificates and Amazon AS2 certificates in our AS2 application

   7. Now coming to Translation, we need to use either opensource EDI translator or any coding language like java, .Net , Python or PHP etc. to do the translation from OMS format to corresponding transaction EDI format.

   8. In our case, as requested by customer I have used PHP script to do the translation and after successful translation file will be written some folder on AWS cloud

   9. Internal OMS application will generate some invoice file in application format (Ex. Flatfile , CSV or Database) and written to some folder on AWS

   10. From that folder translation program will pick and do the translation. After successful translation , files written to another folder where AS2 program can pick and push the file to Amazon.

   11. Initially Amazon wont receive the files until we activate the EDI connection in Amazon Payee central

       12. To activate the AS2 connection , we need to upload 3 EDI formatted Invoice files successfully in the Amazon payee central dashboard by licking connections tab.

       13. Once EDI invoice files successfully validated then the AS2 connection will be changed to Active status. 

       14. Once connection is activated then only Amazon can receive files from us and files can be tracked/showed in search results whether the files are processes or failed.     

   

Just for reference, here is the list of available OMS software's with commercial license

         1. Quickbooks Commerce                https://quickbooks.intuit.com/quickbooks-commerce/

         2. Brightpearl                        https://www.brightpearl.com/

         3. Skubana                            https://www.skubana.com/

4. Freestyle Solutions                https://www.freestylesolutions.com/

5. Odoo — Best Open Source OMS        https://www.odoo.com/

6. Brightpearl                        https://www.brightpearl.com/order-management

7. Veeqo                              https://www.veeqo.com/order-management-system

         8. Magento                            https://www.magestore.com/features/magento-order-management/

https://www.softwaretestinghelp.com/order-management-system/  


 

Tuesday, November 16, 2021

L&T Infotech Mega Virtual Off-Campus Drive for 2020 & 2021 batch freshers

Larsen & Turbo Infotech

Mega Virtual Off-Campus Drive for 2020 & 2021 batch freshers

 

Graphical user interface, application

Description automatically generated

 

Regards,

Campus Recruitment Team

Saturday, October 16, 2021

Sterling Integrator Administaration Related Interview Questions Part 1

 Sterling Integrator Administaration Related Interview Questions :

 

                                                                      PART - 1                                                                             


What is the difference between Properties and properties.in files   

AND Why do we use Customer_overrides property file


*.properties


A file that is used during the operation of Sterling B2B Integrator.


The initial properties in this file are set by the file's corresponding *.properties.in file.


*.properties*_ext


A file that is used during the operation of Sterling B2B Integrator. It is an 

extension of the similarly named *.properties file. More application-specific customization 

can be done in *.properties*_ext files. The initial properties in this file are set 

by the file's corresponding *.properties*_ext.in file.


*.properties.in


An initialization file that is used during an installation. It sets the initial values of *.properties files.


*customer_overrides.properties


The file that maintains changes in *.properties and *.properties*_ext files. 

This file overrides *.properties.in and *.properties*ext.in files when Sterling B2B 

Integrator is re-installed or when the setupfiles script is run.

customer_overrides.properties – Make changes to this override file instead of 

individual property files to ensure that none of your changes are lost during an 

upgrade or patch installation. This also lets you see most of the overrides in your 

configuration at a glance rather than having to check each property file individually. 

This file is not delivered with the product; you must create it the first time you have a need for it.



what are the containers in sterling integrator


You can achieve higher availability by using the adapter container. The 5.1 and

5.2 releases added a new component called an adapter container. When you use

the adapter container to host communication adapters, they have a different lifecycle than the application 

server-independent virtual machine (ASI JVM), which does data processing


A number of adapters can be run in the adapter container. These include custom

adapters as well as those shipped with the product. These adapters can run in a

separate JVM by creating an adapter container as in the product install. An

adapter container can be easily created afterwards at any time. The initial

adapter container creation will require a system outage,


FTP Server Adapter

FTPS Server Adapter

SFTP Server Adapter

HTTP Server Adapter

HTTPS Server Adapter

Connect:Direct Server Adapter




Where do we configure new database connection  AND  Why do we use Customer_overrides property file


In the customer_overrides.properties file, specify the database server name, port number, database/catalog name,

 user ID, and password. To encrypt your database password, use the encrypt_string.sh or encrypt_string.cmd 

 utility in the bin directory. Then place the encrypted password, prefixed by an encryption indicator, 

 in the customer_overrides.properties file.

To update Sterling B2B Integrator with this new pool information, restart the application.

In the install_dir/install/properties directory, locate the customer_overrides.properties file.

Open the customer_overrides.properties file in a text editor.

Modify the properties you want to change in the customer pools list of properties.

Save the customer_overrides.properties file.

After modifying the pool properties in customer_overrides.properties, go to JDBC monitor page and click the 

Refresh JDBC Pools button, or run the REFRESHJDBC OPS command from the install

 root directory: ./bin/opscmd.sh -cREFRESHJDBC -nnode1



Why do we use queues / queue watcher in monitor sterling integrator


Open your web browser to http://host:port/queueWatch, where host:port is the IP address and port number 

where Sterling B2B Integrator resides on your system. A login page appears.


Any user with Administrator privileges can login to the Queue Watcher application, provided he has all the 

necessary permissions or is a part of the Sterling B2B Integrator Administrator group.


View Active Threads for All Queues

QueueName – Displays the queue name

Used – Number of business processes currently running on a thread.


Calc – Fairshare thread calculation for the queue. Fairshare is based on concurrent activities on all queues and is dynamically updated.


Pool – Number of threads in a queue's pool. Threads timeout if they are not used.


Max – Maximum number of threads used by the queue. Calc determines the maximum concurrent threads that is dynamically calculated.


Queue Depth – Number of business processes waiting for a thread in the queue.


List of Working Threads – List of business processes currently running on a thread.


Queue_1 – Queue_9 Displays running and waiting (for available thread) business processes.


View VM Status Displays Java™ Virtual Machine status.


To avoid having these changes overwritten with the next build or patch, add the following to customer_overrides.properties:


noapp.queueWatcher=true



Saturday, November 14, 2020

Are looking for EDI B2B Integration Solution for your business under $50...




Some kind of Integration Issues which you are facing Is it the license cost of commercial EDI branded product is increasing year on year? Are you getting frustrated with support provided by SaaS EDI solutions providers? Are you looking for an EDI B2B solution for under $5000? Please reach us : Choose the OpenSourceEDISuite platform for your EDI B2B Integration with bigger customers like Amazon, Walmart, eBay, etc. You own the complete tool and solution and the data which you are dealing with. Have a look at this solution before buying any commercial products. You can reach us over below LinkedIn Profile : https://www.linkedin.com/in/srinivas-potipireddi-93a6854/ -------------------------------------------------------------------------------------------------------------- Mail ID : b2biexpert@gmail.com opensourceedisuite@gmail.com psv_edi@yahoo.com -------------------------------------------------------------------------------------------------------------- Blog Name : http://sriniedibasics.blogspot.com/ -------------------------------------------------------------------------------------------------------------- Facebook Profile : https://www.facebook.com/potipireddi/ -------------------------------------------------------------------------------------------------------------- Twitter Profile : https://twitter.com/psv_bec --------------------------------------------------------------------------------------------------------------

Tuesday, August 11, 2020

Overview and basics about about EDIFECS SPEC BUILDER

 Overview About Spec Builder :


I am going to explain about capabilities of spec builder and let's get started with

the general overview on your screen you see the main spec doodle UI I'm

currently using version 8.4 as you can tell from the title bar your version of

spec duder may be slightly different please reach out to us in case you need

some details of how to obtain the most recent version so let's get started on

your screen you see a left ribbon with the major spec doodle functions or spec

builder modules and there is a top ribbon which allows you to get a quick

access to the features of specular or to customize the views or to do some basic

operations there are several main modules we'll go over them one by one at 

a very high level


a new guideline allows you to create a new guideline from one of our standard 

databases here I have installed just a few of them but there are much more 

available and provided out of the box by artifacts when I say standard database 

that literally means the out-of-the-box package which contains all versions and 

all transactions for the certain standard now I'm browsing x12 but we 

have also hl7 NCPDP we have a defect available and many more so when getting 

spec builder you can also get out-of-the-box pre-built specifications 

for the particular standard and as you can see we have all versions from the 

very old up to the most recent ones. 


the new map allows you to build the map or the transformation

logic between two we call them guidelines between two specifications

will again talk about the mapping.


open this just gives you access to the pre-saved guideline which you created before. 


spec generator is the tool which allows you to generate the specification or the

guideline from your existing data file it is kind of reverse engineering again.


data generator is a reverse to generate the data out of the out of the

specification so basically it gives you ability to generate some test data and

you define the way how you want this test data to be generated how many

optional segments how many transactions how many inner changes and so forth.


analyzer is the module which analyzes the data it verifies that the data

compliance to the specification it gives all the errors if there are any in the

data file and you can very easily and intuitively navigate through between the

data and the place in the specification which causes some particular error


migrator this tool allows you to solve the following problem this is the most

typical use case imagine there is a existing version of let's say x12

guideline which is forty ten you apply some customization to that guideline you

exclude certain segments you remove or add your segments based on your trading

partner agreement and tomorrow there is a new version of x12 let's say 60 20 so

you cannot just take the 60 20 out of the box and use it because for that

trading partner you already agreed that segments would be excluded or deleted or

edit so what you have to do is you have to take all those edits that you've done

4010 term guideline and now redo them on the 60 20 Wow that may sound like a lot

of work so in order to automate that we created this module what it has it

compares side-by-side to guidelines the user guideline we call it user guideline

which means the guideline with custom user modifications and the new standard

guideline and then it understands all the differences and it will prompt you

to either automatically migrate everything which means it knows the

structure it knows that these changes have been made by user so they will take

those changes and migrate over to the new version so really in couple of

clicks you would get this 6020 with all your custom modifications 



data comparator is pretty much the tool which allows you to see side by side to their files see

the differences and if needed move the differences from one file to another kind of similar to Migrator but it solves the problem of comparing of two data files 


data Explorer is a very powerful and new module with the inspect builder which allows you to do a lot with data modification it is very lightweight but yet very powerful to to

edit data to do the identification and a lot lot of other tasks that you can do

with the data 



standard reference this is pretty much the like the reference book for x12

transaction you can pick any version and you will see the all the segments which

are included in this version grouped by control segments and other logical

distribution these are the transactions you can browse this structure you can

see what each segment means and so forth similar ability you would get with

creating the guideline and even more let me show you how that looks



for example let's pick 50 10 guideline get in that line and I'm gonna start

with purchase order so I will create a purchase order so this is the document

editing for the specification we call the specification a guideline physically

this guideline will be stored in the file code in this case spec 1 dot ETS

and as you can see you can very quickly learn a lot about your structure you can

see all the segments all the loops you can expand the loops expand the segments

traverse through the elements you can see what code lists are the elements on

the right side there is a property property step and it gives you all the

information but even just looking at a glance at this guideline you can see in

the columns all the key data that you need for example this is there this is

the decimal decimal point field which has a land from 1 to 6 it has the

relational standard option and it is marked as used this is mandatory must

use type ID and so on so even without looking at the properties pane at the

right you can just traverse your structure and see all the details about

the specification and of course that's not all you can for example exclude

certain segments you do some changes to the segment structure for instance you

may choose to remove certain fields if you do not need those and you can for

example apply the user nodes user nodes are mechanism to communicate

certain information from the guideline creator to somebody who would use that

guideline or that implementation guide in the future for example we can type

something like please perform custom verification vacation of this data using

the state database information information for the customer called grade food supplies 


so we can say that now what you can do with that is you can go ahead and print

that out we can just check the print preview to see how that looks

you pretty much have all the segments all the elements you can traverse them

in here this is the summary for the entire transaction it outlines all

segments and all the key information about them including the loops and the

nested living structure after that we publish the segment's one by one giving

all the details about the segment itself about all the fields all the

descriptions the content which is published here is customizable so you

can choose to publish or not to publish certain information if we traverse to

our PR segment then we can see all the IDs in here now what we can do is we can

close that out we can go to document options these section controls the

settings of this document defines what you print how certain things must be

printed so for example I will enable printing the cover page indicating I

want to have all these information to be there I can go to segment and I can enable

printing the user notes let's say we just print the user Note one because we

just have this one user note in here we can click OK


and now if you go to the print preview then we see this cover page and this

cover page is customizable you can add the logo here or customize the overall

look and feel of this page the rest is pretty much as it used to be we can

quickly jump to our PR segment and now you can see that there is a user

node which we created so whenever you print out this document that user node

will be in here and whoever reached the document besides the general standard

information they can also read your custom custom message which you needed

to communicate to them so this is and you may have multiple user nodes

depending on the usage you can choose to define let's say you can reserve the

user node for the general information user no two may stand for some technical

data for example if your developer needs to build some edit you can just type it

here logic goes here you can save and again that can be published this is free

form you can use the rich text like you can make certain things bold or

highlight stuff so whatever is needed in terms of formatting and again all that

will be saved into the document whenever you publish the document so let's

conclude this overview by saving the guideline on disk so we can give it some

name the old custom and we hit save and the file is stored it is ready for later

use thanks for listening to this video and we'll see you shortly


                                         *******The End *******        


Check whether in your location and forecast for 7 days

Smart Weather PWA ๐ŸŒฆ️ Smart Weather PWA ๐Ÿ”” Alerts Search ๐Ÿ“ ...