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

hibye
Giga Contributor

‎09-23-2017 10:21 AM

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

Labels:
0 Helpfuls
  • 2,291 Views
5 REPLIES 5

Atul Kumar2
Giga Guru

‎09-23-2017 10:33 AM

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


0 Helpfuls

Harsh Vardhan
Giga Patron

‎09-24-2017 12:37 AM

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


0 Helpfuls

Pradeep Sharma
ServiceNow Employee
ServiceNow Employee

‎09-24-2017 10:05 AM

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.


0 Helpfuls

tony_barratt
ServiceNow Employee
ServiceNow Employee

‎09-24-2017 09:24 PM

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!






0 Helpfuls