Integration Service user guide

Prerequisites​

• SQL Server / PostgreSQL / Oracle / Amazon Redshift

  • Database host
  • Username
  • Password
  • Database and schema

• Snowflake

  • Database host
  • Username and password
  • Warehouse, database, and schema

• Databricks

  • Database host
  • HTTP path
  • Personal access token
  • Warehouse, catalog, and schema
  Note:

  • Databricks connections are supported for both Databricks on Azure (*.azuredatabricks.net) and cloud.databricks.com.
  • When connecting to Databricks, the connector includes a User-Agent header value of uipath+uipath with each request. This identifier helps Databricks and administrators trace requests to UiPath in audit and diagnostic logs.

Add the Database Hub connection​

1. Select Orchestrator from the product launcher.
2. Select a folder, and then navigate to the Connections tab.
3. Select Add connection.
4. To open the connection creation page, select the connector from the list. You can use the search bar to find the connector.
5. On the connection page, select your database type (for example, SQL Server, Databricks, Snowflake).
6. Enter the required credentials (for example, host, username, password, database name/schema).
7. Click Connect.