Blog > Snowflake to Salesforce

Snowflake to Salesforce with OData

Posted by Chris Chandler | October 13, 2021

The Snowflake IPO in 2020 was fascinating for several reasons. It was the largest software IPO in history, and from a relatively young company (started by ex-Oracle engineers, with only 6 years between launch and IPO). But perhaps more interesting is the significant stake ($250M) that Salesforce Ventures acquired during the listing.

Salesforce's Adam Selipsky, during the announcement, said:

“Data is just moving to the center of so many different organizations. We’re moving to the age of data and analytics ubiquity. And at the end of the day it’s all about empowering employees with data to make better decisions faster.”

Salesforce have been quick to boost Snowflake interoperability in their Tableau CRM product (previously Einstein Analytics), so that the large, insight-rich datasets collected in Snowflake can be analysed by end users.

But for Salesforce CRM and Snowflake, it's a different story that still largely rests on middleware and iPaaS tools.

OData is no longer needed in the new cloud era

OData, and its enabling iPaaS products (Mulesoft, Boomi and others), were built for a pre-Snowflake world of operational data silos. As Snowflake becomes the center of gravity, it means the high cost of anything-to-anything integration styles can be avoided altogether.

Data engineers, using the new wave of tools in the Modern Data Stack, build robust and reliable consolidated datasets, and Snowflake becomes the only source.

For Salesforce, you might have previously built integrations using a middleware platform like Informatica or Jitterbit. But now, with Salesforce Connect and Omnata's native Snowflake connector, these datasets are ready to provide immediate operational value.

A better solution: Omnata & Salesforce Connect

Why is it better?
Technically, it's not OData, making it far more flexible and agile.

Omnata's native Salesforce app queries data directly from Snowflake to External Objects. With no middleware between platforms, it has a lower cost and is easier to get security approval. it's the best option for sensitive data like PII or healthcare.

Learn more about Omnata Connect for Salesforce.

Omnata blog

Opinions, technical guides and product news from Omnata - modern data integration.

Blogs from James Weakley, Snowflake Data Super Hero.

Insights about Reverse ETL and operational data integration.

Sign up for genuine updates from time to time - no spam 🙂

Thanks for signing up!

Error sending please try again

Popular Posts

You might also enjoy

Card image cap
Technical guides

Should I use OData for Salesforce integration?

OData comes up when Salesforce users require data from another system on-demand, but, OData has some inherent challenges to be aware of. The new era of cloud data warehouse allows you to deliver the OData vision in a better way.

Posted by James Weakley | July 7, 2021
Card image cap

4 steps in the evolution of integration architectures

Modern warehouses change the paradigm meaning data and IT teams can stop double handling data.

Posted by Chris Chandler | April 8, 2021