Table of Contents

Search

  1. Preface
  2. Part 1: Installation Getting Started
  3. Part 2: Before You Install the Services
  4. Part 3: Run the Services Installer
  5. Part 4: After You Install the Services
  6. Part 5: Informatica Client Installation
  7. Part 6: Uninstallation
  8. Appendix A: Starting and Stopping Informatica Services
  9. Appendix B: Connecting to Databases from UNIX or Linux

Installation for Enterprise Data Preparation

Installation for Enterprise Data Preparation

MySQL and MariaDB Database Requirements

MySQL and MariaDB Database Requirements

You can use a MySQL database or a MariaDB database as the Data Preparation repository.
Set the required system variables on the database server.
  • For MySQL version 5.6.26 and higher, set lower_case_table_names=1.
  • For MySQL version 5.7 and higher, set explicit_defaults_for_timestamp=1.
Set the same system variable values for a MariaDB database.
Set the required permissions on the MySQL or MariaDB database.
  • Create tables and views.
  • Drop tables and views.
  • Insert, update, and delete data.
Download and copy the MySQL connector .jar file to the node where you create the Interactive Data Preparation Service.
Download the file and copy it to the following directory before you start the installer:
$USER_INSTALL_DIR$/services/shared/jars/thirdparty/
Make sure the name of the file is in the following format:
mysql-connector-java-<versiondetails>.jar
You must also set the mysql_connector_jar_path environment variable to the location of the MySQL connector .jar file.