Database Requirements

During its work MetaMiner Tableau Edition interacts with multiple databases. Some of the databases are accessed directly (see How MMTE Fits within Your Organization). Some of them are accessed indirectly via API and tabcmd.

MetaMiner Tableau Edition connects to two types of databases:

Tableau Server Repository(s)
MetaMiner Database (MMDB)

Making sure MMTE can connect to these databases is critical to MMTE for performing optimally. To ensure this, provide enough hardware resources (it is recommended to have the same CPU/RAM parameters for your database server(s) as for application servers), network connectivity, and port accessibility on one hand and proper configuration of your RDBMS on another hand.

Characteristics of Databases¶

The following table shows key database parameters:

Database	Version(s)	Instances	Location	Privileges	Notes
Tableau Server Repository	PostgreSQL 9.6 or 12.x, depending on Tableau version	1 or more	On Tableau Server host or on an external DB server (port 8060 TCP by default, can be changed)	SELECT only	MMTE uses the default `read-only` user account. Add IP address(es) of MMS to `pg_hba.conf`
MetaMiner Database (MMDB)	PostgreSQL 10.0	always 1	On MMTE Server host at the embedded PosgreSQL port 49614 TCP (recommended and by default) or on an external DB server	SELECT, DELETE, UPDATE, CREATE, INSERT, TRUNCATE (see below for details)	External DB server for MMDB makes sense for large installations only. Create a technical user account for MMTE. Add IP address(es) of MMS to `pg_hba.conf` MMTE installs a PostgreSQL run-time to host it (not configurable).

Is MMTE going to write to my Tableau Server Repository?

No, MetaMiner Tableau Edition is not. MMTE only reads data from the repository. All active actions to Tableau, which indirectly induce changes in the repository, are made by using Tableau APIs and/or tabcmd.

See Configuring MMDB for the steps to be performed before a database can be used by MMTE.

Database Technical User Account¶

It is recommended to create a special database technical user account in all previously mentioned databases (except for the embedded PostgreSQL where this user is pre-installed). This user account will be used exclusively by MMTE Server. The recommended username is mmuser. User access mode must be set 'with a password'.

This user account must be granted with the following privileges in a database supposed for usage as MMDB:

SELECT
DELETE
UPDATE
CREATE
INSERT
TRUNCATE

for the following database objects:

TABLE
SESSION
VIEW
TRIGGER
SEQUENCE
STORED PROCEDURE
FUNCTION
INDEX

If permissions are not sufficient, MMTE Administrator will report it during connection validation.