Skip to content

andrevanzuydam/metabase-firebird-driver

Repository files navigation

Firebird driver for metabase

This driver enables metabase to connect to FirebirdSQL databases.

Installation:

  • Make sure you have installed a recent Metabase Version.
  • Download the latest release of the Firebird driver or build it from source.
  • Create the plugins directory if it doesn't already exist. By default that directory is next to the metabase.jar file, but you can specify a different directory by setting the environment varianble MB_PLUGINS_DIR.
  • Just drop the firebird.metabase-driver.jar in the plugins directory. On startup, metabase will load the plugin and the driver should be available.

Authentication issues when using Legacy_Auth

The latest releases are built with version 4.x of Jaybird (the Firebird JDBC driver), which no longer supports Legacy_Auth.

⚠️ First of all: Legacy_Auth is disabled for a reason. You should only use the following workarounds if you have no way of using a more secure authentication method. ⚠️

If you really need to access your database using Legacy_Auth (#14) you can add it to the authentication plugins. For example:

jdbc:firebirdsql://localhost/employee?authPlugins=Legacy_Auth

If that does not work for you, you can use the release artifact firebird.metabase-driver_jaybird-3.jar which is built with Jaybird 3.x.

Building from source:

For a detailed description, take a look at the official documentation.

  • Checkout the main metabase repository and the firebird driver repository in the same parent directory:
workspace
  - metabase
  - metabase-firebird-driver
  • Run the build.sh script from the metabase-firebird-driver repository
cd metabase-firebird-driver
./build.sh
  • The driver will now be built. The .jar file can be found in the target directory.

Development Notes

Under WSL after cloning the metabase project and installing clojure and yarn set up your ~/.clojure.edn

{
  :aliases {
    ;; Add cross-project aliases here
    ;; ~/.clojure/deps.edn
    :user/firebird-driver {
      :extra-deps {metabase/firebird-driver {:local/root "../metabase-firebird-driver"}}
      :jvm-opts   ["-Dmb.dev.additional.driver.manifest.paths=../metabase-firebird-driver/resources/metabase-plugin.yaml"]
    }
  }
}

Run a development environment

clojure -M:user/firebird-driver:nrepl --bind 0.0.0.0 --port 50605
clojure -M:user/firebird-driver:run

Release notes

Current version is 1.6.2 Fixes for Concat and long field names breaking queries

Version is 1.6.1 Added ability to use a connection string Has fixes for group by, complex date handling

About

A plugin that allows Metabase to connect to FirebirdSQL databases.

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Contributors 4

  •  
  •  
  •  
  •