Connecting to Amazon Redshift
1 Navigate to System > Integrations > Databases, then select CREATE CONNECTION on the Global Action Bar.
2 From the Database Integration window, provide a Connection Name. Then from the Database Type options, select ODBC.
3 Provide the Connection String in the following format while making sure that each value following an equal sign corresponds with the Cluster's values:
Driver={Amazon Redshift (x64)}; Server=examplecluster.abc123xyz789.us-west-2.redshift.amazonaws.com; Database=dev; UID=masteruser; PWD=insert_your_master_user_password_here; Port=XXXX
4 Click the PICK OR CREATE ODBC DB TYPE button, then select and PICK the corresponding Connection Flow.
5 Click TEST to ensure that the connection is properly set up, then click OK to save the Integration and exit.
from: https://documentation.decisions.com/v9/docs/connecting-to-amazon-redshift
Howdy, Stranger!
Categories
- 4.2K All Categories
- 68 General
- 11 Training
- 203 Installation / Setup
- 1.1K Flows
- 108 Rules
- 264 Administration
- 212 Portal
- 494 General Q & A
- 702 Forms
- 334 Reports
- 3 Designer Extensions
- 47 Example Flows
- 53 CSS Examples
- 1 Diagram Tile
- 7 Javascript Controls
- 180 Pages
- 5 Process Mining
- New Features
- 181 Datastructures
- 69 Repository
- 222 Integrations
- 28 Multi-Tenant
- 27 SDK
- 81 Modules
- 57 Settings
- 25 Active Directory
- 12 Version 7
- 35 Version 8
- 106 Lunch And Learn Questions