Salesforce Connector for SAP Crystal Reports How to Get Profiles

Introduction

In this article we will delve deeper into Salesforce and SAP Crystal Reports 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.

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
Then simply select the Get Profiles endpoint (action).
Continue by configuring the Required parameters. You can also set optional parameters too.
Move on by hitting Preview Data button to preview the results.

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

Get Profiles

This Endpoint has no parameters.

SELECT * FROM Profiles

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.

Use these SQL queries in your SAP Crystal Reports data source:

SELECT * FROM Profiles

get_profiles endpoint belongs to Profiles table(s), and can therefore be used via those table(s).

First of all, open SAP Crystal Reports and create the new Crystal Report.
And it will open the new data source selection window. Under ODBC(RDO) double click on the Make New Connection and Select the desired ODBC DSN, in our case we need to select SalesforceDSN which we created in upper section. And Click on Next.

SalesforceDSN
Expand the Connection and under the data select the desired table(s) or view(s) and click Add > button and click on Next.

SalesforceDSN

SalesforceDSN
Add the desired Fields to Display in the Reports. Here we are adding all fields and click on Finish.
That's it and you will be able to load the data in the Report.