Prerequisites
Request the databaseConfig.json file for your meshlet by contacting Perspectium Support.
Database and Schema will not be created by the meshlet and are expected to be supplied on use.
You will need to install the Perspectium Core update set in your ServiceNow instance. You can request a download link for this update set by contacting Perspectium Support.
Have the following information available:
- Amazon Redshift cluster and database JDBC URL
- AWS username and password
Amazon role ARN
DataSync for Redshift uses role-based access control in order to bulk load records from Amazon S3 to Amazon Redshift.
The Redshift cluster must have an IAM role attached in order to access Amazon S3. The role must have permissions to LIST and GET objects from the Amazon S3 bucket being used. The IAM role ARN, or Amazon Resource Name, is a required directive to leverage the COPY command.For more information, see AWS credentials and access permissions.
- AWS S3 Bucket access key, secret key, bucket name and region
The meshlet uses the Amazon Redshift COPY command to bulk load data into Redshift. Temporary files are stored in an Amazon S3 Bucket before the data is pushed into Redshift.
Procedure
To set up a DataSync for Redshift integration, follow these steps:
Create or obtain a queue
A shared queue should have been created by Perspectium Support upon initial configuration of your ServiceNow instance.
Otherwise, follow Create a ServiceNow shared queue to create a queue that points to your Redshift.
Create a ServiceNow bulk/dynamic share for Redshift
In ServiceNow's left side navigation window, navigate to Perspectium > Perspectium Core > Shares or simply type and then click on Shares. Then, go to Bulk Share > Create a new bulk share.
- In the Name field, type any name for your bulk share.
- Click the dropdown next to Table. Then, search for and choose the table whose data you want to bulk share out.
- Click the search icon next to the Target queue field. In the Queues popup, choose the shared queue you created or obtained in the Create or obtain a queue step.
- Choose a method to encrypt the data that will be shared out from the Encryption Method dropdown.
NOTE: You will need to specify the encryption method in the meshlet configuration. Contact Perspectium Support for more information. - In the Data Enrichment tab, click the search icon next to Table map. From the resulting list, select the table map you want to add. See ServiceNow Table Maps for more information.
- Click Submit.
For any additional information on setting up your bulk share, see ServiceNow Bulk Share.
In ServiceNow's left side navigation window, navigate to Perspectium > Perspectium Core > Shares or simply type and then click on Shares. Then, go to Dynamic Share > Create a new dynamic share.
- Select Business Rule or Flow Designer and click the Submit button.
- Check the Active box to activate your dynamic share and start sharing out record data dynamically.
- Click the dropdown next to Table. Then, search for and choose the table whose data you want to dynamic share out.
- Click the search icon next to the Target queue field. In the Queues popup, choose the shared queue you created or obtained in the Create or obtain a queue step.
- Choose a method to encrypt the data that will be shared out from the Encryption Method dropdown. NOTE: You will need to specify the encryption method in the meshlet configuration. Contact Perspectium Support for more information.
- In the Data Enrichment tab, click the search icon next to Table map. From the resulting list, select the table map you want to add. See ServiceNow Table Maps for more information.
- Click Submit.
For any additional information on setting up your dynamic share, see ServiceNow Dynamic Share.
Install and Run the Redshift Meshlet as a Service
Follow the link above to install and run the Redshift meshlet. For additional information on the directives in the meshlet configuration, see Meshlet Configurations for Redshift.