Google partners with Fivetran to bring more data to BigQuery
BigQuery is actually a data warehouse service that’s used to store and analyze extremely large, read-only datasets. It’s hosted on Google’s cloud infrastructure and accesses data via an application program interface, but up until now it has been tricky for companies to funnel data from third-party sources to the platform.
Google’s new Data Transfer Service is designed to remedy that and make it easier for companies to use BigQuery to analyze data from more than 100 sources, such as Salesforce, Marketo and NetSuite.
Fivetran’s role is to supply the data connectors that enable the smooth and simple transfer of this information. What it does is replicate the data stored in these services, within BigQuery’s data store. Previously, companies needed to build complicated extract, transact and load pipelines in order to access outside data with BigQuery.
“Every company should have access to all their data, in one place, in real time, and Data Transfer Service is the realization of that vision,” George Fraser, Fivetran’s co-founder and chief executive officer, said in a statement. “The era of every company building fragile, error-prone custom ETL pipelines is over.”
Here’s a quick demo of how Fivetran helps enable the Data Transfer Service:
Fivetran’s data connectors enable quite a few possibilities, the company said. Once data has been replicated inside BigQuery, customers can leverage external data science tools such as Looker and Tableau for more in-depth insights. They can also connect to Google services such as BigQueryML and CloudAutoML in order to use that data to train artificial intelligence models.
Google described Fivetran as its “launch partner” for the new Data Transfer Service, so it seems likely that it will team up with alternative data connector providers to expand the service later.
Fivetran’s data connectors are now available on the Google Cloud Platform Marketplace, with the company offering a free 14-day trial before customers commit.
A message from John Furrier, co-founder of SiliconANGLE:
Show your support for our mission by joining our Cube Club and Cube Event Community of experts. Join the community that includes Amazon Web Services and Amazon.com CEO Andy Jassy, Dell Technologies founder and CEO Michael Dell, Intel CEO Pat Gelsinger and many more luminaries and experts.
We really want to hear from you, and we’re looking forward to seeing you at the event and in theCUBE Club.