Background

Bayer is a global pharmaceutical and life sciences company that develops world-leading consumer medicine and biotechnology products for human and veterinary healthcare. In 2019, Bayer employed approximately 104,000 people across the world, and had sales of 52.7 billion dollars.

The Challenge

Before harnessing Rivery, Bayer used a different solution, an all-in-one marketing tool that combined the functions of ETL data integration, data warehouse, and dashboarding in a single solution.

However, the solution was not expansive enough to sustain Bayer’s data strategy and operations. Although the tool came with pre-built data connectors, it did not cover several of Bayer’s data sources, among other integration issues.

Bayer was particularly concerned with the lack of visibility into the ETL process. By employing “black box” ETL methods, this solution did not reveal how or why raw data was converted into its final form.

In order to take operations to the next level, Bayer needed a more granular level of control over its data, along with full transparency. That’s why Bayer combined Rivery with Snowflake and Tableau.

 

The Solution

With Rivery’s pre-built data connectors, Bayer linked its data sources to Snowflake easily, and started pulling data into the cloud data warehouse right away.

Rivery came with 150+ data connectors right out-of-the-box, all connecting to data sources in a few clicks. Rivery could also build custom data connectors, upon Bayer’s request, via the platform’s API on-demand program. With Rivery’s Custom API, Bayer could connect any API data source to Snowlake by simply providing the API details. 

Bayer initially used Rivery to feed social analytics, such as Twitter and Snapchat, into Snowflake. But Bayer quickly expanded both the volume and sources of data managed by Rivery. Within the first few months of adoption, Rivery began to handle all of Bayer’s marketing data. Bayer used Rivery to pull a host of diverse marketing sources, such as Gmail, from s3 buckets and SFTP into Snowflake. 

Data visibility was a core concern of Bayer, and Rivery offered the company a new tier of transparency. Rivery provided the entire response from every endpoint, so Bayer could harness the most granular data.

The Rivery Customer Success Team also worked with Bayer to rebuild certain data formatting from the other solution, but with more detail and more options to customize. This improved the quality of data fed to Snowflake, and this enhanced analytics and insights downstream.      

Rivery’s automation capabilities boosted efficiency throughout Bayer’s data operation. With Logic Rivers, Bayer could automate data ingestion and data transformation within a single workflow. Logic Rivers ingested Bayer’s marketing data into Snowflake, and then executed SQL queries directly inside Snowflake to transform this data.

Snowflake then sent these business-ready inputs to Tableau for insights and visualization. By automating the data orchestration process, Logic Rivers improved speed and consistency across the team, the technologies, and the analysis.

 

The Outcome

After implementing Rivery, Bayer continued to ramp up data usage rapidly.

By the sixth month of adoption, Bayer had increased data usage in Rivery by 30%. Bayer also moved from a monthly package to a yearly package to take advantage of pricing incentives. But Rivery was just one part of the equation.

The partner technology that sealed the deal was Rivery. Together, Rivery, Snowflake, and Tableau anchored Bayer’s data operation.

“Great product - saves us lots of time on ETL's. It helps us to perform our ETL's very quickly, It connects to a lot of API's and saves us hours of coding and updates.”
Shmuel M., BI Developer
“Amazing ETL tool. Rivery's team provides unbelievable service.”
Tal C., Head of Information Systems
“Rivery gives us the confidence to know that any time we need data, wherever it might be on the internet, we are always able to pull it, use it, and make sense of it.”
Tomer C., Director of R&D

Experience Rivery In Action

Control Your Data. Free Your Business.