Can we share Delta table data with Salesforce using OData?

[ChristopherQ1]

Hello!

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

Is OData a viable choice?

Thanks.

[Kaniz_Fatma]

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.