Page tree
Skip to end of metadata
Go to start of metadata



The entire Jitterbit team is dedicated to your success!

We are constantly optimizing your experience with us. Be sure to visit often to browse through our growing library of documentation, guides and articles. Use the navigation links on the left side of this page or click a documentation category below to get started.

Jitterbit customers - If you need to open a support case or check on your case history, visit this link or click the "Submit a Case" button to the left.

Data Loader users - If you are looking for Data Loader support, please visit




  • No labels


  1. Anonymous


       i have used insert option.  and done successfully all process and after run display one message . this message successfully load the data but  i want to display target data in salesforce. how to display target data in salesforce when i have insert data using jitterbit data loader.


    1. Thank you for your comment.  Please submit all Data Loader questions to

  2. Anonymous


    I am constantly receiving emails from some guy in your company (probably sales department). And it's really annoying, so I'd like to unsubscribe from any newsletters etc. and remove my account on Jitterbit. But there's small problem: I don't remember a password. I tried to restore it, but I don't remember answer for secret question. Letter with validation code doesn't contain any instructions what I supposed to do if I don't know secret question's answer (probably you should make it more informative for such difficult cases). 

    Letter says

    If you are still having difficulty, please contact Jitterbit Support.

    But you forget to mention how exactly I should do it. I am not able to contact support because I am not able to login. The question is How I can restore my password? 

    1. We apologize for the inconvenience.  To unsubscribe from any Jitterbit mailing list, please send an email to and include the name of your company and the email address to be removed.  For support on Data Loader, please submit all questions to  To contact support for any other Jitterbit products, please go to for instructions.

  3. Anonymous



    What the volume of traffic that Jetterbit can support? Meaning how many transaction per second? What's the limitation (as there is always one)?



    1. API has specific hit allowances based on the License level selected by the customer.  Normal integration transactions are only limited by the number of servers (agents) the customer is using to process. Transaction volume is linearly scalable. If you have one server you can do x transactions per second, if you have 2 servers you can do 2x transactions per second, etc.  Additionally, Jitterbit utilizes Reliable Messaging architecture allowing one to run higher loads of transactions/spikes through a smaller scaled system at a cost of a slightly slower rate. To discuss your specific high volume use case, call Jitterbit at 1.877.852.3500 or email

  4. Anonymous


    Is there any function in Jitterbit scripts for date difference ?

    i need to check if a date is in the last 5 days range.

    1. Hi,

      For examples of similar scripts, please go to Integration Pattern for Change Data Capture Using Timestamp Based Queries.

      Also, the following might be useful:

      $locks = FileList("<TAG>Sources/Locks</TAG>","locks","*");
      cnt = length($locks); i=0;
       $order = Split($locks[i],".");
       $orderno = $order[0];
       $now = (CVTDate(Now(),"yyyy-mm-dd HH:MM:SS","yyyymmddHHMMSS"));
       //set interval for 5 min, 300 sec;
       If(Double($now)-Double($order[1])>$deletelocktime,$del = true;WriteToOperationLog("order lock file to delete"+$orderno);DeleteFiles("<TAG>Sources/Locks</TAG>",$orderno+"*"),
       WriteToOperationLog("Locks: "+$locks+" below time limit")
      This example will be in a future post in our Design Pattern Library as well.
  5. Anonymous

    I have a CSV file in which the comma separated values are between the quotes (Ex: "NAME","","NUMBER","PHONE","FAX","ADDRESS"). When I try to use the BULK PROCESS in the jitterbit dataloader, it is throwing an error. When I tried removing the quotes, the file went through. But, we get files in the similar format everytime. Is there any way we can solve this without manually removing the quotes before the dataload?

    1. We have submitted your Data Loader question to   Please go to and watch for the answer to your question.

      For support on Data Loader, please submit all questions to  To contact support for any other Jitterbit products, please go to for instructions.

  6. Anonymous


    i'm finding it hard to configure the temporary storage for source and target for applying transformations and here are few questions related to that:

    1. How do i find which folder is been referenced in the temp folder of my local machine for the temporary storage in jitterbit?
    2. i'm on a jitterbit harmony trial license. I cant see the administrator console on my jitterbit studio. is it because of the trial license?
    3. is there a way that i could modify the jitterbit.conf ?




    1. 1. By default it is the system temp folder then \jitterbit. It can be overwritten in the Jitterbit config file ( jitterbit.conf). The settings are explained under the [Settings] tag in the config file.  Default install on Windows is  C:\Windows\Temp\jitterbit.

      2. There is no longer an Administrator Console all of the functionality has been moved to the Web Management Console accessed via

      3. You can modify the Jitterbit config file directly. The default install on Windows is C:\Program Files (x86)\Jitterbit Agent\jitterbit.conf

      NOTE: Changing the Jitterbit config or configuration of the temp directory can only be done on a local agent.

  7. Anonymous


    I keep receiving the following error in a newly configured project for web services:

    "Get failed. SSL connect error. Unknown SSL protocol error in connection to".

    I have confirmed the SSL setting ins the Source are correct, what else should I check? 


    1. First, please check these items:
      1. Verify that the private key certificate is valid and has not expired.
      2. You may be trying to connect using a cipher that the site does not support.  To verify, you would have to use tools that are designed to capture this type of information in order to determine what is an acceptable cipher to use.  Also, I believe Jitterbit no longer supports some of the SSL1 ciphers.  
      If these steps do not resolve your issue, please go to Getting Support and follow the instructions to submit a ticket to Support.
  8. Anonymous


    I am trying to use excel as Database and trying Database To Text Option.

    When I click on test connection, It shows success message but when I go further, it shows nothing in Available table list.

    Kindly help me with this.

    I am using 30 days Trial version For Harmony.

  9. Please send an email to outlining the issue you are experiencing with your Trial version of Harmony. The Jitterbit Support Team will help you resolve this issue.

  10. Anonymous

    Well, I was going to register, but I get this error whenI try:

    • Your request cannot be processed at this time. The site administrator has been alerted.
    • The account associated with this portal has no owner

    Now here  is my real issue: I recently upgraded an integration project from 5.6 to Harmony. I have an operation that I can run manually - it runs fine. I have to run it on a schedule though , so I created a schedule and set the schedule on the operation, but it never fires. I tried several setting the schedule at different times, waited, with no effect. The project uses cloud agents. 

    Has anyone else run into this? Is anything that needs to be enabled/configured by Jitterbit on their end?

    Please help.

    Thank you.

    Vladimir Martinov

    1. Thank you for submitting a comment. We have checked with the Jitterbit Support Team and see that your comment has already been resolved.

  11. Anonymous

    I am running a query using Jitterbit that is supposed to return around 2700 rows. The query just sits there without returning. It seems it has hung. The Operation monitor just keeps updating, but the query never returns.

    Please help.

    1. Thank you for your comment. Please go to Getting Support and follow the instructions to submit a ticket to Support.

  12. Anonymous

    Can you help me on this error?

    Failed to connect to database. [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. (SqlState: 08001).

    Studio version:
    Studio platform: Windows 7 - Java 1.8.0_91
    Org: Accenture [ID = 155558]
    Environment: Test [ID = 154058]
    Agent Group: Jitterbit Cloud Agent Group [ID = 1542] [Lowest Agent Version =]
    Project: New Project [GUID = 63a3b418-42f2-45f4-a92d-0d9df2d9866e]
    Timestamp: 2016-08-19 16:48:01.426


    1. We will need additional information in order to help you. Please go to Getting Support and follow the instructions to submit a ticket to Support.  

    2. Customer was using a Jitterbit Cloud Agent, so installed the local agent and then able to connect to his local database.

  13. Anonymous

    I am trying to create some Salesforce Queries using Jitterbit studio.

    The Objects which I plan to use are Case, order, Order Item, Asset.

    But I did not find the cosponsoring objects in JB studio - SF Query builder wizard. 

    1. Anonymous

      If you are looking for object WorkOrder then it will be available in the next version:

      Data Loader v8.13

      Harmony 8.16

      WorkOrder object has been exposed by Salesforce in SFDC API v37 which will be supported in above mentioned Jitterbit version

Write a comment…