Member since
02-27-2020
16
Posts
2
Kudos Received
3
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
1281 | 04-05-2020 11:16 PM | |
926 | 03-30-2020 03:32 AM | |
640 | 03-25-2020 06:48 PM |
04-05-2020
11:16 PM
1 Kudo
Finally fixed the issue by myself. have changed all the columns to Uppercase and made the Translate Field Names to false.. That works for me.
... View more
04-05-2020
10:16 PM
Anybody has answer for this- I get this issue on PutDatabaseRecord as well. When I check java code of PutDatabaseRecord. I could see below replace with - underscore.
... View more
04-05-2020
03:09 PM
Great and Thanks for detailed answer. I will take a look and apply the logic.
... View more
- Tags:
- ks
04-05-2020
03:08 PM
Thanks for your answer Steven. Yes there are customizations to AttributesToJson and ConvertJsonToSql.
... View more
03-30-2020
10:05 PM
XML->JSON->oracle tables.
My flow Get the JSON file and form a required JSON format(JoltTransform) for 1 table and route to operations - ADD/MODIFY/REMOVE based on JSON file content
for db insert - from routeAttributes ->AttributeToJSON->convertJSONtoSQL ->putSQL
ADD- Insert,MODIFY-Update and REMOVE-Delete from table.
So here for one table - I have three AttributeToJSON and convertJSONtoSQL
... View more
Labels:
- Labels:
-
Apache NiFi
03-30-2020
09:56 PM
XML->JSON->oracle tables. For example: I have 5 tables.
For some reason 3rd table load fails then 1,2,3 tables should be rollback by not sitting in partial state.
My flow Get the JSON file and form a required JSON format(JoltTransform) for 5 tables and route to all 5 tables(doing operations in each table - ADD/MODIFY/REMOVE based on JSON file content)
for db insert - from routeAttributes ->convertJSONtoSQL ->putSQL
ADD- Insert,MODIFY-Update and REMOVE-Delete from table.
... View more
Labels:
- Labels:
-
Apache NiFi
03-30-2020
07:51 PM
Thanks Steven
... View more
03-30-2020
03:32 AM
1 Kudo
I resolved the issue(${sql.args.1.value:toDate("yyyy-MM-dd"):toNumber()}).. But I dont understand why we need toNumber() here. Any body have answer to this ?
... View more
03-29-2020
09:50 PM
I am facing an issue - in PutSQL
I am sending a date value from XML-JSON->oracle table.
EvaluateJSOn ->RouteAttributes->AttributeJson->ConvertJsontoSQL -> UpdateAttrubites->PutSQL is my flow.
But it is failing always with
... View more
Labels:
- Labels:
-
Apache NiFi
03-25-2020
06:48 PM
Thanks @stevenmatison . worked perfectly..
... View more
- Tags:
- nks
03-22-2020
09:08 PM
Eg: Update table table_name emp_name=? where empid=?
But My column name is emp_id
... View more
Labels:
- Labels:
-
Apache NiFi
03-22-2020
05:14 PM
Have you resolved the issue ?
... View more
03-22-2020
04:52 PM
My file:
"ws:Operation": "ADD", "ws:Supervisor_Name": { "ws:PriorValue": "", "content": "Dr. Leah Thaler"
In above example i need to send the content:Dr. Leah Thaler to insert
My file:
"ws:Operation": "MODIFY", "ws:Supervisor_Name": { "ws:PriorValue": "", "content": "Dr. Leah Thal"
In above example i need to send the content:Dr. Leah Thaler to update.
Database is Oracle - the flow: Getfile-> EvaluateJSONPath -> send the data to two tables using AttributesToJSON for flatten JSON -> ConvertJSONSQL to Putsql.
Note: I dont want to write AVRO schema. So we build this flow
... View more
Labels:
- Labels:
-
Apache NiFi
03-11-2020
04:45 PM
Do you got answer for this?? My question is also same
... View more