SQL Database Connect & Validate

Overview

Connects to an SQL server and validates the connection

Currently supports:

We will be happy add other databases if you need us to - just reach out to us and we’ll see what we can do.

If building a custom connection string (rather than a pre-configured one that you can select) please note that the connection string formats are:

Database	Connection String
Oracle	`oracle://{user}:{password}@{db url}:{port number}/{db name}`
MsSQL	`sqlserver://{username}:{password}@{db url}/{instance}?database={db name}`
MySQL	`{user}:{password}@tcp({db url}:{port number})/{db name}?tls=skip-verify`
Postgresql	`user={user} password={password} host={db url} port={port number} dbname={db name} sslmode=require`

Parameter	Parameter	Valid Blocks	Required
`Set a Dynamic Name`	Show the Dynamic Name slot in the tree so that it can be set statically or dynamically	Boolean Block Group	No
`Dynamic Name`	The dynamic name of this item	Text Block Group	No
`Attributes`	Metadata values for this block. Used in XML and multipart/form-data.	Text Block Group	No
`Database Connection Config`	A connection configuration that was setup in the Databases panel	Text Block Group	No
`Custom Connection Name`	A friendly name for your custom database connection configuration	Text Block Group	No
`Custom Connection Driver`	The driver your custom database connection configuration will use	Text Block Group	No
`Custom Connection String`	A custom database connection string/data source name (DSN)	Database Connection String Block Group	No