It's not possible to connect to the underlying MySQL database for a WordPress instance. The resources or permissions are not available to write a cloud function .
Use Teleport as the incremental sync mechanism for the connector. Then open a support ticket and ask that they enable the Maria db JDBC driver for the connector.
Configure a Fivetran webhook connector:
- Configure webhooks to be triggered by WordPress and pushed to the Fivetran endpoint you will have been provided with upon the configuration of the connector
- Export the database tables in a supported file format and utilise a Fivetran file connector to import that data.
- Transform that data in whatever state your data is required to land in in order to provide a view of historic and incremental data.
As an open source community, WordPress offers a number of extensions that facilitate the export of data to a cloud storage bucket (such as Amazon S3).