The MySQL Connector allows Maverics to connect to and query a MySQL database for users and their profile attributes.
Configuration options
The following values can be provided to the MySQL connector via the Maverics configuration file.
DB Name
dbName is the name of the database that will be connected to.
Service Account Password
serviceAccountPassword is the password used to connect to the MySQL database.
Service Account Username
serviceAccountUsername is the username used to connect to the MySQL database.
Table Name
tableName is the name of the table that will be queried.
URL
url is the URL where the database is hosted.
Key Column Name
keyColumnName is the name of the field in the table used to look up a user.
Examples
Sample Connector Configuration
connectors:
- name: mysql-example
type: mysql
serviceAccountUsername: username
serviceAccountPassword: password
dbName: company
url: mysql.example.com
tableName: employee
keyColumnName: username