Copy Data from Salesforce to PostgreSQL Automatically

1. Launch Advanced ETL Processor

• Create a Salesforce Connection using login details and API connection settings
• Create a PostgreSQL Connection with the schema, table, and insert mode

2. Create a New Transformation

Right-click a transformation group and select New to build your data workflow.

3. Configure Reader

• Double-click the reader to open Reader Properties
• Select your Salesforce connection
• Choose a table, object, or custom query where the source supports it

4. Configure Writer

• Double-click the writer to open Writer Properties
• Select the PostgreSQL connection
• Choose the destination and write mode, such as append, replace, or truncate

5. Map and Format Fields

• Map Salesforce fields to PostgreSQL columns
• Apply data transformations, conversions, or validation rules if needed

6. Run the Transformation

Click the Run button (Green Arrow). The data will be copied from Salesforce to PostgreSQL with built-in logging and error handling.