https://community.databricks.com/t5/data-engineering/is-there-a-way-to-get-cdc-data-from-salesforce-to-databricks-can/m-p/19829#M13358 <P>@Prabakar Ammeappin​&nbsp;can you help on this?</P> Tue, 29 Nov 2022 22:17:32 GMT Ruby8376 2022-11-29T22:17:32Z https://community.databricks.com/t5/data-engineering/is-there-a-way-to-get-cdc-data-from-salesforce-to-databricks-can/m-p/19827#M13356 <P>Currently, we have daily batch running to extract data from salesforce into csv file (adls) which is further copied to delta tables for transformation. We are now looking to implement a solution which can extract real-time data changes on salesforce and load it on databricks for further transformations.</P><P>can somebody help with this?? </P><P></P> Tue, 29 Nov 2022 22:15:00 GMT https://community.databricks.com/t5/data-engineering/is-there-a-way-to-get-cdc-data-from-salesforce-to-databricks-can/m-p/19827#M13356 Ruby8376 2022-11-29T22:15:00Z https://community.databricks.com/t5/data-engineering/is-there-a-way-to-get-cdc-data-from-salesforce-to-databricks-can/m-p/19828#M13357 <P>@Werner Stinckens​&nbsp;can you help?</P> Tue, 29 Nov 2022 22:15:42 GMT https://community.databricks.com/t5/data-engineering/is-there-a-way-to-get-cdc-data-from-salesforce-to-databricks-can/m-p/19828#M13357 Ruby8376 2022-11-29T22:15:42Z https://community.databricks.com/t5/data-engineering/is-there-a-way-to-get-cdc-data-from-salesforce-to-databricks-can/m-p/19829#M13358 <P>@Prabakar Ammeappin​&nbsp;can you help on this?</P> Tue, 29 Nov 2022 22:17:32 GMT https://community.databricks.com/t5/data-engineering/is-there-a-way-to-get-cdc-data-from-salesforce-to-databricks-can/m-p/19829#M13358 Ruby8376 2022-11-29T22:17:32Z https://community.databricks.com/t5/data-engineering/is-there-a-way-to-get-cdc-data-from-salesforce-to-databricks-can/m-p/19830#M13359 Hi @Ruby Rubi I don't have an information on this. However let's see if @Werner Stinckens or @Hubert Dudek can answer you. Tue, 29 Nov 2022 23:08:14 GMT https://community.databricks.com/t5/data-engineering/is-there-a-way-to-get-cdc-data-from-salesforce-to-databricks-can/m-p/19830#M13359 Prabakar 2022-11-29T23:08:14Z https://community.databricks.com/t5/data-engineering/is-there-a-way-to-get-cdc-data-from-salesforce-to-databricks-can/m-p/19831#M13360 <P>I never worked on Salesforce myself, but I do know there are several export possibilities.</P><P><A href="https://developer.salesforce.com/docs/atlas.en-us.change_data_capture.meta/change_data_capture/cdc_intro.htm" target="test_blank">https://developer.salesforce.com/docs/atlas.en-us.change_data_capture.meta/change_data_capture/cdc_intro.htm</A></P><P><A href="https://developer.salesforce.com/docs/atlas.en-us.240.0.api_streaming.meta/api_streaming/intro_stream.htm" target="test_blank">https://developer.salesforce.com/docs/atlas.en-us.240.0.api_streaming.meta/api_streaming/intro_stream.htm</A></P><P></P><P>Hard to tell what exactly is an option for your environment.</P> Wed, 30 Nov 2022 06:50:11 GMT https://community.databricks.com/t5/data-engineering/is-there-a-way-to-get-cdc-data-from-salesforce-to-databricks-can/m-p/19831#M13360 -werners- 2022-11-30T06:50:11Z https://community.databricks.com/t5/data-engineering/is-there-a-way-to-get-cdc-data-from-salesforce-to-databricks-can/m-p/19832#M13361 <P>On Azure you can try using SAP CDC connector for Data Factory:</P><P><A href="https://learn.microsoft.com/en-us/azure/data-factory/sap-change-data-capture-introduction-architecture" target="test_blank">https://learn.microsoft.com/en-us/azure/data-factory/sap-change-data-capture-introduction-architecture</A></P> Wed, 30 Nov 2022 07:31:43 GMT https://community.databricks.com/t5/data-engineering/is-there-a-way-to-get-cdc-data-from-salesforce-to-databricks-can/m-p/19832#M13361 daniel_sahal 2022-11-30T07:31:43Z