Does each XML file have a single record? If not, I recommend keeping all the records together (i.e. a JSON array of objects, each with 10 key/value pairs), and in either case, I recommend PutDatabaseRecord to replace ConvertJSONToSQL and PutSQL. It will take your JSON (or even your XML as of NiFi 1.7.0 via the XMLReader added under NIFI-4185) and do all the conversions and SQL generation for you, so you don't need to worry about positional attributes, data types, etc.
... View more