RT - Data Warehouse?

RT Users
1

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)

2

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

Torsten2006/9/1, Stephen Turner sturner@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)

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@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

3

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:

4

We also use Business Objects here at $work. Could you please send the
scripts to me as well? Or even better, put them on the wiki. :slight_smile:

Thanks,
DrewFrom: rt-users-bounces@lists.bestpractical.com
[mailto:rt-users-bounces@lists.bestpractical.com] On Behalf Of Torsten
Brumm
Sent: Friday, September 01, 2006 12:03 PM
To: Stephen Turner
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT - Data Warehouse?

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@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@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
5

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 :wink:

PS: Jesse don’t like this way of getting Reports :-)2006/9/1, Roy El-Hames rfh@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@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)

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@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

extract.sh (1.11 KB)

ext_customfields.sql (411 Bytes)

ext_objcustomfieldvalues.sql (422 Bytes)

ext_queues.sql (424 Bytes)

ext_tickets.sql (552 Bytes)

ext_users.sql (686 Bytes)

6

putted it to the list ;-)2006/9/1, Drew Taylor DTaylor@cidc.com:

We also use Business Objects here at $work. Could you please send the
scripts to me as well? Or even better, put them on the wiki. :slight_smile:

Thanks,
Drew

From: rt-users-bounces@lists.bestpractical.com [mailto:
rt-users-bounces@lists.bestpractical.com] *On Behalf Of *Torsten Brumm
Sent: Friday, September 01, 2006 12:03 PM
To: Stephen Turner
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] RT - Data Warehouse?

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@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)

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@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

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@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