Hi I just wanted to get idea's from people how they handle cross universe reporting, and also to get any possible idea's of alternate ways of doing this.
The scenario is that we have 3 universes with various number of databases on each representing various countries for example.
My problem is I need to represent to the stakeholders different ways which we can report accross universes and have a global snapshot of data to report off.
idea 1
1 solution is getting all the data required onto 1 box by using union quieries (across databases in the same universe) and then FastExport to create a file to feed into fastload so I can get the data to a new database which I create to store the Global data. I would need to somehow, eventually automate this to allow easy maintanace and updates. most probably using VBA. Not sure what issues I will come across as I have not used FastExport or FastLoad before although I have a basic understanding of it.
idea2
use sql server and linked servers.. ie linking all 3 universes to sql server. I have experience of linked server reporting but only linking one sql server to another, though I understand you can link Teradata as a linked server too.
I would be interested in hearing any other possible routes or idea's to explore and would be greatly appreaciated.
How have you guys dealt with similar projects? I would be interested to hear any pro's and cons or issues or benefits etc you came across. etc etc
I am trying to come up with different routes which the company can use for handling the project so anything which you think may be worth pointing out would be appreciated.
Any questions please let me know.
The scenario is that we have 3 universes with various number of databases on each representing various countries for example.
My problem is I need to represent to the stakeholders different ways which we can report accross universes and have a global snapshot of data to report off.
idea 1
1 solution is getting all the data required onto 1 box by using union quieries (across databases in the same universe) and then FastExport to create a file to feed into fastload so I can get the data to a new database which I create to store the Global data. I would need to somehow, eventually automate this to allow easy maintanace and updates. most probably using VBA. Not sure what issues I will come across as I have not used FastExport or FastLoad before although I have a basic understanding of it.
idea2
use sql server and linked servers.. ie linking all 3 universes to sql server. I have experience of linked server reporting but only linking one sql server to another, though I understand you can link Teradata as a linked server too.
I would be interested in hearing any other possible routes or idea's to explore and would be greatly appreaciated.
How have you guys dealt with similar projects? I would be interested to hear any pro's and cons or issues or benefits etc you came across. etc etc
I am trying to come up with different routes which the company can use for handling the project so anything which you think may be worth pointing out would be appreciated.
Any questions please let me know.