Skip to main content
Alumio supports direct database connectivity for integrations that read from or write to relational databases. A Database Client stores the connection details needed to communicate with an external database and can be reused across multiple integrations. Navigate to Connections → Database Clients to create and manage database connections.

​
What Database Clients can do

  • Connect directly to a relational database as a source or destination in an integration.
  • Read data from a database via an Incoming configuration using the Database subscriber.
  • Write data to a database via an Outgoing configuration using the Database Batch Publisher.
  • Execute queries inline during data processing using the Database Transformer.

​
Filtering Database Clients

The overview page lists all Database Clients in your environment. Filters are available for Name, Created at, Updated at, and Labels. Use + Add Filter for additional conditions. Click any column header to sort.

​
Creating a Database Client

A Database Client is configured by selecting a prototype that determines which connection fields are available. The following database types are supported:
NameDescription
IBM DB2Database connection for an IBM DB2 server
MSSQLDatabase connection for Microsoft SQL Server (MSSQL)
MySQLDatabase connection for MySQL
OracleDatabase connection for Oracle
PostgreSQLDatabase connection for PostgreSQL
Each prototype exposes the connection fields relevant to that database type: server host, port, database name, credentials, and database-specific options such as character set, encryption, and connection timeout.