And if you wanted to stay with tools you may already have (if you have ITSM 7.6.04 and AI), you could utilize Pentaho (http://kettle.pentaho.com/) and transform in that manner.
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of David Ferguson Sent: Tuesday, September 11, 2012 2:09 PM To: [email protected] Subject: Re: Remedy archiving ** Thanks Ananth for the clarification. Yurbi has a built-in component called Yurbi Connect, leveraging the easy to report feature I mentioned at the DB level the Yurbi Connect portion allows you to extract data, transform it (if needed), and load it into a new set of tables (ETL). So there still may be a fit for what you need. You can build any set of queries you need from the DB to extract the form data and then re-loaded it into any Oracle or SQL database you would like to build your archive. http://www.yurbi.com/solutions/data-integration-software/ thanks, David On Tue, Sep 11, 2012 at 4:00 PM, Anantha Jeyaprakash <[email protected]> wrote: ** Hi David, Thanks for your info. We want to archive data from our Incident form. Our incidents are growing and we decide to move our old data to archive forms. Remedy has OOB Archive feature, but that is very limited (only form level), not application level. Thanks, Ananth On Tue, Sep 11, 2012 at 12:16 PM, David Ferguson <[email protected]> wrote: ** Hi Ananth, I am not 100% clear on what you mean when you mention integrate the archive data in Remedy 7.5 so my answer may be off-base but hopefully it will help you or someone else. We find a lot of our customers leverage Yurbi to report, data mine, search their archived Remedy data because Yurbi accesses the Remedy data at the database layer, you don't need to have the application running. This works great in archive situations. And there are a lot of integration opportunities with Yurbi and Remedy 7.5/7.6. For example, you can integrate reports/dashboards so that any Stakeholder can still access and search the archive data. You can create integrated dashboards/reports combining archive data with LIVE data from the current system. You can even start to integrate data from non-Remedy systems like a phone system or 3rd party inventory, financial, etc, systems. You can learn more about Yurbi for BMC Remedy here - http://www.yurbi.com/solutions/bmc-itsm-remedy/ Let me know if I can be of more assistance, David On Tue, Sep 11, 2012 at 1:06 PM, Anantha Jeyaprakash <[email protected]> wrote: ** Team, We want to archive Remedy ITSM data. Is there a tool available (other than OOB Archive) to integrate in Remedy 7.5/ ITSM 7.6. Thanks, Ananth _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ -- David A. Ferguson Yurbi(r) - Bring Your Data to Life <http://www.yurbi.com> Work: 571-354-0515 Fax: 703-991-5935 Email: [email protected] http://www.linkedin.com/in/davferg http://www.twitter.com/davferg5000 5000fish, Inc. <http://www.5kfish.com> 2850 W. Horizon Ridge Parkway Suite 200 Henderson, NV 89052 <http://www.linkedin.com/in/davferg> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ -- Cheers, Ananth _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ -- David A. Ferguson Yurbi(r) - Bring Your Data to Life <http://www.yurbi.com> Work: 571-354-0515 Fax: 703-991-5935 Email: [email protected] http://www.linkedin.com/in/davferg http://www.twitter.com/davferg5000 5000fish, Inc. <http://www.5kfish.com> 2850 W. Horizon Ridge Parkway Suite 200 Henderson, NV 89052 <http://www.linkedin.com/in/davferg> <http://p1.wisestamp.com/pixel.png?p=chrome&v=3.9.10.0&t=1323900400670&u=4deb2d080c4ca423> <http://p1.wisestamp.com/pixel.png?p=chrome&v=3.9.10.0&t=1324008406507&u=b1b2fbb30c4ca423> _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
