Business | Canvas

Oracle Analytics Remote Connector for MySQL

Contact Us

MySQL Connector for OAC

Connecting OAC to your existing MySQL database can save you lot of migration headaches and reduce costs. Here are some steps to connect to MySQL database by simply downloading and configuring the drivers. This option is also more secure as you can take advantage of java authentication and authorization to maintain role based access to your sensitive data.


1. Install java on your MySQL server or a separate server that can connect to the MySQL server
2. Install JDBC drivers for MySQL
3. Configure the JDBC settings to connect to MySQL server
4. Download OAC desktop client and configure the connection pool setting to add the web address as a data source
5. Open the firewall on oracle cloud to talk to OAC
6. Test the OAC connection by creating a DV model using this mysql/jdbc data source