Practical Project for the Integration Systems Information course

To begin, run the project developed in C#. The input dataset is stored in the “Files/csv_files” directory. Next, three distinct tasks must be performed, namely:

1. Open the corresponding .ktr project in the Pentaho Data Integration software.
2. Run the "MQTT subscriver"
3. Run node-red and import the settings stored in the .json file.

After performing the tasks described above, the kettle should be started. With this,

1. A file will be generated as a result of converting .json to .xml.
2. If there is a connection to MongoDB, the respective tables resulting from the filters implemented in kettle will be generated.
3. The node-red dashboard will display various relevant information about the dataset used as input in the C# project.

In the node-red dashboard, it is also possible to manually insert a chip. This data is stored directly in the database, in a table containing only the chips inserted by the user.