Re: How to produce messages to Azure SQL DB in Camel

Hi, Does these components have HA by default or do I need to use the camel clustering to achieve it ? camel debezium sql server connector camel-jdbc camel-sql -Regards Srikant Mantha On Mon, Dec 14, 2020 at 10:22 AM Omar Al-Safi wrote: > Hi, > > As mentioned here >

Re: How to produce messages to Azure SQL DB in Camel

Hi, As mentioned here , both use JDBC driver meanwhile Camel SQL provides better support for SQL queries in the endpoint. Personally, it is more what you'd feel more comfortable with, try both and see what component that can fit your n

Re: How to produce messages to Azure SQL DB in Camel

Thanks for your reply, how better is it to use the Camel SQL compared to Camel JDBC. -Regards Srikant On Thu, 10 Dec, 2020, 10:53 Omar Al-Safi, wrote: > Hi, > > To write your events to your target Azure SQL server database, you can > use Camel > JDBC

Re: How to produce messages to Azure SQL DB in Camel

Hi, To write your events to your target Azure SQL server database, you can use Camel JDBC component since Azure SQL supports JDBC uses JDBC driver to connect to the database. Plus Camel Debezium SQL Server, I'd recommend using someth

How to produce messages to Azure SQL DB in Camel

Team, I have a usecase where I need to replicate data for a specific duration from one Azure SQL DB (subscription1) to another Azure SQL DB (supbscription2). The source DB has live data with continuous inserts, updates and deletes possibility. Henceforth, we will miss the updates while performing