ssis to transfer data from dynamic nav proplem

ahmedba

Hi guys i have dynamic nav 2009 r2 connected to sql server 2005 . in my company i have more branches A,B,C .Every branch has database .suppose i have also three database A,B,C same structures but different in data . A is main meaning Branch A is i want to collect data to it .can i use ssis to transfere data between branches(collect data from B,C database AND BUT IN A database) or this not possible

kine

It is not easy to answer. All depends on which data and what you want to do with them. DO not forget that SSIS is not calling any business logic in NAV (if you do not call NAV webservices from the SSIS). It means, if you collect data into some new, special purpose table, it could be ok. But collecting the data into some standard table, it is better to not do it.

E.g. some our customers are using SSIS to do financial consolidation, but the data are saved into special consolidation company in the DB to new table from where the reporting is done.

ahmedba

what i need is to take all data from tables from branches to main branch(all data meaning take data found only in tables )not view not stored procedure.if you have any way can achieve this task please give me.if from dynamic nav 2009 or sql server 2005 or any thing.
thanks

kine

It is not easy task and I recommend to consult this on proffesional level, not here on the forum. It looks like you want to consolidate everything together. E.g. just detail like Entry No. is problem (in all companies there is entry no. 10 - how you want to consolidate it into one table, when this is primary key?). It means, all depends on the purpose and the target you want to archive.