ETL tool for transfering data from MongoDB to PostgreSQL
Project description
Purrito
Purrito is an open source ETL tool which transfers collections from MongoDB to PostgreSQL.
Features
- quick setup
- generate schema based on existing MongoDB collections or use a custom schema
- keep syncing with MongoDB real-time
- update the schema while syncing without stopping anything
- handle connectivity issues
- view collection transfer statistics
Support
MongoDB 3.4
PostgreSQL 9.6
Installation
Check out an example or set things up on your own:
-
install Purrito by typing
pip install purrito -
start MongoDB as a replica set
-
create a source database in MongoDB and add a collection with a couple of documents
-
create a destination database in Postgres
-
generate a collection map:
purrito -m -mdb mongodb://localhost:27017 -n source_db -
start Purr:
purrito -cf collections.yml -pg postgres://127.0.0.1:5432/destination_db -mdb mongodb://localhost:27017 -n source_db -t
Documentation
For more details about Purrito check out our Documentation.
Contribute
Want to help us and the community with perfecting Purrito? Take a look at our contribution Guidelines and submit a PR.
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
