Overview
The ServiceNow high performance Glue Connector for AWS Glue simplifies the process of connecting AWS Glue jobs to extract data from ServiceNow. This connector provides comprehensive access to ServiceNow data, facilitating cloud ETL processes for operational reporting, data governance, and more.
Highlights
- Connect to ServiceNow from AWS Glue jobs
- High performance extract data from ServiceNow
- Create Glue workflows using ServiceNow data
Details
Features and programs
Financing for AWS Marketplace purchases
Pricing
- $149.00/month
Vendor refund policy
No refunds
Legal
Vendor terms and conditions
Content disclaimer
Delivery details
ServiceNow Glue Connector
- Amazon ECS
Container image
Containers are lightweight, portable execution environments that wrap server application software in a filesystem that includes everything it needs to run. Container applications run on supported container runtimes and orchestration services, such as Amazon Elastic Container Service (Amazon ECS) or Amazon Elastic Kubernetes Service (Amazon EKS). Both eliminate the need for you to install and operate your own container orchestration software by managing and scheduling containers on a scalable cluster of virtual machines.
Version release notes
Extracts data from ServiceNow.
Additional details
Usage instructions
Please subscribe to the product from AWS Marketplace and Activate the Glue connector from AWS Glue Studio
Use the ServiceNow Glue connector
To use the ServiceNow Glue connector in your Glue ETL job, you need to activate the connector first and set connector options in the job. This part shows what options you can set to the connector and how to use it in your Glue ETL job.
Connector options
You can pass the following options to the connector.
- instanceUrl (required, replace InstanceName) ServiceNow instance url like https://<InstanceName>.service-now.com
- clientId (required) the clientId of OAuth Client App.
- clientSecret (required) the clientSecret of OAuth Client App.
- refreshToken (required) the RefreshToken of OAuth Client App.
- table (required) the Table Name of the ServiceNow.
The recommended approach to setting the connector options
AWS Secrets Manager can be used to store username, password and other sensitive information related to source connection.
The IAM Role you will be using in the Glue Job should contain the following policies
AWS Glue Service - To run the job.
Amazon EC2 Container Registry - To access AWS Container Registry.
Secrets Manager (optional) - If you use AWS Secrets Manager for connection options.
Using the ServiceNow Connector for AWS Glue
Here are the setup steps for configuring the ServiceNow Connector:
- Setup IAM Role for policies and secret AWS Secrets Manager
- Setup ServiceNow connector and a related connection on Glue Studio console.
- Create a job.
- Save and run the job.
Step 1: Setup IAM Role for policies and secret AWS Secrets Manager
Create role and secret:
- IAM Role for policies as described above.
- Optional - Create secret in AWS Secrets Manager for the connector options described above.
Step 2: Setup ServiceNow connector and a related connection on Glue Studio console
To set up the ServiceNow connector and create a connection for your job:
- Subscribe to product and activate the connector using AWS Glue Studio from the top of this instruction page.
- Enter your connection name and choose "Create connection and active connector". You can optionally add a description, "Connection access" and "Network options". If you have created an AWS secret with the connector options you can choose your AWS secret from the dropdown under "Connection access".
Step 3: Create a job
To create a job from your connection which is created in the previous step:
- Choose the connection and "create job".
- Select your created connection figure on the visual canvas.
- Add connection options and enter the necessary information.
- Follow the earlier step (Connector options you need to set) to add the connection options
- Or you can create an AWS secret with the connector options and attach with the connection as stated in the above step 2.1
- Enter the job name, choose IAM Role created in step 1, and other properties in the "Job details" tab, and Choose "Save"
Step 4: Save and run the job
Run the job after filling in all parameters and creating the connector job.
Support
Vendor support
AWS infrastructure support
AWS Support is a one-on-one, fast-response support channel that is staffed 24x7x365 with experienced and technical support engineers. The service helps customers of all sizes and technical abilities to successfully utilize the products and features provided by Amazon Web Services.