From the course: ServiceNow: Basic Administration
Join today to access over 24,900 courses taught by industry experts.
Importing data with Import Sets - ServiceNow Tutorial
From the course: ServiceNow: Basic Administration
Importing data with Import Sets
- [Instructor] Ever been handed a spreadsheet and told, "Can you just put this in ServiceNow by tomorrow?" Well, it just happened to me. And here's a set of users that need to be added to our ServiceNow instance right away. So it looks like today, you're going to learn the three-step import set workflow that turns raw CSV data into living records without breaking your CMDB. This file will also be made available for you so that you can follow along as well. An import set is ServiceNow staging area for external data, Excel, XML, JDBC feeds, or FTP Drop will all work here. You'll find it under System Import Sets in the All menu. There's a three-stage model I'd like to introduce you to. I want you to think load, map, and run. First, we load rows into a scratch table. Then we map those rows to a target table with a transform map. And then, finally we run the transform to push clean data into production tables. Let's give it a try. First, we click Load Data and then give our load a name. In…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.