How to Create a Custom Extension to Connect to Redshift using IAM Authentication

Dear PTC Support,

We are currently developing a custom extension to connect ThingWorx to an Amazon Redshift database. Due to our company’s security policy, we are required to use IAM authentication to access Redshift, which makes it impossible to use the standard JDBC Extension provided by ThingWorx, as it only supports username and password authentication.

We have reviewed the technical article CS293064, which describes how to connect to Redshift using standard JDBC methods. However, this approach does not meet our security requirements, as it relies on static credentials rather than IAM-based authentication.

We would like to develop an extension that can connect to Redshift using IAM authentication and functions similarly to a DBThing, specifically being able to use SQLQuery, SQLCommand, and other typical database interaction services within ThingWorx.

Could you please provide guidance or documentation on:

1. How to properly develop such an extension that supports IAM-based authentication for Redshift.

2. Whether there are existing SDKs or examples for creating custom database connection templates in ThingWorx.

3. Best practices for securely managing IAM credentials or tokens in a ThingWorx environment.

4. Any alternatives or suggestions you might recommend for this requirement.

Thank you for your support!