Options
- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
exeutesql to putsql
Labels:
- Labels:
-
Apache NiFi
Explorer
Created on 04-01-2019 02:13 PM - edited 08-17-2019 04:17 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, I'm new to nifi. can anyone help me.
I'm trying to get data from one database and put that in another database.
I'm following the flow GenerateTablefecth -> ExecuteSQL -> Covertrecord -> PutSQL
but at putsql record it fails to execute my insert
1 REPLY 1
Master Guru
Created 04-02-2019 01:29 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You have specified the SQL Statement property but haven't supplied any values. I recommend replacing PutSQL with PutDatabaseRecord with a Statement Type of INSERT, this should do what you are trying to do.
