Servicenow

Connector Details

Name	Servicenow
Description	ServiceNow is a leading provider of cloud-based software solutions that enable organizations to digitize and automate their workflows, streamline operations, and enhance productivity. With its powerful platform for IT service management (ITSM), as well as solutions for customer service management (CSM), human resources service delivery (HRSD), and more, ServiceNow helps businesses modernize their processes and deliver exceptional service experiences. By centralizing and automating tasks, ServiceNow enables organizations to improve efficiency, reduce manual effort, and accelerate service delivery across the enterprise. The platform's scalability, flexibility, and robust capabilities make it a preferred choice for organizations looking to transform their business operations, drive innovation, and achieve strategic objectives. ServiceNow's commitment to innovation and customer success has established it as a trusted partner for organizations seeking to navigate the complexities of the digital age and thrive in an increasingly competitive landscape.
Connector Type	Class C

Load Strategies	Full Load, Incremental Load
Metadata Extraction	Supported
Data Acquisition	Supported
Data Publishing	Not Supported
Automated Schema Drift Handling	Not Supported

Connection Parameters	Data Type	Example
Connection Name	String	ServiceNowAPIConnector
URL	String	`https://your-instance.service-now.com/api/`
Username	String	`john.doe@example.com`
Password	String	your-password
Bronze Schema (Optional)	String
Silver Schema (Optional)	String

Servicenow connector has optional values such as Bronze Schema and Silver Schema
Steps to configure Full Extraction and Incremental Extraction
Full Extraction
Configure a full extraction by setting IncludeInLoad = 1 for the desired objects in state.ObjectList.
Incremental Extraction
An incremental extraction uses the sys_updated_on column as the watermark and the sys_id columns as the candidate key. This update statement will configure the objects to extract incrementally.
Ingestion
Empower is designed to ingest ServiceNow data into the delta lake using the standard ingestion process. Configure delta lake ingestion by setting DeltaIngestion = 1 for all objects and fields in state.ObjectList and state.FieldList.

Servicenow connector connection string:

DRIVER={ServiceNow};URL={URL};User={User};PWD={Password};Timeout={0};RTK=RunTimeKey;