Back to source plugin
Export from MongoDB Atlas to MySQL
CloudQuery is an open-source data integration platform that allows you to export data from any source to any destination.
The CloudQuery MongoDB Atlas plugin allows you to sync data from MongoDB Atlas to any destination, including MySQL. It takes only minutes to get started.
MongoDB Atlas
v4.0.1
Official
Premium
MongoDB Atlas
The CloudQuery MongoDB Atlas plugin extracts information from your MongoDB Atlas API and loads it into any supported CloudQuery destination
Publisher
cloudquery
Latest version
v4.0.1
Type
Source
Platforms
Date Published
MySQL
v5.2.7
Official
MySQL
This destination plugin lets you sync data from a CloudQuery source to a MySQL database
Table of Contents
MacOS Setup
Step 1. Install CloudQuery
brew install cloudquery/tap/cloudqueryStep 2. Log in to CloudQuery CLI
cloudquery loginStep 3. Configure MongoDB Atlas source plugin
You can find more information about the configuration in the plugin documentation
kind: source
# Common source-plugin configuration
spec:
name: mongodbatlas
path: cloudquery/mongodbatlas
registry: cloudquery
version: "v4.0.1"
tables: ["*"]
destinations: ["v5.2.7"]
# Plugin specific configuration
spec:
api_key: ${MONGODB_ATLAS_PUBLIC_KEY}
api_secret: ${MONGODB_ATLAS_PRIVATE_KEY}
# optional parameters
# base_url: https://cloud.mongodb.comStep 4. Configure MySQL destination plugin
You can find more information about the configuration in the plugin documentation
kind: destination
spec:
name: "mysql"
path: "cloudquery/mysql"
registry: "cloudquery"
version: "v5.2.7"
# Learn more about the configuration options at https://cql.ink/mysql_destination
spec:
connection_string: "user:password@/dbname"
# Optional parameters:
# batch_size: 1000 # 1K entries
# batch_size_bytes: 4194304 # 4 MiBStep 5. Run Sync
cloudquery sync mongodbatlas.yml mysql.yml