Is possible to automatically transfer the data in EspoCRM to Google BigQuery?

[PaulDigital]

Hello everyone,

I'd like to make some reports using Google Bigquery and Google Data Studio and I was wondering if there was a way to have the data from the CRM to be transferred to Google BigQuery.

[item]

+1

Maybe a extension.. i don't think it's hard.. if i have understand, we need export mysql to json
but we need not only restrict to BigQuery, Amazon, Azure...

joke :
Extension Name : NoEspoSQL:

[jflores]

PaulDigital - We get our data to BigQuery using https://www.fivetran.com/

Their free package works well for us and it was really easy to set up.

We did it using their mysql integration and have pretty fine-grained control over the schema we constructed.

We use dbt models to query and transform the data, which we then feed to Views in Bigquery and get out via Google Data Studio.

So our flow is:

1. Connect to Fivetran
2. Fivetran syncs raw data to Bigquery
3. Use DBT models to query Bigquery data & send back views/models that are preconfigured and optimized for
4. Access appropriate models from Google Data Studio

Hope this helps!