Skip to main content

Posts

[Short Blog] Testing RDBMS store with WSO2 APIM SI analytic triggers

  This blog post contain steps and instructions on testing RDBMS store with SI analytics. The common problem while testing SI is complexity of calling stream without tooling UI. Here, we used siddhi triggers on the siddhi script it self to trigger RDBMS event process. Download SI product pack from WSO2 Github  https://github.com/wso2/streaming-integrator/releases Download mysql-connector-java-8.0.18 MySQL DB driver and copy it into the `<SI_HOME>/lib` Create database named  production  in MySQL Create table  SweetProductionTable with following SQL: CREATE TABLE SweetProductionTable (name VARCHAR ( 20 ),amount double ( 10 , 2 )); 5. Insert data into the table with following SQL: INSERT INTO SweetProductionTable VALUES ( 'Sugar' , 23.50 ); 3. Create a file Store-rdbms.siddhi and add the following content into the `<SI_HOME>/wso2/server/deployment/siddhi-files/Store-rdbms.siddhi` file. @App :name("Store-rdbms") @App :description( 'Receive events vi...

Create message store and processor with WSO2 EI and ActiveMQ

 In this tutorial, we will show you how to create a message store and processor in WSO2 Enterprise Integrator (EI) using ActiveMQ. Message stores and processors are essential components in EI, and they are used to store and process messages in a reliable and efficient manner. We will go through the process of setting up and configuring ActiveMQ as the message broker and integrating it with WSO2 EI. You will learn how to create a message store and processor in WSO2 EI, how to send and receive messages using these components, and how to troubleshoot common issues. Download Apache ActiveMQ.(I used ActiveMQ 5.15.12) Copy following jars into the <EI_HOME>/lib directory from <ActiveMQ_HOME>/lib activemq-broker-5.15.12.jar activemq-client-5.15.12.jar activemq-kahadb-store-5.15.12.jar geronimo-jms_1.1_spec-1.1.1.jar geronimo-j2ee-management_1.1_spec-1.0.1.jar geronimo-jta_1.1_spec-1.1.1.jar hawtbuf-1.11.jar 3. Add the following listener to the <EI_HOME>/conf/axis2.xml ...

[Short Blog] Setting up WSO2 EI/MI with proxy server

 In this blog, we will dive into the process of configuring WSO2 Enterprise Integrator (EI) to work behind a proxy server. We will discuss the necessary configurations and steps needed to ensure that your WSO2 EI can properly connect to the internet and access external resources while being behind a proxy server. Whether you are looking to secure your WSO2 EI or need to comply with organizational policies, this guide will provide the information you need to successfully set up WSO2 EI with a proxy server. Download  https://squidman.net/squidman/index.html  to start a proxy server Install and open SquidMan on the server computer. Optionally, you can use basic authentication to connect this proxy service. For that, create a user and password with following command(I have given admin as the username and admin as the password): htpasswd -c /usr/local/etc/squid_passwords admin 4. (Do this if you follow step 3) Add the following configuration into the squidman template auth_par...

Managing Configurations to Improve the User Experience of Software Applications

This post intends to share my experience in defining configuration for software products that require a large number of configurations. There are applications such as message brokers, ESBs, POS systems, etc that require multiple configurations to make that product works. At this point, the user may lose in a sea of configurations if the developer does not correctly place those configurations in proper order and if documentation is completed. How could you arrange your configuration such that the user can easily work with it? There could be different things that may become reason, software to become harder to configure. Bad user experience in configuring software means your product loses customer impression. The entry point for your software application most probably maybe doing configuration. If the user thinks configuring is hard at this point, he may give up the whole product. Early days developer used simple config formats such as properties file to configure products. Property file...