INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

cross universe and database reporting - Discuss

cross universe and database reporting - Discuss

(OP)
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.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close