Before you start
Connections work in both execution modes:- Hosted mode — no agent needed. Your connection is tested and used directly by Zwiron’s infrastructure. Your source/destination must be reachable over the internet. If the database uses an IP allowlist, add Zwiron’s static egress IPs.
- Agent mode — an installed agent handles the connection from inside your network. Required for private databases, VPCs, and on-premises systems.
Creating a connection
- Click Connections in the left sidebar
- Click New Connection
- Choose your connector type from the list
- Select an execution mode:
- Choose Hosted if your endpoint is publicly reachable
- Choose an Agent if you need in-network connectivity (you’ll see your connected agents listed here)
- Fill in the connection details (host, port, database, username, password). If you paste a connection string and the password has special characters (
@,%,:,/, etc.), percent-encode them — or use the separate password field instead. - Click Test Connection — Zwiron verifies connectivity through the selected mode
- If the test passes, click Save
- Profile the connection (table sizes / row estimates) before creating trial jobs — the trial 1 GB sample cap uses these sizes to block oversized syncs up front. See Billing → Free trial.
What gets stored
Credentials are stored encrypted regardless of execution mode:- Agent mode — credentials are encrypted with the agent’s RSA key. Atlas stores the ciphertext; the agent keeps a local encrypted copy and decrypts only for syncs. Zwiron cannot read plaintext without the agent’s private key.
- Hosted mode — credentials are encrypted at rest in Zwiron’s infrastructure and used only inside isolated execution environments. They are never logged or accessible by Zwiron staff.
Connection types
Live today — five enterprise connectors:
On demand — additional connectors can be enabled on request. See More connectors on demand. Do not assume they are available on your account until support enables them.
Setting database permissions
Zwiron needs read access on sources and write access on destinations. We recommend creating a dedicated database user for Zwiron with the minimum required permissions. See the connector-specific guide for exact permission requirements — for example:Testing a connection
Click Test Connection at any time — from the create flow or from the connection detail page — to verify your agent can reach the database. The test checks:- Network reachability (can the agent reach the host/port)
- Authentication (username/password are correct)
- Database access (the configured database exists and is accessible)