There are various options:
- Use Invantive Cloud and download first to CSV or alike using
curland then import (example on Pre-load data in OData-cache to avoid Power BI timeouts). - Use Invantive Cloud and upload using Azure Data Factory (example in Dutch on Hoe verbind ik Exact Online met Azure Data Factory?)
- Use Invantive Cloud and upload the data into MySQL directly (example on Import Teamleader data in an on-premise SQL Server database through Invantive Cloud)
- Use Invantive Data Hub on-premises and upload the data (example on Copy Exact Online to SQL Server)
- Use Invantive Data Replicator on-premises and replicate the data (example on Replicate Teamleader to SQL Server)
Note that MySQL has no bulk loader; each individual row must be loaded one-by-one, whereas for instance SQL Server, Oracle and PostgreSQL offer bulk loaders for significant higher throughput.
Note that Data Replicator is for use in large enterprise environments with thousands or more of companies.