![]()
Maybe the data was pulled from a Neon database, where they store their phone numbers and area codes in separate fields, and their Date of Birth info is kept in a separate day, month, and year fields. Do you get source files that range from not-quite to nowhere-close-to ready for import? Of course, you do. Transforms: This is the big thriller for the data geek. ![]() For everything but Bulk Load operations, you can also use an Oracle, SQL or MySQL Database as your source and target files. ![]() Jitterbit offers the ability to connect to a file stored on an FTP server or via a File Share. You can specify the operation, the source object, and the target file, and set up a schedule for it to run on, either limited to a date range or forever.įlexibility: You’re not limited to importing data from a CSV file located on your hard drive. Scheduling: Do you want to create a job once and then forget about it? Jitterbit is perfect for that. This could be useful if you have different sandboxes you need to connect to, or if you, like me, have lots of different Salesforce orgs that you regularly log in to. You can also choose an “All or None” option if you want the import to fail if it encounters any error.Ĭonnections: Not only does Jitterbit let you create and save a connection to your Salesforce org, you can set up multiple connections and easily switch between them. Similar to the Data Loader, you can access Success and Failure files after each operation is run. In addition, Jitterbit gives you the ability to refresh your Salesforce meta data while still in the Field Mapping step, which is useful if you spot a field that’s missing from Salesforce and want to add it as a custom. Field mappings are drag and drop, and there is an Automap button. The interface is very intuitive, and the various wizards walk you through the set-up steps for each operation. You can also delete records, and Jitterbit is smart enough to know based on the IDs you specify, which Salesforce object to delete the data from. Exports are done through Queries, where you can select the fields to include and any conditions to limit what’s exported. #Salesforce custom metadata ant migration tool update#You can insert new records, update existing records, and perform upserts (matching to existing records based on an ID, while inserting any that aren’t found). The free Jitterbit Data Loader does all of the core tasks you’d expect from an import tool. #Salesforce custom metadata ant migration tool professional#Jitterbit also provides more advanced integration functionality if you purchase their Professional edition. #Salesforce custom metadata ant migration tool for free#You can download it for free from the Jitterbit site. Like Demand Tools and the Data Loader, Jitterbit is a desktop application. It doesn’t have all of the advanced functionality of Apsona or Demand Tools, but for purely importing data, you’ll be hard pressed to find a better tool. ![]() On the spectrum of ETL (Extract – Transform- Load) tools which I’ve discussed here already, I’d place Jitterbit ahead of the Apex Data Loader and Dataloader.io. ![]() If you’re a data geek like me, that always provides a little thrill. Its features may not change your world, but they’ll allow you to do some neat things when updating or adding information to Salesforce. Jitterbit is another good and free choice you have. Using a data import tool may not be a personally transformative experience, but it should be transformative for your data. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |