Skip to main content

Open Database Connection

Establishes a connection to a database.

Category: Database Operations · Group: Database · Activity name: OpenDatabaseConnection

The OpenDatabaseConnection activity in the designer

Example

outputVariable = OpenDatabaseConnection(connectionString="<connectionString>", databaseType="postgres")

Inputs

NameTypeRequiredDefaultDescription
Connection StringstringThe connection string used to establish a connection to the specified database.
Database TypestringpostgresSelect the type of the database you wish to connect to. One of: postgres, mssql.

Outputs

NameTypeDescription
outputVariablereferenceThe name of the variable where the database connection will be stored and can be referenced in later steps.