I implemented a data integration project for a client. Jitterbit was used specifically to grab data from all over the world and copy it into a staging database. It had some data transformations, but nothing very complex.
- The time to transfer millions of rows from China or South Africa was remarkable, it was very quick.
- We never dropped rows or lost data.
- It was very easy to pick up and learn how to do a simple data transfer.
- Since I was grabbing data from seven identical systems, I would prefer that I could copy and paste an operation and just change the connection. Instead, I had to remap every transformation I made. Still, it was a time saver to be able to copy it.
- I wish the programming of more complex transformations were less code-based and more GUI-based. Without knowing java syntax it made even some simple transformations difficult.
- It was too easy to overwrite other developers code. A merge feature would have come in handy more than once.
- Our time to deploy a new site was greatly reduced. We could build it once and then copy/modify. This was an enormous time save, I could implement 15-20 transformations and operations in just a couple of hours where other tools took multiple days.
- When we switched to Jitterbit, it took me less than 25 hours to convert from our previous tool. It resulted in about 30 Jitterbit transformations.
- CastIron,db moto,ssis
What set Jitterbit apart was the flexibility and the capability to copy existing transformations. Since we were rolling out a world-wide data integration program for an enterprise ERP, it was essential that we could implement once and reuse. We could add error captures really easily and nobody could beat the speed.
It's ease of use is the biggest factor. It's simple to use and quick to teach someone new to use it. The transformations can be tricky as you really must know coding language but for a straight data transfer it's great.
Unless you want to do a lot of coding, it's not ideal for an ETL scenario. But it's very good with transferring large volumes of data quickly with simple transformations.