activities
latest
false
Developer Activities
Last updated Oct 22, 2024

Connect

Description

Connects to a database by using a standard connection string.

Project compatibility

Windows - Legacy | Windows | Cross-platform

Windows, Windows - Legacy configuration

Designer panel
  • Configure Connection... - Select an existing database connection or add a new one using the Connection Wizard.
Properties panel

Common

  • DisplayName - The display name of the activity. This field supports only String variables.

Connection Configuration

  • Connection string - The connection string used to establish a database connection. This field supports only String variables.
  • Provider name - The name of the database provider used to access the database. This field supports only String variables.
  • Secure connection string - The connection string used to establish a database connection as Secure String. This field supports only SecureString variables.

Misc

  • Private - If selected, the values of variables and arguments are no longer logged at Verbose level.

Output

  • Database connection - The database connection used for the operations within this activity. This field supports only DatabaseConnection variables.

Cross-platform configuration

  • Provider name - The name of the database provider used to access the database.
  • Connection string - The connection string used to establish a database connection. Select the plus button to switch to Secure connection string.
  • Secure connection string - The connection string used to establish a database connection provided as a SecureString.
Advanced options
Output
  • Database connection - The database connection to be used with the database activities.
    Note: When configuring the database connection in automations using Serverless Automation Cloud robots, the following connection strings are available:
    • PostgreSQL ANSI
    • PostgreSQL Unicode
    • ODBC Driver 17 for SQL Server
    • MySQL ODBC 8.0 Unicode Driver
    • MySQL ODBC 8.0 ANSI Driver
    • Oracle 21 ODBC driver

Was this page helpful?

Get The Help You Need
Learning RPA - Automation Courses
UiPath Community Forum
Uipath Logo White
Trust and Security
© 2005-2024 UiPath. All rights reserved.