I would like ask if it is possible to use airbyte for this specific scenario if not what alternative can achieve this

Hi @Mohamed Sharif, to which destination are you sending the data, and is it coming from separate databases for each branch? I only work with (Google Cloud) BigQuery, but if you set up Airbyte to sync all the data to BigQuery you can easily aggregate different tables (with the same schema and field order) with a

UNION ALL

pattern. If it’s from different databases you’ll need to set up a different connection for each one. DM me if you want some help, it’s pretty quick.