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