MySQL can be used as Source or Target Server (subject to Licencing) If used as a target, only tables generated by Precision Bridge using the Precision Bridge Archiving Wizard can be written to.
MySQL can also be used as an external lookup server or reporting target (see related links below)
To use MySQL as the Source or Target Server, select MySQL DB from the Server Type dropdown.
Pre-requisites:
- MySQL JDBC Driver; First check that you have setup the path to the corresponding JDBC driver. See Configuring Access to a MySQL Database for more details.
The connection details will be displayed and must be completed as follows:
Data Source: The name, or IP Address, of the MySQL Server
Database: The name of the database you want to connect to
Port: The Listening Port configured for MySQL on the server. The default is 3306
User Name: The database user you will be connecting with. This user should have the required read/write privileges to the tables you will be working with.
Password: The password for the above user
If you want to retain the login details for each instance, select the Save Authentication option. After selecting this option, the username and password are stored and do not need to be entered again the next time you open the same project from the same client machine. Otherwise you will need to re-enter them each time you open the project.
In order to check that the relevant servers can be accessed using the credentials provided, click on the Test button on the right for each connection.
If the selected server is reachable then a confirmation message will be displayed. If the server is not reachable then a failure/timeout message will be displayed. If the MySQL server is still not reachable, check that you can connect using the same credentials from a native MySQL client application such as MySQL Workbench.
Related Articles:
Configuring Access to a MySQL Database
The Precision Bridge Archiving Wizard
Comments
0 comments
Please sign in to leave a comment.