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