You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@nifi.apache.org by Samudra Dutta <sa...@ebiw.com> on 2020/07/03 19:54:44 UTC
S3 to Oracle database Table
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*
*samudra@ebiw.com <sa...@ebiw.com>*
*support@ebiw.com <su...@ebiw.com>*
*+91-9051434492*
*About Us | Contact Us*
Re: S3 to Oracle database Table
Posted by Stefan Kok <st...@centilliard.io>.
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*
>
>
>
>
>
> *samudra@ebiw.com <sa...@ebiw.com>*
>
> *support@ebiw.com <su...@ebiw.com>*
>
>
>
>
>
> *+91-9051434492*
>
> *About Us | Contact Us*