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