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.
Thanks in advance!