Openprise supports importing data from Amazon Redshift tables into Openprise. To import Redshift tables from Amazon Redshift, you must create an Openprise data source and choose Amazon Redshift as the technology type. The process of creating a data source is detailed on this page. Note that on step 5, you will need to pick the "Amazon Redshift" technology type.
Once you choose the technology type, you will be asked to add account information such that Openprise can communicate and authenticate to Amazon Redshift. You will see a pop-up that looks like the following
Enter the information letting Openprise know the
- username of the user connecting to Amazon Redshift
- password of the user,
- database name where the Redshift table is in,
- schema where the Redshift table is in,
- port number of the Redshift database,
- host name or IP of the Redshift database,
- and whether SSL should be used or not.
Once you enter those details, click on "Test Authentication" to verify that Openprise can reach your Amazon Redshift. Then "Save" the account details before following through the data source creation process. Note that "directory or entity" selection lists the tables that are in the database schema you configured in the account information.
You can now import data from the selected database table in Amazon Redshift. Please note that schema changes in the Amazon Redshift database table may require modifications to the data source configuration to reflect new or removed database attributes.