Database Store - Overview
Database Store is the central module of the platform responsible for managing all database connection definitions and configurations used across other system components.
It enables:
- Registering and storing database connection definitions (BAS — Backend Adapter Systems).
- Reusing saved connections without re-entering credentials.
- Editing existing connections.
- Integrating seamlessly with modules like Database Comparer, Database Wizard, and Connector Manager.
Supported Backend Adapter Systems
PostgreSQL
Oracle
Informix
IBM DB2
S3 Amazon
Cassandra
MS SQL Server
HDFS
Snowflake
MySQL
Core Functionalities
Connection Management
- Create and configure database connections (URL, host, port, username, password, schema, etc.).
- Save connections in a centralized repository.
- Assign logical names (e.g.,
ORCL_PROD,PG_TEST) for clarity and reuse.
Configuration Reuse
- Other modules can directly reference saved configurations.
- Credentials are stored once and reused across processes.
- Enables global updates — e.g., updating a password or host affects all linked connectors.
Creating and editing connections through the user interface
- All stored connections can be created and modified through the graphical interface.
- Built-in validation ensures correct URL formats, port numbers, and server availability.
Connection Parameters
| Parameter | Description | Connector Mapping |
|---|---|---|
| URL | Full JDBC URL (e.g., jdbc:oracle:thin:@host:1521/ORCL) | Maps to database.url. |
| Host | Database server hostname or IP | Used in URL construction. |
| Port | Service port (e.g., 1521, 5432) | Used in URL and connection checks. |
| Database / SID / Service Name | Database or service identifier | Completes the JDBC endpoint. |
| Username / Password | Authentication credentials | Mapped to database.user and database.password. |
Values from Database Store are automatically mapped into connector configurations or comparison sessions, ensuring consistency and eliminating manual errors.