ServiceNow
ServiceNow provides a service model that defines, structures, and automates various workflows, removing email and spreadsheets from the process to streamline the delivery of services. It replaces manual transactions with a service experience designed for everyone in the enterprise. Built to manage everything as a service, ServiceNow places a service-oriented lens on the activities, tasks, and processes that is part of the day-to-day work life.
ServiceNow enables enterprise service domains to define services, provide an intuitive service experience, deliver service, assure service availability, and analyze critical service metrics. The ServiceNow platform includes the following features:
• Application Development: Build, test and publish applications that can span from a single department to an entire enterprise. Since less or no coding is required, almost anyone can build business applications for every line of business.
• Field Service Management: Makes field service management simple by replacing spreadsheets, email and other management tools with a single system.
• Finance Service Management: Fulfil submitted requests including financial reports, procurement and payroll issues; gain visibility into work requests and trends over time.
• HR Service Management: Create a system of engagement that works in tandem with existing applications for core HR, talent, and workforce management. (Learn how why effective is ServiceNow implementation for HR service Management.)
• IT Service Management: ITSM consolidates and automates service management processes, increase efficiency, lower costs-and devote more time to creating the consumer-like self-service experience that users expect.
• Security Operations: Systematically manage security incidents, prioritize vulnerabilities, visualize the effectiveness of security investments, and adapt to changing conditions.
Prerequisites
• User ID and password to access the ServiceNow application.
• You must have appropriate security permissions for the tables with which the connector will interact. This includes:
• Table that the user configures within the connector.
• Specific system tables that the connector uses to obtain table metadata:
– sys_db_object: Used to collect table-level metadata such as inheritance.
– sys_dictionary: Used to collect field-level metadata including name, alias, length, data type, and so on.
– sys_glide_object: Used to collect information about data types including names, base types, and so on.
• Name of the ServiceNow instance.
• Understand the ServiceNow tables with which you will interact.
• Internet access.
The connector utilizes the ServiceNow Platform's REST Table API in order.
Connector Properties
You can set the following source (S) properties.
Data Types
ServiceNow fields can be one of around 150 defined types, but all of them are derived from a set of scalar types (with the exception of complex fields). The ServiceNow connector exposes all types as one of the following basic types:
• STRING
• FLOAT
• INTEGER
• LONG
• DECIMAL
• DATE
• DATETIME
• TIME
• BOOLEAN
• GUID - Globally Unique Identifier (handled as a 32-bit character string)
• RECORD - Container of fields of the above types or RECORD
Performance Notes
Dynamic queries against multiple ServiceNow system tables are performed to build the source schema for the map during design (when you connect to a chosen table). Since this operation is very expensive and time-consuming, the connector is configured such that the engine provides the source schema to the connector during execution.
Limitations
The connector performs queries to obtain table metadata and cannot handle unexpected fields in query responses. Hence, they are skipped. This occurs occasionally and has very low impact. Typically, it is a system-defined field. The fields that belong to this category were system-defined and did not contain user-relevant data.
Operators
N/A