Questions tagged [jitterbit]

Jitterbit is a suite of data integration products with two main components: Jitterbit Integration Environment and Jitterbit Integration Server. Use this tag for questions about the Integration Environment and Server, including building, testing and deploying Data Transformations, Formulas, Projects, Jitterpaks and Plug-ins.

Jitterbit is a suite of data integration products with two main components: Jitterbit Integration Environment and Jitterbit Integration Server. Use this tag for questions about the Integration Environment and Server, including building, testing and deploying Data Transformations, Formulas, Projects, Jitterpaks and Plug-ins.

Useful links:

66 questions
1
vote
1 answer

Unable to load data from jitterbit to salesforce

We are trying to load data from mysql database to salesforce through Jitterbit(v: 8.16.13.1) on windows 2012 R2 machine. We have created mysql view using Jitterbit cloud data loader to load the view data to salesforce objects. We have UTf8 special…
1
vote
2 answers

Dynamic Url in Jitterbit Http Target

I am wanting to call the following URL in my Jitterbit HTTP target: https://xxx.visualstudio.com/DefaultCollection/_apis/wit/workitems/[vstsId]?api-version=1.0 where [vstsId] is dynamic and should be supplied from a global variable. Is it possible…
Martin R
  • 55
  • 1
  • 7
1
vote
1 answer

Jitterbit local file import failing

I am trying setup a local json file as a source in Jitterbit. I am getting an error saying: EnableLocalFileLocation=true is required in the jitterbit.conf file to test the source. This is setup however and the server has been restarted and I'm still…
Martin R
  • 55
  • 1
  • 7
1
vote
1 answer

Dynamically generate url for HTTP source

I'm trying to call a http endpoint. For that I need to specify a url that uses a query string to filter data. Sample URL: http://example.com?date=2017-10-04T22:18.007Z I need to use the current system time as a value for date query string. I created…
user1176058
  • 642
  • 1
  • 8
  • 21
1
vote
2 answers

How do I attach a file (like curl -F file=@{path/to/file.csv} to a Jitterbit HTTP POST Operation?

How would I go about translating the following curl command to a Jitterbit operation? curl -i -u username:password -X POST -F file=@/path/to/file.csv https://website.com/api/filepost Currently I have my Operation structured as…
Brock Elgart
  • 144
  • 5
1
vote
2 answers

Connecting Jitterbit to Heroku Postgre

I'm trying to connect to Heroku Postgre using Jitterbit Cloud Data Loader. got my connection parameters all setup but unfortunately I run into an error FATAL: no pg_hba.conf entry for host "210.213.78.5", user "u49bh1311s0496", database…
ralph
  • 11
  • 1
1
vote
1 answer

jitterbit-password authentication failed for user "postgres"

Hello I am using Jitterbit integration service to integrate PostgreSQL with salesforce. I have Jitterbit Studio & jitterbit agent installed on my windows 7 machine. Click this link to see screenshot of the error message in my jitterbit Studio I was…
Amit
  • 71
  • 3
  • 15
1
vote
1 answer

Why do we use Integration tools such as jitterbit or informatica when we have Rest API to call different applications?

Why do we use Integration tools such as jitterbit or informatica when we have Rest API to call different applications such as Java based app, SFDC app, any cloud based third party API etc.
1
vote
0 answers

Cancel Jitterbit operation if stored procedure occurs in that operation

I have a script that's initializing my operations and it's calling a stored procedure. What I'd like to have happen is if there's an error produced from that stored procedure, whether it be database specific or not, I want to cancel the operation…
Michael Stone
  • 950
  • 2
  • 14
  • 30
1
vote
1 answer

Jitterbit run operation condition

I'm new to Jitterbit and I'm working in Jitterbit Studio 5.6.0.1. In our deployed project we have 4 consequential operations and the first one is scheduled. What I want to do is to put a condition on the first scheduled operation that it should not…
mascot
  • 173
  • 2
  • 10
1
vote
3 answers

Calling Salesforce REST API within Jitterbit

I am having issues with connecting Jitterbit to Salesforce exposed REST API. Generally, i would like to know if anyone has had successful experience doing the above, and if so, do you have and guidance / documentation ? Hugely appreciated.…
1
vote
1 answer

Jitterbit4 vs Jitterbit 5+ vs Talend vs Other ETL tools

Whilst I find Jitterbit 4 a fairly powerful tool, I guess that my company and I have kinda maxed out the capabilities of v4 of the thing, or so it seems. I am trying to keep some now business critical processes alive, and finding that I'm swimming…
LawrenceA
  • 15
  • 4
1
vote
1 answer

What is the default password Jitterbit?

For some time I try to use Jitterbit, but do not have a password, someone could inform me. I need it to log in Jitterbit Server. Thank you
1
vote
0 answers

Jitterbit upserting large csv tab-delimited file

I have a problem with upserting csv file data using jitterbit, into a salesforce instance. I am going to provide as much information as I can here, but if there is anything else the experts would like to know, please ask me to provide. I am not…
1
vote
1 answer

JItterBit HTTP Endpoint

I am working to set up a HTTP Endpoint in JitterBit, for this end point we have a system that will call this Endpoint and pass parameters through the URL to it. example... http://[server]:[server port]/EndPoint?Id={SalesForecID}&Status={updated…
Travis
  • 2,185
  • 7
  • 27
  • 42