Model data can be imported from one or more ServiceNow tables into Enterprise Studio using a ServiceNow connection.
To be able to import data from ServiceNow you need to have read access to at least the ServiceNow tables sys_db_object, sys_dictionary, and sys_glide, and in addition to that to the tables you want to import from, including referenced tables.
- In the connection view, select the ServiceNow connection, and then click
- A message appears announcing the import. Click OK to start the import.
If you have not previously activated the option to remember your credentials since opening the model package, a window appears first, asking for your credentials for ServiceNow. Enter your credentials and click OK.
If you want Enterprise Studio to remember your credentials the next time, select the Remember my credentials check box.
- If activated, the connection is validated first.
If validation is (partly) successful, or if there is no validation, import from ServiceNow starts. If the import is completed, a message confirming this appears. Click OK to close the message.
If validation fails, a message appears indicating errors have been found in the definition of the connection. Make your choice:
Click Yes to resolve the validation errors and warnings. After that you can start the import again.
Click No if you want to continue the import without resolving the errors. It may result in an incomplete data import, or no import at all.
Click Cancel if you want to cancel the import process.
After the import has finished, the Import from ServiceNow window appears showing a summary of the import in a table.
Table with a summary of an import from ServiceNow
For a more detailed report, you can generate a report of the last import by clicking the connection, and then clicking thecontrol.