Page History
HTML |
---|
<style>
.release-box {
height: 30px;
width: 100px;
padding-top: 8px;
text-align: center;
border-radius: 5px;
font-weight: bold;
background-color: #8efeb3;
border-color: #FCE28A;
}
.release-box:hover {
cursor: hand;
cursor: pointer;
opacity: .9;
}
</style>
<meta name="robots" content="noindex">
<div class="release-box">
<a href="https://docs.perspectium.com/display/krypton" style="text-decoration: none; color: #FFFFFF; display: block;">
Krypton
</a>
</div> |
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
UI Text Box type tip 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
UI Text Box | ||
---|---|---|
| ||
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:
UI Steps | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| |||||||||||||||||||||
|