Hello everyone! I hope you guys are doing well and staying safe.
I am trying to automate loading from PostgreSQL to AWS EC2 (Neo4j server). Most of the cases are 1 for 1 migration usually. However, for my case, I have to go through the data mapping in between or after the loading the data into AWS from PostgreSQL.
So I've thought about loading data from PostgreSQL to possible staging area on AWS(Neo4j server) and do the data mapping and load them using Cypher on Neo4j browser.
- Could you guys please suggest best practice to automate loading from PostgreSQL to EC2(Neo4j) for my case?
- What should I prep/check before I start the process?
- Any suggestion, advice, documents or links would be greatly appreciated.
Thank you for your time in advance.