I need to pull a report consisting of order, profile and pricing details on a daily basis (for a month). So I've to query the core and the cata databases (we use DB2 here) for getting these details.
I know this can be done easily by setting up a federation and have talked to the DBAs about this. However,I'm starting to think if this will impact the way ATG is setup. I want to make sure this will not cause any issues.
Let me know if anybody has ever done this or is aware of any issues that might arise.