Connect Studio To Redshift Data

How to connect Studio to Redshift Data?

Before connecting, use Redshift data ODBC DSN in UiPath Studio with the following steps:

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