We currently use a CloudWorks integration to writeback data to Google BigQuery. This is part of a multiple stage integration, actualising the model, updating dimensions and finally writing back to a BigQuery table.
Due to an issue, I had to build a workaround to the process using ADO and scheduled using Workflow, which works really well. However, ADO currently has no writeback functionality to Google BigQuery, so the final step of the process has to be completed using CloudWorks.
Two questions from this:
- When will Google BigQuery be added as a connector for ADO writeback?
- Can you make it possible to trigger Cloudworks integrations/integration flows from Workflow?
Thanks