Before You Create the Data Preparation Service
Before you create the Data Preparation Service, complete the prerequisite tasks for the service.
Perform the following tasks before you create the Data Preparation Service:
- •Set up the MySQL server database (version 5.6.26 or above) that the Data Preparation Service connects to. Ensure that the database is case insensitive. For MySQL version 5.6.26 and above, set lower_case_table_names=1 and for MySQL version 5.7 and above, set explicit_defaults_for_timestamp=1 in the my.cnf file.
- •Set up the required user account for the MySQL database with create, drop, and alter permissions for tables and views.
- •If you use HTTPS to connect to the Data Preparation Service, verify the location and password of the keystore and truststore files.