Jitterbit: Export & Importing Field Mapping

Field mapping is important in data migration because it is used to define which field in the spreadhseet should map with which field in Salesforce. It is easy to map a field in Jitterbit, but how can we save time from re-mapping the same object with the same fields and use a one-time off field…

Read More

Jitterbit: Field Verification

Before loading data using Jitterbit, we will have to go through a process of mapping spreadsheet fields to fields in Salesforce, Jitterbit will do validation on each of the mapped fields.   After mapping, Jitterbit will use colour to differentiate the result of the validation. Green: Mapping is valid Yellow: Jitterbit is not sure if…

Read More

Jitterbit Data Loader: Implementing Sequential Operation via the Scheduling Feature

In an Integration Platform, we can easily create sequential processes by implementing some business logic via a workflow designer or similar feature. With the Jitterbit Data Loader, a similar goal can be achieved by utilizing the built-in scheduling function.   The scheduling function determines the execution time and frequency of an operation. Few things to keep in mind:…

Read More

Jitterbit Salesforce Data Loader: SQL Server with Windows Authentication

In Jitterbit, it allows you to connect to a SQL Server database via JDBC to retrieve the data and load them into Salesforce. The default authentication used in the tool is SQL Server database authentication. However, can you still use the tool if your company only allows you to access the database by using Windows…

Read More