Table of Contents

Search

  1. Installation Getting Started
  2. Before You Install the Services
  3. Run the Big Data Suite Installer
  4. After You Install the Services
  5. Install the Developer Tool
  6. Uninstallation
  7. Starting and Stopping Informatica Services
  8. Connecting to Databases
  9. Updating the DynamicSections Parameter of a DB2 Database
  10. Silent Input Properties File

Installation and Configuration Guide

Installation and Configuration Guide

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 following 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.
Ensure that the MySQL or MariaDB database has the following permissions:
  • Create tables and views.
  • Drop tables and views.
  • Insert, update, and delete data.
The MySQL connector .jar file is not included with the installer. You must 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.