No installation is needed
As you might know, how easy it is to get an app on your smartphone the SKYVVA Data Loader is quite easy to install into a Salesforce organization. It is there in salesforce like a salesforce native application. No need to install separately as software on a machine.
Data transformation using the built-in graphical mapping tool
The Important and key feature is the graphical mapping tool with easy drag-n-drop data mapping which is much smarter and easy to access than the standard Salesforce Data Loader. Importing data is not only pushing raw data as it is from the source file to the Salesforce application object. Most of the time the data is not correct and available in the correct date, currency or amount format. So you need to define mapping rule to transform and convert the raw data into the data format which is required by the apex run time. Thus you can build complex business data transformation and process the raw data correctly in Salesforce.
With formula editor, you can use different built-in formal and function such as a VLOOKUP which is used to link related data or simply search other data based on some condition.
For almost any data transformation as date conversion, string manipulation and decision making and etc. there are standard expression and function available out-of-the-box to use.
In 90 per cent use case, it is possible to solve the data mapping and conversation need using the built-in function. Should for any reason a very complex business requirement is needed where there is no standard function available then you can use a piece of apex code to solve any complex business logic.
Handling complex business object
One of the most annoying things to me when I have to build integration using the Salesforce DataLoader is that I cannot load a dependent and complex hierarchical object in one shot. I have to define different CSV file and load after each other in multiple rounds. This is a big effort and is error-prone. SKYVVA DataLoader allows me to put all data in one file and import in one run. All related parent and child can be easily linked together using foreign key using the external key without having to know the Salesforce Id before.
Condition-based message processing with workflow
You can combine different condition and execute different interface in a chained base on the condition. Thus complex business rule can be implemented to fulfill your need to process the message.
With the monitor app, you can search the message by the different filter. For example search after your import for failed messages.
What to do now with the failed messages which you can easily see with the red color? If the data do not need you can simply cancel it and threw it away. But if for example, only the email format is not correct because in the email address the data is not included the sign ‘@’. In this case with the Salesforce standard Data Loader, you have to identify the error csv file, correct the file and import it again. With the skyvva monitoring tool, you can edit the data, correct it and do are processing. Now the data is posted and you don’t need to re-import them again. This is where it helped me dramatically to save time and eas my life in a situation where the data loading is not working well because the data is so dirty. And believe me, in real production case the most error is happening on data issue e.g. the data is not well cleaned.
Supporting Different Data format
Another paint-point I have and why I was looking for an alternative data loader is that I got for some customer project no csv file. The data are stored in an XML file and in the past, I have to find a tool first to convert the XML into a CSV file. This is not an easy way to do and is a waste of time. Fortunately, the SKYVVA Data Loader provides the capability to support the different file format.
All facts for your overview
As you have seen in this article different features which are missing in the Salesforce standard DataLoader and needed for an enterprise-class data loader have been described briefly. More detail insight you can expect from our next series to deep-dive into the different functionality. To make it easy for you the below table shows all the fact-sheet.
Most of the required functionality you need in your daily work for data migration and import is provided additionally by the SKYVVA Data Loader. Of course, you can straight away use the Salesforce standard Data Loader like before. But what to do if you need complex transformation logic and mapping? What to do in case you need condition-based data import? And what I have love and see that it reduce my effort and time dramatically is the monitor, reprocessing and error handling the functionality of the SKYVVA Data Loader. If you have worked with them you ever want to miss them again.
How to get the App?
Salesforce Integration Cloud Suite Solution
With SKYVVA Data Loader data import as you can do with the Salesforce standard Data Loader becomes easy for me with its less effort integration solution you can save your time which results in more productive and accuracy in your development journey. Especially when we are talking about integration its solutions are very useful for any organization working with complex business requirement and integration platform.
Everything is done inside Salesforce and very fast and efficient. This is a true Cloud solution for FREE.