Question Vinicius Viana · May 28, 2024

Connecting InterSystems Caché with Metabase BI

Hi everybody,

I need to connect a Caché database to Metabase, but Metabase does not support this database.
Metabase only supports these databases:

- Amazon Athena
- BigQuery (Google Cloud Platform)
- Druid
- MongoDB (recommend version 4.2 or higher)
- MySQL (recommend version 8.0.33 or higher, as well as MariaDB version 10.4 or higher)
- Oracle
- PostgreSQL
- Presto
- Redshift (Amazon Web Services)
- Snowflake
- SparkSQL
- SQL Server
- SQLite
- Vertica

And a few others made by the community. (It is possible to create a driver so that Caché is supported, but I have no experience with that.)
I would like to know if it is possible to somehow connect Caché to any of these databases already included in Metabase?

Product version: Caché 2018.1

Comments

Dmitry Maslennikov · May 28, 2024

Metabase offers a way to write your own driver to any database, that supports jdbc

So, with some knowledge in Clojure, it's possible to connect it directly to Caché or IRIS

You can do it by yourself, or I can do it for you.

0
Vinicius Viana  May 28, 2024 to Dmitry Maslennikov

I have never used Clojure, so if you did this for me I would be eternally grateful.

0
Alex Bravo · Dec 13, 2024

Hello Dmitry and Vinicius, did the Metabase driver for Cache ever get written? I am interested in writing a Metabase driver for IRIS.

0