∝EBI Neutrino
Open Source CRM / ERP System

Database Setup

EBI Neutrino comes with a portable Java database, H2, making it ideal for small companies and businesses to use and test. For larger-scale deployments or specific requirements, you can configure EBI Neutrino to work with other databases like MySQL using its built-in DB Setup Tool.This guide outlines the steps to configure EBI Neutrino to use a different database.


dbsetup

Steps to Configure EBI Neutrino with an External Database

  1. Open the EBI Neutrino Terminal

    • Launch the terminal application of EBI Neutrino.

  2. Run the DB Setup Tool

    • Enter the command: run dbsetup

    • A DB Setup dialog will appear, as shown in the image below.

  3. Configure Database Settings

    • Database Name: Select the database type (e.g., MySQL).

    • Catalog Name: Enter the name of the catalog where the EBI Neutrino tables will be imported.

    • Driver: Specify the appropriate database driver.

    • Host/IP Address: Enter the database server's host or IP address.

    • User: Provide the database username.

    • Password: Provide the database password.

  4. Test the Connection

    • Click the Test Connection button.

    • Ensure the credentials are valid and the connection is successful.

    • If successful, the Generate button will be activated.

  5. Generate Configuration File

    • Click the Generate button to encrypt the connection data and store it in a secure configuration file.

  6. Import Database Schema

    • Once the configuration file is created, the DB Import Schema process is automatically activated.

    • Monitor the progress of the import process.

  7. Completion

    • After the schema import is successfully completed, EBI Neutrino will connect to the configured database automatically at every startup.

Important Notes

  • Ensure you have the correct database driver available in the EBI Neutrino environment.

  • Use the Test Connection step to verify all credentials and network settings.

  • If errors occur during the import process, review the database logs for troubleshooting.

By following these steps, you can seamlessly configure EBI Neutrino to integrate with external databases for enhanced scalability and flexibility.