question what is difference b/w service now table and import set table?? in ITSM forum

what is difference b/w service now table and import set table??

hibye — Sat, 23 Sep 2017 17:21:51 GMT

what is difference b/w service now table and import set table??

Re: what is difference b/w service now table and import set table??

Atul Kumar2 — Sat, 23 Sep 2017 17:33:26 GMT

Hi Shabbir,

Servicenow table contains the real data where import set table is staging table which contains data coming from other source and later on it will be moved to the actual table in servicenow like user , group.

Regards,

Atul

Re: what is difference b/w service now table and import set table??

hvrdhn88 — Sun, 24 Sep 2017 07:37:03 GMT

Service now table contains collection of records (flat file) and import set table is same as table with some transformation logic that allows you to import data into your ServiceNow instance. it's also called staging table combined .In import set table source of the import would be either "File" or "Data Source".

Files:

Excel
XML
CSV

Network (supported online data retrieval methods):

HTTP
FTP
JDBC

Please check the link below.

Table Administration - ServiceNow Wiki

Import Sets - ServiceNow Wiki

Re: what is difference b/w service now table and import set table??

Pradeep Sharma — Sun, 24 Sep 2017 17:05:31 GMT

Hello Shabbir,

Import sets are used to import data from third party sources (integration) including spreadsheets, web services, etc. They allow the data to go through staging and transformation phase before ending up in the target table. This is DATA we're talking about. This gives many benefits including enablement of audit & tracking, prevention of bad data coming in and much more.

Reference:

Import Sets - ServiceNow Wiki

You can also use to insert records directly in ServiceNow table but it is not a best practice.

I hope this answers your question.

Re: what is difference b/w service now table and import set table??

tony_barratt — Mon, 25 Sep 2017 04:24:06 GMT

Hi Shabbir,

It seem a number of contributors have responded to your question -"what is difference b/w service now table and import set table?"

I might add some value to mention that The ServiceNow Wiki is no longer being updated and refers to rather old versions on ServiceNow - Fuji for example.

This might not be so important for a general inquiry.

However Jakarta documentation refers to the latest version of ServiceNow, and in some cases has better or addition info.

You could take a look at the Jakarta info on Import sets here:

Import Sets key concepts

For other issues check here:

http://docs.servicenow.com for the latest product documentation.

If the reply was informational, please like, mark as helpful or mark as correct!

Re: what is difference b/w service now table and import set table??

antin_s — Mon, 25 Sep 2017 05:50:36 GMT

Import Set table is like a staging table where the data from external sources (csv, xml..etc) are persisted before they are migrated to other business tables. All the Import Set tables extend sys_import_set_row table which gives the ability for an import set table to keep the track of the migration/tranformation.