https://community.cloudera.com/t5/Support-Questions/insert-splitted-records-in-database-using-apache-nifi/m-p/346626#M234947 <P>I want to insert splitted records from splitjson processor in database table using nifi.</P><P>For eg: Below is splitjson processor output. I want to push all the flow files in database table having same fragment.identifier.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sahil0915_0-1656614373096.png" style="width: 551px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/34726iD3EC6106E40A3A85/image-dimensions/551x162?v=v2" width="551" height="162" role="button" title="sahil0915_0-1656614373096.png" alt="sahil0915_0-1656614373096.png" /></span></P><P>table columns are mentioned below:</P><P>identity_id|json|person_ref</P><P>where identity_id should be auto sequence number&nbsp;</P><P>json would&nbsp; flow-file content</P><P>person_ref is the foreign key having int data type</P><P>so&nbsp; table will have 13 entries and identity_id column will be unique numbers in sequence, json column will have different flow file contents and person_ref column should be same for all 13 entries lets say 111.</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Thu, 30 Jun 2022 18:46:39 GMT sahil0915 2022-06-30T18:46:39Z https://community.cloudera.com/t5/Support-Questions/insert-splitted-records-in-database-using-apache-nifi/m-p/346626#M234947 <P>I want to insert splitted records from splitjson processor in database table using nifi.</P><P>For eg: Below is splitjson processor output. I want to push all the flow files in database table having same fragment.identifier.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="sahil0915_0-1656614373096.png" style="width: 551px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/34726iD3EC6106E40A3A85/image-dimensions/551x162?v=v2" width="551" height="162" role="button" title="sahil0915_0-1656614373096.png" alt="sahil0915_0-1656614373096.png" /></span></P><P>table columns are mentioned below:</P><P>identity_id|json|person_ref</P><P>where identity_id should be auto sequence number&nbsp;</P><P>json would&nbsp; flow-file content</P><P>person_ref is the foreign key having int data type</P><P>so&nbsp; table will have 13 entries and identity_id column will be unique numbers in sequence, json column will have different flow file contents and person_ref column should be same for all 13 entries lets say 111.</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Thu, 30 Jun 2022 18:46:39 GMT https://community.cloudera.com/t5/Support-Questions/insert-splitted-records-in-database-using-apache-nifi/m-p/346626#M234947 sahil0915 2022-06-30T18:46:39Z https://community.cloudera.com/t5/Support-Questions/insert-splitted-records-in-database-using-apache-nifi/m-p/346628#M234949 <P>Hi,</P><P>Similar question was asked before. Can you please check this post:</P><P><A href="https://community.cloudera.com/t5/Support-Questions/How-to-load-json-record-to-postgres-as-json-datatype/m-p/345779#M234644" target="_blank">https://community.cloudera.com/t5/Support-Questions/How-to-load-json-record-to-postgres-as-json-datatype/m-p/345779#M234644</A></P><P>&nbsp;</P><P>&nbsp;</P> Thu, 30 Jun 2022 22:14:28 GMT https://community.cloudera.com/t5/Support-Questions/insert-splitted-records-in-database-using-apache-nifi/m-p/346628#M234949 SAMSAL 2022-06-30T22:14:28Z