Salesforce Connector for SQL Server How to Test Connection

Introduction

In this article we will delve deeper into Salesforce and SQL Server integration, and will learn how to test connection. We are continuing from where we left off. By this time, you must have installed ODBC PowerPack, created ODBC Data Source, and configured authentication settings in your Salesforce account .

So, let's not waste time and begin.

Use Query Builder to generate SQL query

  1. The first thing you have to do is open Query Builder:

    ZappySys API Driver - Salesforce
    Amazon Ads Connector can be used to get Amazon advertisements using Amazon Advertisements API, download various advertisement-related reports.
    SalesforceDSN
    Open Query Builder in API ODBC Driver to read and write data to REST API

  2. Then simply select the Test Connection endpoint (action).

  3. Continue by configuring the Required parameters. You can also set optional parameters too.

  4. Move on by hitting Preview Data button to preview the results.

  5. If you see the results you need, simply copy the generated query:

    Test Connection
    This Endpoint has no parameters. 
    SELECT * FROM test_connection
    Query Builder

  6. That's it! You can use this query in SQL Server.

Let's not stop here and explore SQL query examples, including how to use them in Stored Procedures and Views (virtual tables) in the next steps.

SQL query examples

Use these SQL queries in your SQL Server data source:

How to Test connection 

SELECT * FROM test_connection

Test Connection in SQL Server

  1. First of all, copy the generated SQL query from the previous step.

  2. Then open Microsoft SQL Server Management Studio.

  3. Finally, open a new query and execute a query we saved in one of the previous steps:

    SELECT * FROM OPENQUERY([LS_TO_SALESFORCE_IN_GATEWAY], 'SELECT * FROM Orders')
    Execute query at Linked Server to ZappySys Data Gateway in SSMS 

    SELECT * FROM OPENQUERY([LS_TO_SALESFORCE_IN_GATEWAY], 'SELECT * FROM Orders')

Download Salesforce Connector for SQL Server Documentation

More actions supported by Salesforce Connector

Learn how to perform other actions directly in SQL Server with these how-to guides:

More integrations

All
Data Integration
Database
BI & Reporting
Productivity
Programming Languages
Automation & Scripting
ODBC applications