Load Data vs Easy Import - which is better?

[Tadz]

Hi Everyone,

I need your opinions on which is better between Load Data vs Easy Import.

Load Data:

1. Needs to create a staging table (if not in place)
2. Needs to create a transform map (if not in place)

Easy Import:

1. Select Between Insert and Update
2. Can download the excel template
3. Has validation

Base on my comparison, Easy Import is much better.

But I would like to get your opinion on this.

Also on when to use Load Data vs Easy Import

Thanks!

[Alberto Consonn]

Hi,

if you need to import data without changing the transform map, then you can simply use the Easy Import feature, otherwise I would recommend to use Load Data.

In my experience, I've never used Easy Import, I generally find Load Data as best reliable import process in ServiceNow, if you look at the official training course of ServiceNow, in general there is no mention to Easy Import.

So, it's up to which type of data you have to import.

Hope this can help you!

If I have answered your question, please mark my response as correct and/or helpful.

Thank you very much

Cheers
Alberto

[AbhishekGardade · Accepted solution]

Hello Tadz,

Easy Imports Limitations

1 .Only admins can use easy import.

2. With domain separation, imported data will go to global/tab domain.you need to map domain field in template 

3. Sometimes template size can be bigger so it will take much time to load that may cause to halt the ServiceNow for you

Load Data:

1. You can give access to any user to load data based on role

2. You can define coalesce on 1 or many fields. Also you can define colease to any field other than sys_id

3. Import Only column those required.

4. You can have history of which records gets updated, inserted,deleted, skippes etc.

5. Sometimes you need to import reference field data, in that case, you need to find of the sys_id from table and then you need to map to field.

6. You can decide whether to create/ignore reference field/ choice field values.

7. Sometimes you need to set values based on other field values from excel in that case you can use transform scripts and make it more preferable

Please mark as Correct Answer and Helpful, if applicable.
Thanks!
Abhishek Gardade
Hexaware Technologies

[Tadz]

Hi Abishek - can we add data validation for Load Data + Transform map specially on reference fields.

One thing I'm worrying is if you load a reference data which is not existing, it will automatically create a record on the referenced table.

Thanks,

Tadz

[Dubz]

You have the option on the field mapping to select an action, if you choose ignore then it will ignore the mapping if it doesn't find a corresponding record. You can even reject the whole row on the basis of one reference field not mapping properly.