Repository Database in Aurora MySQL
Fivetran HVR allows you to create a repository database in Aurora MySQL. The Repository Database section in Capabilities (6.1.0, 6.1.5) lists the supported Aurora MySQL versions that can be used as a repository database.
Grants for Repository Database
The following grant is required for the repository database in Aurora MySQL:
- 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 Aurora MySQL:
| Field | Description | Equivalent Location Property |
|---|---|---|
| HOST | Hostname or IP-address of the server on which the Aurora MySQL database is running. Example: 192.168.127.129 | Database_Host |
| PORT | Port number on which the Aurora MySQL database server is expecting connections. Example: 3306 | Database_Port |
| DATABASE | Name of the Aurora MySQL database. Example: mytestdb | Database_Name |
| USER | Username for connecting HVR to the Aurora MySQL database. Example: dbuser | Database_User |
| PASSWORD | Password for the USER. | Database_Password |