Introduction

In this article we will delve deeper into Salesforce and ODBC integration, and will learn how to get profiles. 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

   

2. Then simply select the Get Profiles 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:

   Get Profiles

   This Endpoint has no parameters.

   SELECT * FROM Profiles

   

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

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 ODBC data source:

How to Get Profiles

SELECT * FROM Profiles

Get Profiles in ODBC

1. Open your ODBC client application.
2. Just use the SQL query you generated in the previous steps to read data in your client application, e.g.:

   SELECT * FROM Profiles

More actions supported by Salesforce Connector

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

• Get Beta Report
• Get Report
• Test Connection
• Make Generic API Request
• Make Generic API Request (Bulk Write)

More integrations