Raspberry Pi 2B doesn't have a inbuilt WLAN interface so I'm using TP-Link Nano WLAN usb adapter to connect to internet. Raspberry Pi OS (Raspbian) does not have a default driver for TP-Link nano, so every time I reset my Pi, it's a little hassle to setup the Wi-Fi. I'm a Linux dummy so every... Continue Reading →
How I Built a Chatbot for IFS with Free and Open Source Tooling…
Love them or hate them, chatbots will be a big part of tomorrow's technology. Chatbots have become extraordinarily popular in recent years and applications in this area is getting wider each day. With the increase of integration capabilities of messaging platforms, rise of AI and the low code chatbot platforms, building a chatbot has been... Continue Reading →
Scheduling a Custom PLSQL Script in IFS
One of the common question we get around IFS tech stuff is How to schedule something in IFS? Well, if the process you need to schedule can be trigger by calling already existing PLSQL procedure, then you are in luck. You can define a new Database Task and schedule the execution of that task. But... Continue Reading →
IFS Authentication flow with OAuth and OpenID Connect
Use of OAuth in IFS and guide to setup Postman to obtain OAuth tokens from IFS Identity Provider
How to Monitor On-Premises Applications with Azure Monitor
Quick walk through to set up Azure Monitor with custom logs to build a DIY monitoring solution for on-premise application
Capturing IFS Aurena requests using Postman
How to use Postman to work with IFS Aurena
How to use DBMS_XMLDOM to create XML from PL SQL
This example shows how to create an Oracle XML object using DBMS_XMLDOM package. It includes XML declaration (Version and Charset)XML namespaceLooping through a cursor to add recursive nodes PART_CATALOG table consists of records in below structure Part_NoDescriptionUOMTEST1test1pcsTEST11Test 1pcsTEST111111VIAL DECLARE L_XMLTYPE XMLTYPE; L_DOMDOC DBMS_XMLDOM.DOMDOCUMENT; L_ROOT_NODE DBMS_XMLDOM.DOMNODE; PARTS_ELEMENT DBMS_XMLDOM.DOMELEMENT; PARTS_NODE DBMS_XMLDOM.DOMNODE; PART_ELEMENT DBMS_XMLDOM.DOMELEMENT; PART_NODE DBMS_XMLDOM.DOMNODE; PART_NO_ELEMENT DBMS_XMLDOM.DOMELEMENT;... Continue Reading →
Build a Personal Assistant bot with Integromat and Chatfuel
The Story behind... I'm a Technical consultant by profession and integrations has been my passion for several years now. It's amazing to see how fast the integration industry is evolving and today, building a complex integration does not need any coding experience and you can connect basically anything if you have the right tools. Integromat... Continue Reading →
Build a RESTful API for IFS with WSO2 and knak.it connector
I have tried several different integration tools like Mulesoft, Azure Service Bus and and some native coding with IFS but nothing worked as good (and free) as WSO2 Enterprise Integrator so far. It's a complete Integration tool kit with tons of features so you can basically integrate IFS with anything with right combination of configuration... Continue Reading →
Execute batch script from Java
Java ProcessBuilder example, Execute OS process from java, Ping Java example