如何使用Camel连接来自不同数据源的两个相同表?

这看起来很简单,你只需要记住两件事。

• 你有来自两个地方的数据。
• 之前

那么 ,只有这样,才能将它们聚合在一起。

如果我要尝试一下,这将是一个开始。我想利用 SQL component

from("sql:select name, age from person?datasource=xyz&outputHeader=MySqlDataSet&outputType=Person")
    .to("direct:foo");
from("sql:select name, age from person?datasource=abc&outputHeader=PostgresDataSet&outputType=Person")
    .to("direct:foo");

from("direct:foo")
    .aggregate(constant(true), new GroupedExchangeAggregationStrategy())
    .completionFromBatchConsumer()
    .process(exchange -> {
         // now you have control over the exchange which has both exchanges
         // which has both properties you require.
         // manipulate, merge, and dedupe here to your heart's content.
     });