Overview

TIBCO ActiveMatrix BusinessWorks™ Plug-in for Amazon Redshift is an add-on product for TIBCO ActiveMatrix BusinessWorks™. It provides the interoperability between TIBCO ActiveMatrix BusinessWorks™ and Amazon Redshift. Amazon Redshift is a cloud data warehouse product which forms part of the larger cloud-computing platform Amazon Web Services. With the TIBCO ActiveMatrix BusinessWorks Plug-in for Amazon Redshift, you can perform bulk data loading and data change polling from Amazon Redshift.

TIBCO ActiveMatrix BusinessWorks™ is a leading integration platform that can integrate a wide variety of technologies and systems within the enterprise and on cloud. TIBCO ActiveMatrix BusinessWorks™ includes an Eclipse-based graphical user interface (GUI) provided by TIBCO Business Studio™ for BusinessWorks™ for design, testing, and deployment. If you are not familiar with ActiveMatrix BusinessWorks™, see the TIBCO ActiveMatrix BusinessWorks™ documentation for more details.

With this plug-in, you can perform operations using the services supported by Amazon Redshift. The plug-in supports the following features:

• Creating and Configuring the Redshift Connection Resource: You can use this feature to connect to the Amazon Redshift data warehouse. Along with the Username/Password and SAML Authentication authentication methods, the plug-in now supports the Container Credentials and Default Credentials Provider Chain authentication methods.

• Amazon Redshift Palette: The palette supports the following activities:

  • Bulk Load Activity: This activity performs data loading from a source relational database or other sources to a target Amazon Redshift. The data can also be loaded to the Amazon Redshift table by staging data files in the Amazon S3 bucket.

  • Data Change Poller Activity: This activity polls for new and updated records in a given source table and copies it to a reference table for future reference. After each polling interval, the changed records are returned as the output.