Salesforce connection with Databricks

[NDK_1]

How can we connect with salesforce from databricks without using any third party jar files?

[-werners-]

you could connect to the salesforce database directly using odbc/jdbc, if that is permitted.
But why not using an ETL tool to extract data, and use databricks for the processing?

[NDK_1]

Not able to connect from odbc/jdbc. Now using azure logic apps to extract data from salesforce

[rnavi]

@NDK_1 : are you looking to keep it in sync with your salesforce periodically or two way sync ? Would love to understand the usecase more.

[NDK_1]

I am planning to use it as a two way sync, reading data from salesforce as well as writing data into salesforce

[-werners-]

if you want to write to salesforce, it is probably a good idea to check the requirements.
Many of those huge software packages do not allow direct writes into the database.  So you might need a licensed connector or something.
If you want to keep it in sync, I am leaning towards using an ETL tool.

[Kaniz]

That’s a great tip! Thank you for sharing your knowledge with the community. I’m sure many people will find it helpful. Keep up the good work! 😊