How to connect Studio to Redshift Data?
Before connecting, use Redshift data ODBC DSN in UiPath Studio with the following steps:
- From the Start page, click Blank to create a New Project.
- Click Manage Packages then search for and install UiPath.Database.Activities.
- Navigate to the Activities and drop a Flowchart (Workflow -> Flowchart -> Flowchart) onto the process.
- Drop a database Connect activity (App Integration -> Datbase -> Connect) after the Start activity.
- Double-click the Connect activity and configure the Connection.
- Click the Connection Wizard
- Select "Microsoft ODBC Data Source"
- In Connection Properties, select the DSN (CData Redshift Source) and click OK
- To store Connection info, create a variable and bind to Output in the Properties section. Choose DatabaseConnection in Output.