Metabase Integration

{{metabase}} is an open source business intelligence tool designed to create charts and dashboards from various data sources prerequisites to use metabase with your {{ocient}} system, you must have these software prerequisites ocient system — use version 22 0 or later jdbc driver — use the latest version install metabase go to the installing metabase and follow the directions for installation, including all prerequisites download the latest ocient metabase driver jar file and copy it to your metabase plugins folder this jar file enables your metabase installation to connect to ocient connect to ocient to add a database connection, select the icon at the top right of the metabase homepage select admin settings > databases > add database in the menu this connection page appears the displayed connection fields change after you select "ocient" as the database type enter these fields in your connection settings field description database type the type of database select "ocient" display name the display name for your database in metabase host the host name or ip address of the sql node of your database for example databasehost sql0 port the port number for your connection unless you have to alter this, the default ocient port is 4050 database name the name of the database for connection for example my db schemas the identifiers for any schemas you want to use or exclude to use all available schemas, select all authentication method choose between single sign on (token) for single sign on (sso) or password for password authentication user the username associated with your database password the password associated with your username type of sso token use access token sso token specify your sso access token string to use sso authentication, you must have sso integration enabled for the specified database and group for more information, see database, tables, views, and indexes docid\ a4jvhkvg31tapexr9zpcq when you successfully connect, you see your database added to metabase your database appears as one of the active connections in metabase list of metabase databases advanced connection options you can add more connection settings as part of the jdbc connection string in metabase to add these, go to the add database page and select show advanced options you can specify options in the field additional jdbc connection string options in this image, the specified options include a maximum of 10,000,000 rows and a timeout of 0 milliseconds, using the maxrows and timeoutmillis parameters respectively for a list of supported jdbc options, see the jdbc manual docid\ wwz1djxrgnnfu96ig5uyl related links connect to ocient docid 3ogdk ko9evjyfqgs6n5h ocient integrations docid\ lbwkjbkyfpui bkxdhdwa