Location Connection for MariaDBlink
This section describes the connection details required for creating MariaDB location in Fivetran HVR. For information about the pre-requisites, access privileges, and other configuration requirements for creating MariaDB location, see MariaDB Requirements.
HVR uses MariaDB's native Connector/C interface to connect, read, and write data to MariaDB. HVR connects to the MariaDB server using the TCP protocol.
If the managed secrets feature is enabled, option USE TOKEN INSTEAD is displayed in the fields designated for entering secrets.
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: hvruser | Database_User |
PASSWORD | Password for the USER. | Database_Password |
Staginglink
HVR supports staging for MariaDB location. For information about the location properties for staging, see Staging for MariaDB.