Task is to create a dataflow in NIFI that takes a Json file, takes relevant fields and splits this Json file into 2 separate Json files. One of the files is then converted to SQL and put into a Mysql table which returns an auto generated ID. That id is then merged with the other Json data and put into another table in Mysql i.e. the data is connected.
Everything is set up in a test server already, with Nifi and Mysql running with test data available.
Processor are also set up so you can see exactly what fields are used and going into to DB tables.