Welcome

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.

100 Comments

Anonymous

hi,

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.

Anonymous

Hi,

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?

Anonymous

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 info@jitterbit.com

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. 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 www.Jitterbit.com.

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.

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.

Anonymous

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?

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.

Anonymous

Hi Team,

I am looking for Attachments Migration for one salesforce to other Instance. I am here in feel Jitterbit could be help me to this attachments migration more easily than traditional Data Loader. May be it is right but I am finding difficult to do this. Usually Attachments needs to CSV files where is CSV file we mention in Body column location of the file to be picked as we have downloaded all the files from Source.

But when I tried Query Attachments for JitterBit I am getting a single with the Encoded content in the Body. Actually I have to change the ParentIds before importing them to the Target Salesforce which I could not able to do as CSV file messed up since it comes in Un understandble format.

Could some guide me please for effective migration of attachments what should i follow in Jitter bit.

Thanks in advance for looking at my case. I am glad If I could any help.

Anonymous

Thanks for the Swift Reply Rakesh. Firstly Its new for me to know we can write scripts in Jitter Bit. By the way Your example looks like in consideration of single attachment. I am sorry In my case I have to Migrate more than 10K files of course not at once..but in incremental way.

Anonymous

Hi Rakesh,

I am sorry may i know where can i write the script. For your information I am Jitter Bit cloud data loader 8.7.4.37 version. Would this has feature to write transformation script, that's great if so may I know please how could navigate to that window.

Anonymous

Hi Rakesh,

Its a bit confusing..where would we get Mapping while exporting I mean Querying in Jitter Bit. And one other thing was your srcipt example works dynamic i mean does take source file name from result of SOQL.

Anonymous

Thanks Rakesk I can see Mapping Editor on Queries as well. Apologies for reply without investigation. Its puzzling really how could i write dynamic transformation script to take attachments and import to other salesforce instance.

Anonymous

Hi Rakesh,

Thanks for the active support. I am becoming favourite to this tool. Looks I could very easily migrate the attachments. As you suggested I did import where I have not got any physical copies to my Local directoy but csv file has got path of the Attachment in Body Column.

Anonymous

Anonymous

I've almost got SQL Server set up correctly. The connection is successful and when I execute an operation that uses it in Harmony all is well. But in Jitterbit Studio I get this error when I try to load sample source data:

Please create another global variable like ($FileName) in a script in the operation before transformation or before source and set the value of that variable using CVTDate function as per the required date format. And then use that global variable in the target file name like [FileName].zip

Use the similar approach as above to resolve the issue. Else we might need to look at the operation. So please send a mail to support@jitterbit.com with questions.

Anonymous

When using the Diff functions is there a way to include records that failed last time we ran the job without resetting the Diff and reprocessing all records?

For example, I just ran a upsert to Salesforce that successfully processed 3000+ records, but had 3 failures. I'd like to run the job again for just the three that failed, but when I re-run the process it says that there are no changes in the Diff so there is nothing to do.

Are failed attempts still logged in the Diff, and therefore not able to be re-run without a change to them in the source?

Anonymous

The diff functions look at the source and not the target so it doesn't know about the failed records.

To capture the failed records please pull up the operation, Right Click on the Operation, Select Options. you will get the Operations Option window. Here select the Write failure records to option and specify your target.

For future questions on support related items please email to support@jitterbit.com so we can help you more effectively.

Anonymous

i am using JitterBit Cloud data loader to get csv file using FTP (from another system) to the Salesforce and then Insert that data into salesforce...but don't know why the data does not inserting successfully..

GetUTCFormattedDate is a Jitterbit function so it can't be used in SQL statement. So you need to create an global variable in a script before the source and set the date value using the GetUTCFormattedDate function something like:

3)Open the transformation—> Right Click Source Structure --> Choose Edit Source Structure --> Keep on clicking 'NEXT' button until you see SQL Where Clause --> In the WHERE clause write column A >= '[DateFilter{2016-01-01 09:09:09}]' OR column B >= '[DateFilter{2016-01-01 09:09:09}]'. In my case column A and column B are Insertdate and Updatedate. Dont worry about the default date that is passed. As said above default value is being using at design time and at run time, actual value will replace it (which will be passed from the script to source). That is it after you done changes deploy the operation and run it you will see the data as expected.

NOTE: This will be helpful mostly for SCD Type -2 logic. Hope this helps. Thanks to Rakesh from jitterbit

Anonymous

I was wondering if anyone knows the easy way to change the operation. I came across the situation where I spend several hours creating one operation and mapping lots of fields from source to destination and later found out that operation needs to be Upsert instead of Update. How can I change one operation to another back and forth without creating new one?

There is no way to convert the upsert operation into update. But you can export / import the mappings you have created in the transformation. Please open the transformation and right click in between source / target and choose Export ---> Export Mappings.

After creating a new update operation, you can import the same mapping.

Anonymous

Hi,

We are using Salesforce WSDL for inserting data from xml file to salesforce instead of Standard salesforce connector. We are getting invalid session id and not able to figure out how can we set call back url and session id? Please assist.

Please add a script in the starting of the operation and call SalesforceLogin function which will set 2 variables session id and server URL in global variables which you need to use in the request part of the web service.

Here is the documentation of this function:

bool SalesforceLogin(string salesforce_org)

Logs in to Salesforce, using the specified Salesforce Org.

After a successful login, the following global data elements have been set and can be used in subsequent scripts or mappings:

$Salesforce.SessionID: The Salesforce session ID.

$Salesforce.ServerURL: The URL to use in subsequent calls to Salesforce in the same session.

$Salesforce.UserID: The ID of the Salesforce user.

Returns true if the login was successful. Returns false if login failed. Call GetLastError() to get the error message.

Please send a mail to support@jitterbit.com for further assistance, so that we can look at the jitterpak or come on a web meeting if required.

Anonymous

Hello,

I am trying to create a variable to use as a counter that will be inserted as a database. I can run my operation once with success but once i try to run it again I get a duplicate value error in my database because the variable reverts back to its original value . How do I update my variable after each successful run of the operation to add 1 to the counter? I have tried inserting a script at the end of the operation to ass 1 to the counter but my code must be incorrect.

Anonymous

Hi. I assume that you're talking about a global variable. The scope of a global variable is within an operation chain, so when your operation chain finishes any global variables that you've set will lose their value. You could use a project variable for this, but project variables will keep their value for a maximum of thirty days if they aren't re-set, so if your operation ever went for that long without running you'd lose the value. If you can create a table in your database and store the counters there that's probably the best solution.

Anonymous

Hi,

Is it possible in Jitterbit to set up a dynamic end - to - end process. e.g. provided with valid end connections, a table name and say a comma separated list of column names, get Jitterbit to pull data out of Salesforce and write it to SQL?

I am not currently a jitterbit user but looking at it as a potential solution provider therefore have no knowledge of how Jitterbit works.

Anonymous

Hi. You can create a Salesforce query type operation in Jitterbit where the data source is Salesforce and the target is a database, but the list of columns that you want to include is fixed when you create or edit the Jitterbit operation. You can't dynamically change the list of columns that are included at run time.

Anonymous

Hi,

I have a requirement where I have to ready a value from the column in csv file and then use this value somewhere in the operation. i.e. header name(Size) will contain a value. I have to use this value and compare it with another source file size (for this I will use Jitterbit standard size forumula). Has anyone worked on it before?

Anonymous

Anonymous

Anonymous

Hello, I have a quick question. I am trying to connect to a sql server database which is located on network server. Do i need to have jitterbit agent installed on my system locally, So that i can only connect to my source. Am i right ??

Anonymous

Anonymous

Hello,

1) I have a issue while connecting to the Target database. I have jitterbit Agent installed on my local machine, there is another jitterbit agent that is installed on the client side too. I am using a Sql server database as a source from my machine. Let me tell you the source sql server database is on another server and the jitterbit agent is on my desktop. However i am able to connect to my source sql server database with instance and tested the connection sucessfully.

Now, i am trying to insert some data into my Target which is also a sql server database that is sitting on my client server. I got all credentials from my client to connect to their database. So, when i entered all the credentials to connect to their Sql server database. I am getting a error as below:

Failed to connect to database. [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (SqlState: IM002).

2) Also, I want to bring this point when i use my clients Jitterbit agent i can connect to their sql server database as a Source. And when i keep the Target database as my sql server on our server under their Agent Group and agent. It gives below error:

This seems to be the Sql Server Database accessibility issue.All the Database connections are being made from the Agent machine.

In Case 1: When you are using your Local agent then Agent is not able to access the Client's SQL server database (as Target). It might be inaccessible from your agent machine.

In Case 2: When using Client Agent, then that agent is not able to access your SQL Server Database. That's why you keep getting the error: " Error Locating Server/Instance Specified [xFFFFFFFF]. (SqlState: 08001)."

So it seems that your local agent & your Sql Server database are on one network and Client Agent & their SQL Server Database is on another Network and there might be no proper connectivity between these networks. You can try to ping the client's SQL Server Database from your Agent machine to verify (or vice versa).

Anonymous

@Rakesh Aggrawal... Thank You very much for your expertise help.

So, another quick question if i want to connect to my client sql server do they need to open any port over their firewall and allow jitterbit agent on my machine to connect to their sql server database and vice versa ... I already sent an email to jitterbit support though.. just want to get some more info for our notes..

Anonymous

Anonymous

You will only be able to set this if your target allows for the date to be of that format. If you are pushing to a target that has date as a datatype then you will not be able to do that. Only option would be to NULL out the field.

Anonymous

Anonymous

A jitterpak is a backup of the operation as it exists on your local system and is relatively easily passable from computer to computer, whereas downloading a project pulls the active project from the agent and overwrites your local copy of it.

Anonymous

Hi,

It is possible to configure path for success and error files to ftp servers when processes are running in local agents and not in cloud. My agent is running on UNIX servers and we don't want to store success and error logs there. If yes, then how?

Please right on the operation and go to Options. There is a section to Write the Success / Failure files to any other location. This configuration can be done if your source is a database or ASCII files.

If all of the your source and target are on cloud like Salesforce, FTP etc then you don't need to install the local agent. In that case, you can use the Jitterbit Cloud Agent.

But in case, if your source (like database, local file share etc) is installed on your office network and can't accessed from outside then you need to install the local agent. If you can open the port of these machines (database or file share) then you can work with Cloud agent.

If you have any specific database where you need to have specific driver which is not listed as default in the Driver list (in studio) then you have to install the Local agent and install the same driver on that machine.

Then it will appear on the studio. But you have to use Local agent (not the Jitterbit cloud agent group). You will not be able to install any driver if using Jitterbit Cloud Agent Group.