magento-latest.md

title	keywords	permalink	summary	show-in-menus	key	name	display_name	setup-name	singer	repo-url	this-version	hosting-type	driver	certified	frequency	tier	port	db-type	api-type	versions	ssh	ssl	anchor-scheduling	cron-scheduling	extraction-logs	loading-reports	table-selection	column-selection	select-all	select-all-reason	table-level-reset	define-replication-methods	set-default-replication-method	log-based-replication-minimum-version	log-based-replication-master-instance	log-based-replication-read-replica	key-based-incremental-replication	full-table-replication	view-replication	requirements-list	setup-steps
Magento (v1)	magento, database integration, etl magento, magento etl	/integrations/databases/magento	Connect and replicate data from your Magento database using Stitch's Magento integration.	true	magento-integration	magento	Magento	MySQL	true	https://github.com/singer-io/tap-mysql	1	generic	[PyMySQL 0.7.11](https://pymysql.readthedocs.io/en/latest/){:target="new"}	true	30 minutes	Standard	3306	mysql	platform.mysql	n/a	true	false	true	true	true	true	true	true	sometimes	Log-based Incremental Replication must be enabled and set as the default Replication Method to use the Select All feature.	true	true	false	n/a	false	false	true	true	false	item **Permissions in {{ integration.display_name }} that allow you to create/manage users.** This is required to create the Stitch database user.	title anchor content Configure database connection settings connect-settings {% include integrations/templates/configure-connection-settings.html %} title anchor content Create a Stitch database user db-user {% include note.html type="single-line" content="You must have the `CREATE USER` and `GRANT OPTION` privileges to complete this step." %} Next, you'll create a dedicated database user for Stitch. This will ensure Stitch is visible in any logs or audits, and allow you to maintain your privilege hierarchy. {% include integrations/templates/create-database-user-tabs.html %} title anchor content substeps Connect Stitch connect-stitch In this step, you'll complete the setup by entering the database's connection details and defining replication settings in Stitch. {% for substep in step.substeps %} - [Step 3.{{ forloop.index }}: {{ substep.title | flatify }}](#{{ substep.anchor }}) {% endfor %} title anchor content Define the database connection details define-connection-details {% include shared/database-connection-settings.html type="general" %} title anchor content Define the SSH connection details ssh-connection-details {% include shared/database-connection-settings.html type="ssh" %} title anchor content Create a replication schedule create-replication-schedule {% include integrations/shared-setup/replication-frequency.html %} title anchor content Save the integration save-integration {% include shared/database-connection-settings.html type="finish-up" %} title anchor content Select data to replicate sync-data {% include integrations/shared-setup/data-selection/object-selection.html %}

{% assign integration = page %} {% include misc/data-files.html %}