I'm trying to connect SQL Server Management Studio to Salesforce so I can see tables and columns but unable to connect. Do I need any ADO.net connector or Salesforce plugin for this to work? Do I need to change port number or any other setting? I'm using password+token in the password field. I know Real Force is a recommended way to connect and I'm able to do so but would like to connect it with SQL management studio as well if possible.

enter image description here

enter image description here

  • Salesforce DB is not as MS SQL Database, so I believe you can not achieve that
    – kurunve
    Dec 13 '17 at 14:30

Salesforce does not use SQL Server, so you can't just connect from SQL Server Management Studio. A quick Google search found at least one product that claims to allow you to connect from Management Studio: https://www.devart.com/news/2015/odbc-salesforce.html.

I've also used a product called DBAmp to connect to Salesforce from SQL Server, but I don't think it gives you features like viewing table structure.

To view tables and fields, I'd recommend looking at Schema Builder, part of Salesforce's Setup.

  • Would also recomend using Workbench, you can get pretty much every metadata and schema detail of your org very easily. Dec 13 '17 at 14:55

It is not possible to connect with Salesforce directly. If you are trying to import or export data on hourly or daily basis, you can use ETL tools. If your data set is small, you can use Data Loader from command line.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.