Repository Database in MariaDB
Fivetran HVR allows you to create a repository database in MariaDB. The Repository Database section in Capabilities (6.1.0, 6.1.5) lists the supported MariaDB versions that can be used as a repository database.
Grants for Repository Database
The following grant is required for the repository database in MariaDB:
- The repository User should have permission to create and drop HVR repository tables.
Repository Database Connection
This section describes the details required for connecting to the repository database in MariaDB:
| Field | Description | Equivalent Location Property |
|---|---|---|
| HOST | Hostname or IP-address of the server on which the MariaDB database is running. Example: 192.168.127.129 | Database_Host |
| PORT | Port number on which the MariaDB server is expecting connections. Example: 3306 | Database_Port |
| DATABASE | Name of the MariaDB database. Example: mytestdb | Database_Name |
| USER | Username for connecting HVR to the MariaDB database. Example: username | Database_User |
| PASSWORD | Password for the USER. | Database_Password |