Creating an Oracle MySQL Connection

You must create an Oracle MySQL connection before you can use the Oracle MySQL activities. The Oracle MySQL connection contains all the parameters required to connect to the Oracle MySQL database. The Oracle MySQL connection is used by all the activities in the Oracle MySQL category.

Note: By default the Oracle MySQL database listens for connections on port 3306, although that is configurable as port is the connection property on the MySQL Connector.

To create a Oracle MySQL connection, perform the following steps:

  1. Click the Connections tab and perform one of the following actions:

    • To add a connection for the first time, click the MySQL Connector card. You can search for a connector by typing the connector name in the search field.
    • If you have existing connections and want to add a new connection, click the Add Connection link.
  2. In the MySQL Connector dialog box, enter the connection details. For field descriptions, see Oracle MySQL Connection Details.
  3. Click Save Connection.