How To Connect Robot To EDH Tableau Data Base?

News Knowledge Base
, ,
1

How to connect Robot to EDH Tableau Data base?

Issue Description: Need guidance to connect BOT to EDH Tableau Data base

Resolution: Steps to connect to the Redshift database:

Configure the Connection to Redshift

First specify connection properties in an ODBC DSN (data source name). This is the last step of the driver installation. Use the Microsoft ODBC Data Source Administrator to create and configure ODBC DSNs.

To connect to Redshift, set the following:

  • Server: Set this to the host name or IP address of the cluster hosting the Database you want to connect to.
  • Port: Set this to the port of the cluster.
  • Database: Set this to the name of the database. Or, leave this blank to use the default database of the authenticated user.
  • User: Set this to the username you want to use to authenticate to the Server.
  • Password: Set this to the password you want to use to authenticate to the Server.

Obtain the Server and Port values in the AWS Management Console:

  1. Open the Amazon Redshift console (http://console.aws.amazon.com/redshift).
  2. On the Clusters page, click the name of the cluster.
  3. On the Configuration tab for the cluster, copy the cluster URL from the connection strings displayed.

Refer Create an RPA Flow that Connects to Redshift Data in UiPath Studio .

If issue is still not resolved, refer to the below documentations for "how to connect Tableu to UiPath" and "the currents Tableu integrations available".