“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.”
Preqin is the premier provider of data, analytics, and insights for the alternative assets community, including private equity, venture capital, and real estate.
Preqin is headquartered in London, and has offices in seven more international locations: New York, San Francisco, Singapore, Hong Kong, Bangalore, Manila and Guangzhou.
It has on-the-ground research teams in many of these regions, monitoring and gathering data and information on markets worldwide.
Preqin needed to migrate its Microsoft SQL Server and MySQL into a cloud database. After finding the optimal cloud data warehouse in Snowflake, the company searched for a data management tool.
At first, Preqin tried a competing data ingestion tool. However, the competing tool’s pricing was not transparent, and the tool’s change data capture (CDC) mechanism was not compatible with Preqin’s backend. That’s when Preqin turned to Rivery.
A key reason Preqin adopted Rivery was the platform’s pricing model. Rivery does not charge for connectors, users, or platform usage. Rivery charges only for data consumption.
Under this model, Preqin only paid for what it used. The other solutions Preqin researched had opaque or inefficient pricing schemes. Rivey’s pricing model enabled Preqin to cut costs and maximize ROI.
Preqin connected all of its internal and external data sources to Snowflake in a few clicks. Rivery came with 150+ pre-built data connectors out-of-the-box, enabling Preqin to connect data sources with plug-and-play functionality.
Preqin connected its Microsoft SQL Server, MySQL, and Salesforce data to Snowflake without having to spend time building out data pipelines.
Rivery’s fully managed platform also ensured that Preqin never had to perform backend maintenance on pipelines or anything else.
In order to facilitate rapid information exchange with customers, Preqin needed to be able to capture data changes instantly. To do this, Preqin employed Rivery’s change data capture capability.
CDC tracked data changes in the Microsoft SQL Server and MySQL and automatically transferred those changes to Snowflake.
For CDC to work, Preqin required a specific technical component called log streams to facilitate server swaps. Compared to the other solutions Preqin considered, Rivery was the only one with built-in log stream support.
Change data capture ensured that Snowflake was always up to date with the latest data on alternative assets, allowing investors and other stakeholders to react to market fluctuations in real-time.
With Rivery, Preqin overhauled its data infrastructure to improve overall business performance.
By making data ingestion faster and more efficient via CDC, Rivery enabled Preqin and its customers to quickly respond to the alternative assets market with the most insightful data.
Rivery’s pricing model improved cost-effectiveness, and comprehensive plug-and-play connectors made implementation much easier.
But just as critical was the technology partnership between Rivery and Snowflake. Together, the two platforms formed the backbone of Preqin’s data operation.
“The amazing thing about Rivery is that I don’t need to use it. I set it up and it just works, that’s the beauty of it.”
“I like the ability to schedule dependent ETLs in a queue using a simple drag and drop. There's built-in support for nearly every third-party service we are using, and great tech-support.”