Hi All,
I was wondering how you guys approach the scenario of multiple locations, branches, sites. How do you excchange data between the head office and the remote branches. I am specifically talking about remote sites that does not have a good internet connection and cannot work online to the head office thus needing some batch data exchange process.
Thanks in advance, your help is appreciated.
Adele
Dear Mr/Ms/Mrs Adele
Before going further into technical integration landscape, i jut want to know what kind of consolidation do you want ? is it central accounting only (all transaction that effect / generate jounal only for example invoice AR/AP) or central master data (Busines Partner,Item Master etc) or approval stages consolidation ( for example your Branch creates Purchase Order, they cannot create GRPO based on that PO until the Headquarter apporved it ). If you want to use batch data exchange process i suggest you to use database pooling on every branches so the branches have their own SBO Database.On The End Of The Day the Branches send all transaction today that related to journal ( Assumed we use central accounting ) in form of encrypted flat files perhaps or XML Files, you can use scheduled SQL Mail in DTS Packages SQl Server to send the files through Email to headquarter or your branch can do that manually, after sent to HQ(Head Quarter), the HQ will import it using Business Object DI API you can use split in VB6 to help you array data or you can use XML Object in DI API.It's all up to you. This is just my opinion based on my experience solving the same problem that you get.
Thanks. Hope It can helps.
Regards,
Hamdi
Add a comment