Data Sources

Data Sources apply only to Source-type flows.

Data Sources allow you to connect your integration flows to databases using the JDBC Camel component. You configure and save the database access credentials only once, making it easier to reuse them in different integration flows.

Supported Data Sources

Azure SQL

Supported versions:

  • Azure SQL 2022

  • Azure SQL 2019

  • Azure SQL 2017

  • Azure SQL 2016

Connection string

jdbc:sqlserver://[serverName[\instanceName][:portNumber]]

Access official documentation

DB2

Connection string

jdbc:db2://<host>:<port>/<database>

Access official documentation

Firebird

Supported versions:

  • Firebird 5.x

  • Firebird 4.x

  • Firebird 3.x

Connection string

jdbc:firebirdsql://<HOST>:<PORT>/C:\PATH_TO_DATABASE/DATABASE_FILE.FDB

Access official documentation

MySQL 8.x

Connection string

jdbc:mysql://<host>:<port>/<database>

Access official documentation

PostgreSQL 8.4+

Connection string

jdbc:postgresql://host:port/database

Access official documentation

Oracle

Supported versions:

  • Oracle 11g

  • Oracle 12c

  • Oracle 19c

  • Oracle 21c

  • Oracle 23ai

Connection string

jdbc:oracle:thin:@[host]:[tcpPort]:[SIDname]
You can use service_name instead of SIDname.

Access official documentation

SQL Server

Supported versions:

  • Microsoft SQL Server 2022

  • Microsoft SQL Server 2019

  • Microsoft SQL Server 2017

  • Microsoft SQL Server 2016

Connection string

jdbc:sqlserver://[serverName[\instanceName][:portNumber]]

Access official documentation

Thanks for your feedback!
EDIT

Share your suggestions with us!
Click here and then [+ Submit idea]