Salesforce Connector for SSAS How to Test Connection

Introduction

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

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 Test Connection 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:

Test Connection

This Endpoint has no parameters.

SELECT * FROM test_connection

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

SELECT * FROM test_connection

Start by right-clicking on Data Source Views and then choosing New Data Source View...:
Select the previously created data source and click Next:
Ignore the Name Matching window and click Next.
Add the tables you will use in your SSAS cube:
For cube dimensions, consider creating a Virtual Table in the Data Gateway's data source. Use the DISTINCT keyword in the SELECT statement to get unique values from the facts table, like this:
```
SELECT DISTINCT Country FROM Customers
```
For demonstration purposes we are using sample tables which may not be available in Salesforce.
Review your data source view and click Finish:
Add the missing table relationships and you're done!