question Re: Need Help About of Apache NIFI Data Migration Between of Databases in Support Questions

Need Help About of Apache NIFI Data Migration Between of Databases

omeraran — Mon, 17 Jun 2024 13:50:39 GMT

Hello,

I want to migrate data from MsSQL Server to Oracle Database. I added ConnectionPools for both of. I am trying to export data andimport data ,but i cant. Which processor i need to use and how ? I tried to fecth data with ExecuteSQL but it is fetching as Avro. Than i wanted to convert it to json but i didn't. Because i cant configure the ConvertRecord processor.

Re: Need Help About of Apache NIFI Data Migration Between of Databases

cjervis — Mon, 17 Jun 2024 13:57:43 GMT

Welcome to the community @omeraran. I've moved your question in hopes of you finding the answer you are looking for.

Re: Need Help About of Apache NIFI Data Migration Between of Databases

saquibsk — Tue, 18 Jun 2024 18:48:10 GMT

Hello,

You can use the executeSql processor to read the data and if you put the putdatabaserecord processor to insert the data into oracle database. you don't need to convert the records, just define the input processor as avro reader.

Re: Need Help About of Apache NIFI Data Migration Between of Databases

MattWho — Tue, 18 Jun 2024 20:24:05 GMT

@omeraran

If your source is continuously being written to you might consider using the GenerateTableFetch processor --> ExecuteSQLRecord processor (configured to use JsonRecordSetWriter) --> PutDatabaseRecord processor. Working with multi-record FlowFiles by utilizing the record based processor is going to be a more efficient and performant dataflow.

Please help our community thrive. If you found any of the suggestions/solutions provided helped you with solving your issue or answering your question, please take a moment to login and click "Accept as Solution" on one or more of them that helped.

Thank you,
Matt