Open a connection to your database server
Inputs
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
Database Type dbType | enum | Optional | mssql | —mssqlmysqlpostgresoracle |
Server/Host dbHost | string | Required | — | — |
Port dbPort | number | Optional | — | — |
Database Name dbName | string | Required | — | — |
Username dbUsername | string | Optional | — | — |
Password dbPassword | password | Optional | — | — |
Windows Authentication useWindowsAuth | boolean | Optional | false | — |
Connection Variable outputVariable | variable | Optional | DbConnection | — |
Output
DbConnectionConnectionDatabase connection for executing queries
IsConnectedBooleanDatabaseNameStringServerNameString
Compatibility
WindowsLinuxAttendedUnattended