activities
latest
false
Developer activities
- Overview
- Cryptography
- Database
- Java
- Python
- WebAPI
Connect
Connect activity for connecting to a database using a standard connection string.
Description
Connects to a database by using a standard connection string.
SQLite is available as a data source in the Connection Wizard. To connect to a SQLite database, select the SQLite data source and provide the path to the database file (.db, .sqlite, or .sqlite3).
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
Stringvariables.
- DisplayName - The display name of the activity. This field supports only
- Connection Configuration
- Connection string - The connection string used to establish a database connection. This field supports only
Stringvariables. - Provider name - The name of the database provider used to access the database. This field supports only
Stringvariables. - Secure connection string - The connection string used to establish a database connection as Secure String. This field supports only
SecureStringvariables.
- Connection string - The connection string used to establish a database connection. This field supports only
- 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
DatabaseConnectionvariables.
- Database connection - The database connection used for the operations within this activity. This field supports only
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