Needed to attach my database having metadata info to siddhi tooling ui editor.

11 views
Skip to first unread message

Nilesh Kumar

unread,
Feb 9, 2024, 5:38:09 AM2/9/24
to siddh...@googlegroups.com
Hi,
I wanted to attach my database having metadata info stored, Needed to see the database metadata from Siddhi editor UI. So that I can select the metadata and accordingly I can define my stream and other information. What are the steps to integrate it, is it possible?. if possible please let me know the steps.

Also I am trying an RDBMSIntegration example. But it's not working, not sure it's not pulling the data and joining from it.  

Here I follow all the steps but it's not working as  below but one confusion here like are we talking about the siddhi tooling distribution/bundles folder ? here we have mentioned {Siddhi_Distribution_Home}/bundles. siddhi distribution doesn't have bundles folder as such. 

I tried downloading siddhi tooling distribution and in the bundles folder I copied postgres-jdbc jar file and tried to run by executing tooling.bat by creating database tables and trying to simulate data from UI for tradeStream.


Step mention in siddhi tooling editor -
    1) Ensure that MySQL is installed on your machine
    2) Add the MySQL JDBC driver in as follows:
         a) Download the JDBC driver from: https://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.1.45.tar.gz
         b) Unzip the archive.
         c) Copy mysql-connector-java-5.1.45-bin.jar to {Siddhi_Distribution_Home}/bundles directory.
    2) Create a database named 'fraudDB' in MySQL. This database is referred to with 'jdbc:mysql://localhost:3306/fraudDB' url.
    3) Create a table named 'FraudTable': CREATE TABLE FraudTable (creditCardNo VARCHAR(20));
    4) Insert some values to the table : INSERT INTO FraudTable VALUES ("143-90099-23433");
    5) In the store configuration of this application, replace 'username' and 'password' values with your MySQL credentials
    4) Save this sample




Regards,
Nilesh Kumar
Reply all
Reply to author
Forward
0 new messages