Edit on GitHub
Repository Database in MySQLlink
Fivetran HVR allows you to create repository database in MySQL.
Grants for Repository Databaselink
The following grant is required for the repository database in MySQL:
- The repository User should have permission to create and drop HVR repository tables.
Repository Database Connectionlink
This section describes the details required for connecting to the repository database in MySQL:
Field | Description | Equivalent Location Property |
---|---|---|
HOST | Hostname or IP-address of the server on which the MySQL database is running. Example: 192.168.127.129 | Database_Host |
PORT | Port number on which the MySQL database server is expecting connections. Example: 3306 | Database_Port |
DATABASE | Name of the MySQL database. Example: mytestdb | Database_Name |
USER | Username for connecting HVR to the MySQL database. Example: dbuser | Database_User |
PASSWORD | Password for the USER. | Database_Password |