Copy Data from SQLite to Salesforce Automatically

1. Launch Advanced ETL Processor

• Create a SQLite Connection by selecting the .sqlite file path
• Create a Salesforce Connection using your Salesforce login and security token

2. Create a New Transformation

Right-click a transformation group and choose New to begin your integration process.

3. Configure Reader

• Double-click the reader to open Reader Properties
• Select your SQLite connection
• Choose the table or write a SQL SELECT query to define the dataset

4. Configure Writer

• Double-click the writer to open Writer Properties
• Select your Salesforce connection
• Choose the Salesforce object (e.g., Lead, Account, Contact, Custom Object)
• Specify operation: insert, update, upsert, or delete

5. Map and Transform Fields

• Match SQLite fields to Salesforce fields (e.g., name, email, ID)
• Apply transformations, data formatting, and validation logic if needed

6. Run the Transformation

Click the Run button to execute the transfer. Logs and real-time status indicators will keep you informed of the process.