cancel
Showing results for 
Search instead for 
Did you mean: 
Machine Learning
Dive into the world of machine learning on the Databricks platform. Explore discussions on algorithms, model training, deployment, and more. Connect with ML enthusiasts and experts.
cancel
Showing results for 
Search instead for 
Did you mean: 

Salesforce connection with Databricks

NDK_1
New Contributor II

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

6 REPLIES 6

-werners-
Esteemed Contributor III

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
New Contributor II

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

rnavi
New Contributor II

@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
New Contributor II

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

-werners-
Esteemed Contributor III

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_Fatma
Community Manager
Community Manager

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! 😊

Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!