[rt-users] RT - Data Warehouse?

[Torsten Brumm]

Hi,

ok, this is the very first version, but stable. Its not nice, but we have
separated systems, so we have to extract the values (the changed ones) and
ftp them to the datapool.

we are using the sh scrip from cron at this moment, but if we have moved
from mysql to oracle, we can do this in real time.

It is important, that you use BO for this, the ftp scrip is putting thi into
a internal ftp at this moment and from there it will be grabbed from
anoither scrip and putted into a BO universe

OK, if you have further question, ask me ;-)

PS: Jesse don't like this way of getting Reports :-)


2006/9/1, Roy El-Hames <rfh at pipex.net>:
>
> If you don't mind can you also send them to me, we will be implementing
> reporting via Business Objects fairly soon , and your scripts will be
> useful.
> Kind regards;
> Roy
>
> Torsten Brumm wrote:
> > Hi Stephen,
> >
> > yes, we have. We put all the data from RT DB to Business Objects and
> > do the
> > reporting there. If you like, i can sent you the scrips for that
> >
> > Torsten
> >
> > 2006/9/1, Stephen Turner <sturner at mit.edu>:
> >>
> >> Hello,
> >>
> >> Has anyone moved data from an RT system to a data warehouse for
> >> reporting purposes? If so, would you be willing to share your
> >> experiences? I'm interested in the design of the warehouse data
> >> structures, particularly how to accommodate custom fields.
> >>
> >> Thanks,
> >> Steve
> >>
> >> Stephen Turner
> >> Senior Programmer/Analyst - Client Support Services
> >> MIT Information Services and Technology (IS&T)
> >>
> >>
> >> _______________________________________________
> >> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> >>
> >> Community help: http://wiki.bestpractical.com
> >> Commercial support: sales at bestpractical.com
> >>
> >>
> >> Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> >> Buy a copy at http://rtbook.bestpractical.com
> >>
> >
> >
> >
> > ------------------------------------------------------------------------
> >
> > _______________________________________________
> > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> >
> > Community help: http://wiki.bestpractical.com
> > Commercial support: sales at bestpractical.com
> >
> >
> > Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> > Buy a copy at http://rtbook.bestpractical.com
>
>


-- 
MFG

Torsten Brumm

http://www.torsten-brumm.de
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20060901/e699fed2/attachment.htm>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: extract.sh
Type: application/x-sh
Size: 1136 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20060901/e699fed2/attachment.sh>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ext_customfields.sql
Type: application/octet-stream
Size: 411 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20060901/e699fed2/attachment.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ext_objcustomfieldvalues.sql
Type: application/octet-stream
Size: 422 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20060901/e699fed2/attachment-0001.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ext_queues.sql
Type: application/octet-stream
Size: 424 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20060901/e699fed2/attachment-0002.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ext_tickets.sql
Type: application/octet-stream
Size: 552 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20060901/e699fed2/attachment-0003.obj>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ext_users.sql
Type: application/octet-stream
Size: 686 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20060901/e699fed2/attachment-0004.obj>