MySQL
To use Dozer's MySQL connector, a specific server URL format is required. This URL consolidates details about the server's location, authentication specifics, the target database name, and any other optional parameters that refine the connection.
Configuration
connections:
- config: !MySQL
url: mysql://root:mysql@localhost:3306/orders
name: orders
The above configuration establishes a MySQL connector. This connector will loads data from a MySQL database named orders
located on a server at localhost:3306
. It uses the username root
and the password mysql
for authentication.
You can enhance the connection URL by appending additional URL query parameters. For a complete guide, follow this link.
Trying it out
To test a MySQL sample, clone the dozer-samples
GitHub repo and follow the steps described here.