cancel
Showing results for 
Search instead for 
Did you mean: 
Community Discussions
cancel
Showing results for 
Search instead for 
Did you mean: 

Can we share Delta table data with Salesforce using OData?

ChristopherQ1
New Contributor

Hello!

I'm seeking recommendations for streaming on-demand data from Databricks Delta tables to Salesforce.

Is OData a viable choice?

Thanks.

1 REPLY 1

Kaniz
Community Manager
Community Manager

Hi @ChristopherQ1

  • OData (Open Data Protocol) is a standard for building and consuming RESTful APIs. It provides a consistent way to expose and consume data over the web.
  • While OData can be used for data integration, it’s essential to evaluate whether it aligns with your specific use case and requirements.
  • Some users in the Databricks community have discussed using OData for this purpose. However, it’s essential to consider factors like performance, scalability, and ease of implementation.
  • Push Model: If you want to push data from Databricks Delta tables to Salesforce, consider writing microbatches directly to Salesforce (if feasible).
  • Pull Model: For a pull-based approach, you might explore using the SQL API of Databricks SQL or a pub/sub tool like Kafka. With Kafka, changes are published, and you can fetch them later.