Introduction
A Salesforce Query activity queries data from a Salesforce endpoint and is intended to be used as a source to provide data to an operation. After configuring a Salesforce connection, you can configure as many Salesforce activities as you like for each Salesforce connection.
Creating a Salesforce Activity
From the design canvas, open the Connectivity tab of the design component palette:
Next Steps
After configuring a Salesforce Query activity, complete the configuration of the operation by adding and configuring other activities, transformations, or scripts as operation steps. You can also configure an operation's operation settings, which include the ability to chain operations together that are in the same or different workflows.
Creating a Salesforce Query Operation
This page described how to create a Salesforce Query operation using the Jitterbit Connect Salesforce Query Wizard.
Start the Wizard
To start the wizard, click the Salesforce Query button in the Jitterbit Connect Wizard menu, which opens the wizard.
Salesforce Login
If you have already created a Salesforce Org login, connection details will appear in the Query wizard. You may wish to click the Test Salesforce Login button to check the connection.
Select the Salesforce Object
On the Object screen you specify the Salesforce Object that the operation will use.
Build Your Salesforce Query
For a simple query (all references in a single table), use the Simple Query pane on the left and check the Items to be included in your query. As you do so, they will be added to the Query string in the right pane. Using the Filter text entry box, the Select All, and Remove All buttons can help you quickly specify each field.
Define the Target
The target is the destination of the data retrieved from the Salesforce Query. Select one of:
Schedule and Options
Creating or setting a schedule is both optional and can be done at a later time. For more details on scheduling, see Creating a Schedule.
How long does it take to create a Jitterbit report?
The beauty of it all was it only took 5-10 minutes for my developer to create the report.
What is Jitterbit SOQL?
Jitterbit is a wizard-based integration tool that provides a user-friendly interactive drag and drops SOQL (Salesforce.com object query language) query builder interface. All you have to do is find the fields or objects you need from the pre-populated list and pull it over to the query canvas. Jitterbit will do the rest.
Is Jitterbit a good tool?
Jitterbit is not perfect but it is a flexible and powerful tool that can be used by any organization to perform any type of data extraction from many types of applications. Now this article wouldn’t be complete if I didn’t explain how we resolved the issue.
Does deactivating a user increase the number of available user licenses?
I've always simply assumed, "deactivating users will not increase the number of available user licences". A deactivated user doesn't count against your organization’s available user licenses. However, deactivating a user doesn't reduce the number of licenses for which your organization is billed; you must change your organization’s license count ...
Does deactivating a user free a license count against the total available and used license in your organisation?
Deactivating a user free a license for your organisation but it doesn't count against the total available and used license in your organisation. This is the facility of license reusability only, has no concern with billing.
Can you be billed beyond your license?
You won't be billed beyond the available licences, you're just billed for the licences you have. That said, you may not be using all of your licences if you have deactivated some users and not added new users.
