# Connecting to Salesforce – Legacy Database

Salesforce - Legacy is an acclaimed customer relationship management (CRM) platform used by enterprises across the globe. Astera offers in-built connectivity to Salesforce - Legacy databases at both source and destination points. 

The connectivity also extends to other objects such as *Database Lookup, SQL Statement Lookup* in Transformations, *SQL Script Task* in a Workflow, *Database Diff Processor* and *Slowly Changing Dimensions* in Database Write Strategies.

In this article, we will learn to configure Salesforce - Legacy as a data provider in Astera. We will be using the [*Database Table Source*](https://documentation.astera.com/astera-data-stack-v10/dataflows/sources/database-table-source) object to establish the connection with the Salesforce - Legacy database.

1. To configure the properties of a *Database* source, right-click on the object’s header and select *Properties.*

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FuGUyEaPzGn39wFSauVMy%2Fv.1.png?alt=media\&token=286affd8-d969-422a-9981-5acad26a2bcd)

2. This will open a new *Database Connection* window where you need to provide details to configure a connection with the database.

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FRbkPLg3nLx89V22pR3ZO%2Fv.2.png?alt=media\&token=c6909478-16c6-4dfb-8b9f-d13c896b4ee8)

3. On the *Database Connection* window, select *Salesforce - Legacy* from the from the *Data Providers* drop-down list.

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2F6k4A3OnpBj6zaqK0psjG%2Fs.3.png?alt=media\&token=18f1f28e-f208-4dc5-b3af-3df4bf6dc814)

4. Provide the credentials to your Salesforce - Legacy account.

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FDAAQ2c0J4ywavSViwaNG%2Fs.4.png?alt=media\&token=9c29d613-637a-4514-a1c2-468547bd1710)

There are following options available for Salesforce - Legacy settings:

*Retrieve deleted items* - Includes items that were previously deleted.

*Connect to sandbox* - Creates a new connection to Sandbox completely isolated from your actual Salesforce - Legacy account.

5. *Test Connection* to make sure that your connection has been established with Salesforce - Legacy database. When the connection is established, click *Next*.

![](https://3083465318-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FsR50Wa7EwZGlmPSAMkkf%2Fuploads%2FGfHV9Wtn5tI1mJ7539Qp%2Fs.5.png?alt=media\&token=4c760f9e-5afd-4046-87bb-36490bc6803b)

The connection to Salesforce - Legacy database has been established successfully. You can now pick a table from Salesforce - Legacy database and use the data in your dataflow. To learn more about how to pick a table from a database source and specify other reading options, click [here](https://documentation.astera.com/astera-data-stack-v10/dataflows/sources/database-table-source).

This concludes connecting to Salesforce - Legacy database in Astera.