Issue

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 .

Resolution

Option 1

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.

Option 2

Configure a Fivetran webhook connector:

1. 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
2. Export the database tables in a supported file format and utilise a Fivetran file connector to import that data.
3. Transform that data in whatever state your data is required to land in in order to provide a view of historic and incremental data.

Considerations

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).