MySQL
Visier can retrieve data through this connector if the following requirements are met.
Note: Beta This is a beta connector. If you are interested in using this connector, please contact your Customer/Partner Success Manager.
This data connector retrieves data stored in MySQL.
Prerequisites
- Create an integration user in MySQL.
Integration user
Create an integration user in your source system and assign it the appropriate security access so that Visier can retrieve your source data through this user.
|
Access |
Description |
|---|---|
|
SELECT |
Grant Select privileges on the tables you want Visier to access. |
|
INFORMATION_SCHEMA |
Grant query access to INFORMATION_SCHEMA. |
Connector credentials
Create a connector credential in Visier to authenticate and authorize access to your source system. Connector credentials can be created in Studio or through an API. For more information, see Set Up Data Connectors and "Create a connector credential" in API Reference. You will need to provide the following credentials in your connector credential configuration.
|
Credential |
Description |
Example |
|---|---|---|
|
Host |
The hostname or IP address of the MySQL server. |
mysql.example.com |
|
Port |
The port number of the MySQL server connection. |
3306 |
|
Database |
The name of the database to retrieve data from. |
hr_database |
|
Username |
The integration user's username. |
integration.user |
|
Password |
The integration user's password. |
Password1234 |
Data files
The MySQL data connector retrieves data stored in MySQL for use in Visier. Any additional data must be provided through alternative methods, such as flat files or other data connectors. For more information, see Data In.
How the connector loads data
Initially, data connectors retrieve a full history for each subject to generate an initial history of events. In each subsequent data retrieval, each connector handles the data load differently.
- Full load: All data from the source system is loaded into Visier.
- Delta load: Only changed data is loaded into Visier. A delta load may take either the entire history or a specific number of years of history for each changed record.
- Snapshot load: All data at a particular point in time. A snapshot load does not contain historical records or show changes over time.
- Partial load: A subset of data is loaded into Visier.
After the initial load, this connector only retrieves data for changed records.