MySQL Source
Query data from a MySQL Database.
In your Pipe file, you must explicitly declare the SQL Server driver dependency in spec->integration->dependencies.
- "mvn:mysql:mysql-connector-java:"
Metadata
| Property |
Value |
| Type |
source |
| Group |
SQL |
| Namespace |
Database |
| Support Level |
Stable |
| Provider |
Apache Software Foundation |
Properties
| Name |
Type |
Required |
Default |
Description |
serverName |
string |
✓ |
|
The server name for the data source. |
serverPort |
string |
|
3306 |
The server port for the data source. |
username |
string |
✓ |
|
The username to access a secured MySQL Database. |
password |
string |
✓ |
|
The password to access a secured MySQL Database. |
query |
string |
✓ |
|
The query to execute against the MySQL Database. |
databaseName |
string |
✓ |
|
The name of the MySQL Database. |
consumedQuery |
string |
|
|
A query to run on a tuple consumed. |
delay |
integer |
|
500 |
The number of milliseconds before the next poll |
Dependencies
camel:jackson
camel:kamelet
camel:sql
mvn:org.apache.commons:commons-dbcp2:2.13.0