Outgoing connections - SQL

Overview

Used to create, update, delete and browse through outgoing SQL connections, used by Zato services to access SQL databases.

../../_images/sql.png

Create and Edit

../../_images/sql-update.png
Header Notes
Name Connection name
Active

Whether the connection can be used by services or not.

If a connection is not active a service will encounter a zato.common.Inactive exception when attempting to use it.

Note that an inactive connection still can be pinged.

Host Database host
Port Database port
Database name Database name
User Database user
Pool size Connection pool size. Always start with 1 and increase only if it’s not enough in practice.
Extra (Optional) Any extra parameters passed directly into SQLAlchemy’s create_engine function as its keyword arguments. A connection won’t be available if any of the keywords is not a valid SQLAlchemy one.

Ping

../../_images/sql-ping.png

A connection can be pinged - this sends a dummy query from one of a cluster’s servers. This can be used to check whether a given database is reachable by Zato servers.

The feature is available even if a connection is inactive.