Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

Introduction

ServiceNow provides service management software as a service. It specializes in IT services management, IT operations management and IT business management.

Company offerings are centered around the creation of a “service model” that corrects the root cause of service issues and enables self-service. ServiceNow's tasks, activities and processes occur as cloud services, overseen as part of a comprehensive managed workflow that supports real-time communication, collaboration and resource sharing. ServiceNow has service management offerings for IT, human resources, security, customer service, software development, facilities, field service, marketing, finance and legal enterprise needs.

Use case(s)

  • Read and replicate all of ServiceNow's data tables (e.g. Contract Management, Product Catalog, Procurement  etc.). This would allow users to extract and load all of their ServiceNow data into specified multi-table or multi-file sink.
  • Retrieve data from one of ServiceNow's data tables, allowing users to transform and enrich the data before potentially joining it with other datasets.

User Storie(s)

  • As a data pipeline developer, I should be able to import all of ServiceNow data tables so that I can analyze ServiceNow data
  • As a data pipeline developer, I should be able to specify ServiceNow table name (e.g. ast_service, proc_po, proc_po_lineitem) for which I can retrieve and transform the data
  • As a data pipeline developer, I should be able to specify Client ID and Client secret that would allow me to extract the table records from ServiceNow
  • As a data pipeline developer, I should be able to see any errors from ServiceNow REST API calls so that I can resolve those issues

Plugin Type

  • Batch Source
  • Batch Sink 
  • Real-time Source
  • Real-time Sink
  • Action
  • Post-Run Action
  • Aggregate
  • Join
  • Spark Model
  • Spark Compute

Configuration

ServiceNow batch source will support two different plugins:

  1. ServiceNow Reporting Plugin - This plugin would get all the ServiceNow's data tables (e.g. Contract ManagementProduct CatalogProcurement  etc.)
  2. ServiceNow Table Plugin - This plugin would get only the data associated with specified entity (e.g. ast_service, proc_po, proc_po_lineitem)

ServiceNow Reporting plugin

This plugin should be used when the user would like to retrieve all of the ServiceNow data tables associated with Leads and Activities entities: 

User Facing NameTypeDescriptionDefault valueNotes
Client IDstringServiceNow Client ID

Client SecretstringServiceNow Client secret

REST API EndpointstringREST API endpoint URL

User namestringServiceNow user name

Passworddrop-downServiceNow password

Start datestringStart date for reports data

End datestringEnd date for reports data


ServiceNow Table plugin

This plugin should be used when the user would like to extract the data associated with a single ServiceNow table (e.g. ast_service)


User Facing NameTypeDescriptionDefault valueNotes
Table NamestringServiceNow table name to fetch
Tables from Contract ManagementProduct CatalogProcurement, Financial Management etc.
Client IDstringServiceNow Client ID

Client SecretstringServiceNow Client secret

REST API EndpointstringREST API endpoint URL

User namestringServiceNow user name

PasswordstringServiceNow password

Start datestringStart date for the report

End datestringEnd date for the report


Design / Implementation Tips

  • None yet

Approach(s)

Properties

Security

Limitation(s)

Future Work

Test Case(s)

  • Test case #1 - TBD
  • Test case #2 - TBD

References

  • No labels