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
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:
|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
|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
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
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:
for the following database objects:
- STORED PROCEDURE
If permissions are not sufficient, MMTE Administrator will report it during connection validation.