Configuring a MySQL data source

Prerequisites

Access to the Data source management > Data sources > Database (DI003) menu.
Having a MySQL database installed and configured.

SoftExpert Suite allows for creating and configuring MySQL data sources.

See more information about the MySQL container and how to install it in the How to upload a MySQL container to your development environment Integration guide topic.

See how to set this configuration:

1. Access the Data source management > Data sources > Database (DI003) menu.

2. Click on the Add icon. button.

3. In the Driver field, choose the MySQL option.

4. Enter the MySQL database connection information, including database name, host (server name), port, username. and password.

5. Test the connection by clicking on the Check icon. button.

6. If the connection is successful, the message Successful connection will be displayed; click on the Save and exit icon. button.

Make sure that your SoftExpert Suite instance has access to the MySQL database and that the inserted credentials are correct.

Additionally, a user account with the minimum required permissions is recommended for access to the desired data.

All done! The MySQL data source is now created and can be used in external attributes, in SoftExpert Analytics, or in datasets.