cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Administration & Architecture
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Connect to Salesforce

leelee3000
New Contributor III
New Contributor III

Curious if there's a Databricks connector for Salesforce on AWS? 

1 REPLY 1

Wojciech_BUK
Contributor III

There is no "databricks" connector like the on you have in Unity Fedarating e.g. for Snowflake.

You can use partner ecosystem e.g. Fivetran 
https://www.fivetran.com/connectors/salesforce

to integrate Salesforce data to your Lakehouse.

 

You also have spark salesforce library avaliable there:

https://github.com/springml/spark-salesforce

If you import this library, you can do :

spark.
                read.
                format("com.springml.spark.salesforce").
                option("username", "your_salesforce_username").
                option("password", "your_salesforce_password_with_secutiry_token"). //<salesforce login password><security token>
                option("saql", saql)
                option("inferSchema", "true").
                load()
Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.