Re: S3 to Oracle database Table
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*
>
>
>
>
>
> *samu...@ebiw.com *
>
> *supp...@ebiw.com *
>
>
>
>
>
> *+91-9051434492*
>
> *About Us | Contact Us*
Re: How to enable processors after changing a controller service automatically?
Also you may want to have a look at: https://community.cloudera.com/t5/Support-Questions/Start-Controller-Service-via-NiFi-REST-API/td-p/218165 On Wed, 2020-06-10 at 09:40 +0800, l...@china-inv.cn wrote: > Hi, All, > > I'm using NiFi 1.6.0. I need to change a setting of a contoller > service, > NiFi stopped all the processors that reference this service then > disable > the service before I could make changes. > After I made the change and re-enable the service, I found that the > processors were NOT > re-enabled automatically. > > I have to enable these processors manually. Since there are thousands > of > such processors > this operation is very time-consuming. > > Does anyone know how to tell NiFi to start those processors > automatically? > > Thanks > > > > 陆伯鹰 > 中国投资有限责任公司信息技术部 > 电话：+86 (0)10 84096521 > 传真：+86 (0)10 64086851 > 北京市东城区朝阳门北大街1号新保利大厦8层 100010 > 网站：www.china-inv.cn > > > > > > > 本邮件内容包含保密信息。如阁下并非拟发送的收件人，请您不要阅读、保存、对外 > 披露或复制本邮件的任何内容，或者打开本邮件的任何附件。请即回复邮件告知发件 > 人，并立刻将该邮件及其附件从您的电脑系统中全部删除，不胜感激。 > > > This email message may contain confidential and/or privileged > information. > If you are not the intended recipient, please do not read, save, > forward, > disclose or copy the contents of this email or open any file attached > to > this email. We will be grateful if you could advise the sender > immediately > by replying this email, and delete this email and any attachment or > links > to this email completely and immediately from your computer system. > > >
Re: How to enable processors after changing a controller service automatically?
Not sure if you tried this: On the "Enable Controller Service " screen there is a dropdown labelled "scope". The default setting is "Service only" click and select "Service and referencing components" then click enable. Hope this helps. Stefan On Wed, 2020-06-10 at 09:40 +0800, l...@china-inv.cn wrote: > Hi, All, > > I'm using NiFi 1.6.0. I need to change a setting of a contoller > service, > NiFi stopped all the processors that reference this service then > disable > the service before I could make changes. > After I made the change and re-enable the service, I found that the > processors were NOT > re-enabled automatically. > > I have to enable these processors manually. Since there are thousands > of > such processors > this operation is very time-consuming. > > Does anyone know how to tell NiFi to start those processors > automatically? > > Thanks > > > > 陆伯鹰 > 中国投资有限责任公司信息技术部 > 电话：+86 (0)10 84096521 > 传真：+86 (0)10 64086851 > 北京市东城区朝阳门北大街1号新保利大厦8层 100010 > 网站：www.china-inv.cn > > > > > > > 本邮件内容包含保密信息。如阁下并非拟发送的收件人，请您不要阅读、保存、对外 > 披露或复制本邮件的任何内容，或者打开本邮件的任何附件。请即回复邮件告知发件 > 人，并立刻将该邮件及其附件从您的电脑系统中全部删除，不胜感激。 > > > This email message may contain confidential and/or privileged > information. > If you are not the intended recipient, please do not read, save, > forward, > disclose or copy the contents of this email or open any file attached > to > this email. We will be grateful if you could advise the sender > immediately > by replying this email, and delete this email and any attachment or > links > to this email completely and immediately from your computer system. > > >
Jira contributor access
kok
