Question 1

Which direction does this pairing usually run?

Accepted Answer

Both, but for different reasons. Reading MySQL into Attio is the one most teams set up first, because it puts product and account data from the application database onto the CRM record where the go to market team works. Reading Attio into MySQL is the reporting direction, and suits teams whose internal tools and dashboards already query MySQL rather than a separate analytical store. Each direction is its own sync with its own schedule.

Question 2

How does Polytomic read changes from MySQL?

Accepted Answer

Through binlog change data capture rather than repeatedly scanning tables, which matters when the source table is large and the CRM only needs the rows that moved. Inserts, updates and deletes are streamed from the binlog, and the stream is resistant to database failovers. New columns are picked up as the schema evolves. For the Attio side of the sync, remember that deletes cannot be applied, so a removed source row will not remove the CRM record.

Question 3

How do Attio attributes land in MySQL?

Accepted Answer

Structured attributes arrive in JSON columns when you select the parent attribute, queryable with MySQL's JSON functions. Every compound attribute also generates flat subfields, so a personal name can arrive as separate first name, last name and full name columns and a location as its individual components. For a database serving an internal tool the flat subfields are usually the better choice. Record identifiers arrive as UUID strings rather than integers.

Question 4

What can be written into Attio?

Accepted Answer

Any object your workspace exposes as writable, custom objects included, along with list entries so records can be added to a list. Modes are create, update, and create or update, matched on an attribute you already hold such as an email address or a company domain. Deletes are not supported in either the record or the list membership sense, so this maintains and adds rather than removes.

Connect Attio with MySQL

Connect Attio and MySQL with Polytomic

Change capture on the way in

Compound values as JSON

No Attio IDs to store

Trusted by businesses worldwide

Step-by-step integration guide

Connect Attio in Polytomic

Connect MySQL in Polytomic

Create a sync between Attio and MySQL

Map fields and enable the sync

Frequently asked questions

The sync and ETL platform that does it all

Powerful data sync

Advanced analytics

Enterprise security

Easy setup

Ready to connect Attio with MySQL?