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:

  • MySQL ODBC 8.3 Unicode Driver
  • MySQL ODBC 8.3 ANSI Driver
  • Oracle 21 ODBC driver
  • PostgreSQL ANSI
  • PostgreSQL Unicode
  • ODBC Driver 18 for SQL Server