Hi Samudra
Below is a possible flow to read your json and insert it into an
Oracle table. You also need a schema that looks something like this
to insert your dates into an Oracle as date types:
{ "type": "record", "name": "NiFi_ExecuteSQL_Record",
"namespace": "any.data", "fields": [{ "name":
"rowseq", "type": ["null", "int"] }, { "name":
"last_upd", "type": { "type": "long",
"default": null, "logica
lType": "timestamp-millis" } }, { "name":
"last_upd_by", "type": ["null", "string"] }, {
"name": "db_last_upd", "type": { "type":
"long", "default": null, "logica
lType": "timestamp-millis" } }, { "name":
"end_dt", "type": { "type": "long",
"default": null, "logica
lType": "timestamp-millis" } }, { "name":
"start_dt", "type": { "type": "long",
"default": null, "logica
lType": "timestamp-millis" } },
.... ]}
UpdateRecord:
Converts date string to numbers:
On Fri, 2020-07-03 at 12:54 -0700, Samudra Dutta wrote:
> Hi Team,
>
> With NIFI I want a Flow Process from
> AWS S3 bucket (JSON format) ----> On-premisesFolder location (JSON
> format)
> ------ > Insert Oracle Database Table.
>
> I already Upload on-premises Database to S3 Bucket as JSON file
> format.
> As my request you please look into this matter.
>
>
>
>
>
>
> *Best Regards, *
>
> *Samudra Dutta*
>
> *EBIW Info Analytics Private Limited,*
>
>
>
>
>
>
> *System Administrator*
>
> *Sector V, Kolkata, India*
>
>
>
>
>
> *[email protected] <[email protected]>*
>
> *[email protected] <[email protected]>*
>
>
>
>
>
> *+91-9051434492*
>
> *About Us | Contact Us*
