Execute export dump commands and transfer using nifi

1 reply
1610 views
Translate All

I want to execute export command to take the PSQL dump of the database and transfer it using NIFI and the execute the import command at the destination db.
can anyone provide a flow to do so ?

Apache NiFi

joseomjr

Gold ⭐️⭐️

If you download the Postgres JDBC driver's you can leverage any of the SQL processors to query Postgres directly instead of using pgdump.

https://jdbc.postgresql.org/download/

Translate

Sign up

Please use your Cloudera account.

Login to the community

Please use your Cloudera account.