How do I list my Salesforce users in SQL Server?
- Use the Salesforce ODBC driver to connect SQL Server to Salesforce.
- Run this query:
SELECT * FROM OPENQUERY(linked_server, 'SELECT * FROM [User]')
Replace
linked_server
with the name of the linked server you created to connect to Salesforce.The
User
table is enclosed with square brackets as "User" is a reserved word in SQL and ODBC.