Skip to main content

Connect to the database server

Before designing the physical model, establish a connection to your database server. The Database Designer supports SQLServer, PostgreSql, MySQL, Mariadb, and Oracle.

Create a database connection​

  1. In KAIZEN Studio Console, find the project and click Database Designer Database Designer icon.

    Open the Database Designer

  2. In the designer, click Connections on the navigation bar, then click the + sign to create a new connection. Select the target database type.

    Create a new connection

  3. Fill in the connection details in the configuration panel.

    FieldMandatoryDescription
    NameYesA unique, descriptive name for the connection. This is used to identify the connection in the Resources panel.
    HostYesThe hostname or IP address of the database server.
    PortYesThe port number used by the database server.
    AuthenticationYesThe authentication method for the connection. Select from the dropdown (e.g., Username & Password).
    UserYesThe username to authenticate with the database server.
    DatabaseYesThe name of the specific database to connect to. Supported databases include SQLServer, PostgreSql, MySQL, Mariadb, and Oracle.
    URLNoThe JDBC connection URL. This field is auto-generated based on the Host, Port, and Database values.
    Enable TLSNoToggle to enable TLS encryption for the connection.

    Optionally, expand Advanced Configuration to add custom connection properties as key-value pairs.

  4. Click Test to verify the connection. Once successful, click Save.

    Test the database connection

Last updated on 20 May 2026