Install the Oracle and MySQL Drivers in CloudConnect

CloudConnect is a legacy tool and will be discontinued. We recommend that to prepare your data you use the GoodData data pipeline as described in Data Preparation and Distribution.

If you have CloudConnect graphs that extract data from an Oracle database or/and a MySQL database and you want to run such graphs locally in CloudConnect, install the Oracle driver or/and the MySQL driver correspondingly to your CloudConnect instance.

These drivers are required only for the graphs that you run locally. If the graphs run on GoodData servers, you do not have to intall the drivers.

Before you start, make sure that you have the driver located on your computer.

The supported versions of the drivers:

  • MySQL driver – version 5.1.46 (mysql-connector-java-5.1.46-bin.jar)
  • Oracle driver – version 6 (ojdbc6.jar)

The steps vary depending on the operating system installed on your computer.

For a MacOS

Steps:

  1. Copy the driver to any directory on your computer, for example:

    /usr/share/drivers
  2. Navigate to the folder where CloudConnect is installed. Right-click the CloudConnect application, and select Show Content Package.
    The Contents folder opens.
  3. Go to Contents -> Eclipse, and locate the eclipse.ini file.
  4. Open eclipse.ini in editable mode, and add the following line at the end of the file:

    • For the Oracle driver

      -Dclover.designer.external-oracle-jdbc=file:/usr/share/drivers/ojdbc6.jar
      
    • For the MySQL driver

      -Dclover.designer.external-mysql-jdbc=file:/usr/share/drivers/mysql-connector-java-5.1.46-bin.jar
    The file location in the line must correspond with the actual path to the driver on your computer.
  5. Save the changes, and close eclipse.ini.
  6. Start CloudConnect, and go to CloudConnect -> Preferences -> Java ->  Installed JREs.
  7. Select your installed JREs, and click Edit... .
    The edit dialog opens.
  8. Click Add External JARs... , navigate to and select the driver stored on your computer, and click Open.
    The browse dialog closes. You are back to the edit dialog.
  9. Click Finish, then click OK.
    The driver is added to CloudConnect.
  10. Restart CloudConnect.

For a MS Windows OS

Steps:

  1. Copy the driver to any directory on your computer, for example:

    C:/Drivers/
  2. Navigate to the folder where CloudConnect is installed, and locate the file CloudConnect.ini.
  3. Open CloudConnect.ini in editable mode, and add the following lines at the end of the file:

    • For the Oracle driver

      -Dclover.designer.external-oracle-jdbc=file:C:/Drivers/ojdbc6.jar
    • For the MySQL driver

      -Dclover.designer.external-mysql-jdbc=file:C:/Drivers/mysql-connector-java-5.1.46-bin.jar
    The file location in the line must correspond with the actual path to the driver on your computer.
  4. Save the changes, and close CloudConnect.ini.
  5. Start CloudConnect, and go to Window -> Preferences -> Java -> Installed JREs.
  6. Select your installed JREs, and click Edit... .
    The edit dialog opens.
  7. Click Add External JARs... , navigate to and select the driver stored on your computer, and click Open.
    The browse dialog closes. You are back to the edit dialog.
  8. Click Finish, then click OK.
    The driver is added to CloudConnect.
  9. Restart CloudConnect.