Connecting to Salesforce Database

Salesforce is one of the most commonly used Customer Relationship Management (CRM) solutions. It allows businesses to use cloud technology to better connect with partners and potential customers. Astera offers Salesforce database connectivity at both source and destination points.

The connectivity also extends to other objects such as Database Lookup, SQL Statement Lookup in Transformations and SQL Script Task in a workflow.

To learn more about Salesforce and its products, click here.

In this article, we will cover:

1. Connecting to Salesforce in Astera.

2. Data reading options for Salesforce databases.

3. .A use case to see how Salesforce can be configured for use in Astera.

Use Case

To connect to a Salesforce database, we’ll be using the Database Table Source object.

1. To configure the Database Table Source object, right-click on its header and select Properties from the context menu.

As soon as you have selected the Properties option from the context menu, a new window will open.

This is where you can configure a connection with the Salesforce database.

1. The first step is to select the Data Provider. Select Salesforce as your data provider from the drop-down list.

1. Put in the required credentials for your Salesforce account.

   • User

   • Password

   • Security Token

The following options are available:

• Retrieve deleted items - To include items that were previously deleted.

• Connect to sandbox - To create a new connection to Sandbox completely isolated from your actual Salesforce account.

1. Test Connection to make sure that your database connection is successful, and click Next.

1. Once the connection is established, you can Pick Source Table and modify Reading Options for your Salesforce database on the Properties screen.

To read more on different data reading options in a Database Table Source, click here.

You have successfully configured Salesforce as your database provider for your Database Table Source object. The fields from the source object can now be mapped to other objects in a dataflow.

Let’s use the data from the configured Salesforce table in a dataflow.

We have Employee Contact Details data in the table. We need a list of all employees in the Finance department so that they can be listed for an audit.

We will use the Filter transformation to filter out records of Finance Employees.

To know more about how a Filter Transformation works in Astera, click here.

If we preview the output, we can see records of all the Employees working in the Finance Department.

Now, we can write this data to a desired destination in Astera.

In this case, we have written this data to an Excel Workbook Destination.

We have successfully connected to the Salesforce Database table and completed our use case in Astera.