To ensure data is formatted correctly, the DataSync agent will map ServiceNow field types to Database field types. Consult the table below to see how ServiceNow field types are mapped for supported databases.

SQL Server

ServiceNow Field TypeDatabase Field Type
address

NVARCHAR

auto_increment

BIGINT

auto_number

NVARCHAR

boolean

BIT

catalog_preview

NVARCHAR

char

NVARCHAR

choice

NVARCHAR

collection

NVARCHAR

color

NVARCHAR

color_display

NVARCHAR

composite_name

NVARCHAR

compressed

NVARCHAR

condition_string

NVARCHAR

conditions

NVARCHAR

counter

NVARCHAR

currency

FLOAT

date

DATE

datetime

DATETIME2

day_of_week

BIGINT

days_of_week

NVARCHAR

decimal

FLOAT

default

NVARCHAR

document_id

NVARCHAR

documentation_fieldNVARCHAR
domain_idNVARCHAR
domain_number

FLOAT

domain_path

NVARCHAR

double

FLOAT

due_date

DATETIME2

email

NVARCHAR

email_script

NVARCHAR

external_names

NVARCHAR

field_list

NVARCHAR

field_name

NVARCHAR

float

FLOAT

glide_action_list

NVARCHAR

glide_date

DATE

glide_date_time

DATETIME2

glide_duration

DATETIME2

glide_encrypted

NVARCHAR

glide_list

NVARCHAR

glide_percise_time

NVARCHAR

glide_time

DATETIME2

glide_var

NVARCHAR

GUIDNVARCHAR
html

NVARCHAR

html_script

NVARCHAR

id

NVARCHAR

image

NVARCHAR

index_name

NVARCHAR

int

NVARCHAR

integer

BIGINT

integer_date

BIGINT

integer_time

BIGINT

internal_type

NVARCHAR

ip_address

NVARCHAR

journal

NVARCHAR

journal_input

NVARCHAR

journal_list

NVARCHAR

long

NVARCHAR

mask_code

NVARCHAR

metric_absolute

FLOAT

metric_counter

FLOAT

metric_derive

FLOAT

metric_gauge

FLOAT

mid_config

NVARCHAR

month_of_yearBIGINT
multi_small

NVARCHAR

multi_two_lines

NVARCHAR

name_values

NVARCHAR

nl_task_init

BIGINT

number

BIGINT

numeric

BIGINT

order_index

BIGINT

password2

NVARCHAR

password

NVARCHAR

percent_complete

FLOAT

phone

NVARCHAR

ph_number

NVARCHAR

phone_number

NVARCHAR

phone_number_e164

NVARCHAR

picklist

NVARCHAR

price

FLOAT

radio

NVARCHAR

reference

NVARCHAR

reference_name

NVARCHAR

related_tags

NVARCHAR

reminder_field_name

NVARCHAR

repeat_count

BIGINT

repeat_type

NVARCHAR

replication_payloads

NVARCHAR

schedule_date_time

DATETIME2

schedule_interval_count

BIGINT

script

NVARCHAR

script_plain

NVARCHAR

short_field_name

NVARCHAR

short_table_name

NVARCHAR

slush_bucket

NVARCHAR

slushbucket

NVARCHAR

source_id

NVARCHAR

source_name

NVARCHAR

source_tableNVARCHAR
string

NVARCHAR

string_boolean

NVARCHAR

sys_class_name

NVARCHAR

sys_domain_increment

FLOAT

sysevent_name

NVARCHAR

sysrule_field_name

NVARCHAR

table_name

NVARCHAR

template_value

NVARCHAR

textarea

NVARCHAR

time

DATETIME2

timer

DATETIME2

translated

NVARCHAR

translated_field

NVARCHAR

translated_html

NVARCHAR

translated_text

NVARCHAR

tree_code

NVARCHAR

tree_path

NVARCHAR

url

NVARCHAR

user_image

NVARCHAR

user_input

NVARCHAR

user_roles

NVARCHAR

varchar

NVARCHAR

variable_conditions

NVARCHAR

variables

NVARCHAR

version

NVARCHAR

video

NVARCHAR

week_of_month

BIGINT

wiki_text

NVARCHAR

wms_job

NVARCHAR

work_flow

NVARCHAR

xml

NVARCHAR

To configure database type sizes, see DataSync Agent CLOB configuration.