1. Using the MySQL Adapter with Oracle Integration 3
  2. Create a MySQL Adapter Connection
  3. Prerequisites for Creating a Connection

Prerequisites for Creating a Connection

You must satisfy the following prerequisites to create a connection with the MySQL Adapter:

  • Ensure that you have write permissions on the database.

  • Ensure that you have the required permissions to run stored procedures and packages and SQL statements against the MySQL Database.

  • Know the database hostname or IP address and the port number.

  • Know the database name.

  • Know the username and password for connecting to the database.

  • Download the mysql-connector-java-commercial-5.1.22-bin.jar or the relevant mysql-connector JAR based on your MySQL database version to the host on which the connectivity agent is installed.

    For example, perform the following steps if mysql-connector-java-commercial-5.1.22-bin.jar is the JAR required for your environment.

    1. Download the mysql-connector-java-commercial-5.1.22-bin.jar from the MySQL Database site. Check the Oracle Integration Adapters Certification matrix to identify the certified versions of the MySQL Database.

    2. Copy the JAR file to agenthome/thirdparty/lib.

    3. Restart the connectivity agent.

      If you do not download and install this JAR file, you receive a Check agent status error when testing the connection on the Connections page in Oracle Integration.