Stack Overflow
Stack Overflow

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
16
votes
1 answer

Jitterbit project + Git + Continuous integration

In our project we are using Jitterbit as a proxy between two systems - our Salesforce application and one third party service (we are using web services integration), and Jitterbit-part of our solution contains some business-logic (it's runned on a…
Hleb
  • 7,037
  • 12
  • 58
  • 117
9
votes
3 answers

I am receiving the error "Bind variables only allowed in Apex Code [MALFORMED QUERY]" when testing a SOQL statement called from Jitterbit

We are using Jitterbit to query records from Salesforce, but we are running into an issue. In the query condition statement I am comparing two fields from the Salesforce table. When I go to test the query, it gives me the error "Bind variables only…
NickFranco
  • 91
  • 1
  • 1
  • 2
7
votes
4 answers

Jitterbit vs. BizTalk

Is there anyone who has used or looked into using Jitterbit as well as BizTalk? If so, what are some pros and cons of each, and which one did you go with as your final solution? Specifically, I'm looking for SAP integration, but any input would be…
bju1046
  • 410
  • 5
  • 9
4
votes
0 answers

Source Code Control / Diff Tool for Jitterbit

I've been looking for a way to use git/github for source code control for our Jitterbit (JB) projects. Our current solution is for one dev to manually type out and explain the changes they've made in a README file within the JB project noting what…
TerryK
  • 53
  • 7
4
votes
3 answers

Creating XML Schema for elements with the same name?

I am trying to create an XSD Schema for an XML document I have received however there are two elements staff which have the same name. Is there any way to create a schema for this XML even though there are two elements with the same…
Andrew Hoban
  • 43
  • 1
  • 4
3
votes
1 answer

Jitterbit - "ORA-12504, TNS:listener was not given the SID in CONNECT_DATA"

Issue: We're attempting to do upserts to Salesforce from a Lawson (Oracle) database for a client, using Jitterbit. We are using the Oracle [JDBC] driver on the default port. We have the Jitterbit Agent running on Windows Server 2008 on a machine…
Brian Mansfield
  • 370
  • 2
  • 5
  • 18
2
votes
1 answer

Jitterbit: Attachments Issue

I use Jitterbit and I have inserted attachments, but they are not showing correct data, showing some junk data when viewing the file after insert. I used Base64Encodefile("C:\Users\myPC\Desktop\Jitterbit data\Button Code") option. But the attachment…
user5476252
2
votes
1 answer

What are the different ways to debug integration projects developed using BizTalk, Jitterbit, Websphere message broker etc?

I want to know which integration product provides the best debugging capabilities? Also what are the ways a person typically uses to debug integration projects in different integration products like BizTalk, jitterbit, Websphere message broker,…
iotaSingh
  • 383
  • 2
  • 11
1
vote
2 answers

Jitterbit: target CSV-file created with only header although "do not create emtpy files" is checked

In Jitterbit Dataloader 10.37 I want to create CSV-files from Salesforce data but only if the query returns data. I checked "do not create empty files" on the target type local file but it is still creating a csv just with the header but with no…
Kerstin Vanselow
  • 11
  • 1
1
vote
1 answer

Jitterbit Cloud Studio Snowflake Query Transformation Error - qName and root name CASE SENSITIVITY

Have been trying to configure Snowflake Connector in Jitterbit Cloud Studio (using Cloud agent). PUT/INSERT data has been progressive. However, got confronted with Startelement() Error when using Snowflake Query to fetch back data into Cloud…
AYLSG
  • 11
  • 1
1
vote
1 answer

Getting error like 'Testing1' is not a valid value for AxdEnum_XMLDocPurpose" in AX 2012 r2

I am completely new to MS AX technology and recently been allocated to support AX connector which is developed based on .net technologies. Just to have small intro about AX connector: 1. This connector is one that acts as a mediator between AX…
rakesh kandurii
  • 11
  • 2
1
vote
1 answer

Snowflake-Jitterbit Connector Error: net.snowflake.client.jdbc.SnowflakeSQLException: No active warehouse selected in the current session

I am receiving the below error while trying to connect to Snowflake via Jitterbit cloud studio: Error Error Code: snowflake07 Stacktrace: Error executing get activity. ,Stack Trace:…
Vatan Yadav
  • 11
  • 2
1
vote
1 answer

Jitterbit - Move multiple files from one location to another

I have source as local file and target as File share. I want to move all files from local file folder to file share folder. Please help me to do this.
user10494007
  • 13
  • 3
1
vote
0 answers

Purchase Order (PO) link to Sales Order (SO) breaks / lost - MYOB Exo Business

I'm using MYOB Exo Business. We have Sales Orders in the system which sync from Salesforce through Jitterbit. Our purchasing team creates a Purchase Order against the Product lines on the SO, which creates a linked PO. However, we have been…
Jackie
  • 11
  • 2
1
vote
1 answer

Jitterbit support Microsoft Message Queue (MSMQ) as a valid source or destination?

Does Jitterbit support Microsoft Message Queue (MSMQ) as a valid source or destination? I need to send a message to a queue have Jitterbit pick it up, process and send to another queue. I would be interested in comments on the viability of this as…
MetalLemon
  • 1,390
  • 11
  • 16
1
2 3 4 5