Microsoft SQL Server Source
Query data from a Microsoft SQL Server Database.
In your Pipe file, you must explicitly declare the SQL Server driver dependency in spec->integration->dependencies
- "mvn:com.microsoft.sqlserver:mssql-jdbc:"
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 |
|
1433 |
The server port for the data source. |
username |
string |
✓ |
|
The username to access a secured SQL Server Database |
password |
string |
✓ |
|
The password to access a secured SQL Server Database |
query |
string |
✓ |
|
The query to execute against the SQL Server Database |
databaseName |
string |
✓ |
|
The name of the Database. |
consumedQuery |
string |
|
|
A query to run on a tuple consumed |
encrypt |
boolean |
|
false |
Encrypt the connection to SQL Server. |
trustServerCertificate |
boolean |
|
true |
Trust Server Certificate |
delay |
integer |
|
500 |
The number of milliseconds before the next poll |
Dependencies
camel:jacksoncamel:kameletcamel:sqlmvn:org.apache.commons:commons-dbcp2:2.13.0