UPDATED 13:00 EDT / APRIL 10 2019

BIG DATA

Google partners with Fivetran to bring more data to BigQuery

Google LLC teamed up with a little-known company called Fivetran Inc. today to create a new Data Transfer Service for its BigQuery data analytics platform.

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:

dts-salesforce-demo-video

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.

Image: Fivetran/Google

A message from John Furrier, co-founder of SiliconANGLE:

Your vote of support is important to us and it helps us keep the content FREE.

One click below supports our mission to provide free, deep, and relevant content.  

Join our community on YouTube

Join the community that includes more than 15,000 #CubeAlumni experts, including Amazon.com CEO Andy Jassy, Dell Technologies founder and CEO Michael Dell, Intel CEO Pat Gelsinger, and many more luminaries and experts.

“TheCUBE is an important partner to the industry. You guys really are a part of our events and we really appreciate you coming and I know people appreciate the content you create as well” – Andy Jassy

THANK YOU