Re: EBS R12.2.7 : Archiving and Purging tools reco ?

From: Biju Thomas <biju.thomas_at_gmail.com>
Date: Thu, 10 May 2018 22:37:28 -0500
Message-ID: <CAF9tyKoGQSwWnCPL=5AdOLEph2gLFKRfp4tzKg9_ezt_Y7MP6w_at_mail.gmail.com>



We have implemented Informatica ILM for EBS (formerly known as Applimation). The technology provides seamless access from EBS to archive data (controlled by EBS responsibilities), which makes it easier for the users as they do not have to learn a new tool or develop new reports. They can run the same report on the live data or archive data or both. Accessing both data is usually slower, as it tries a UNION between the live table and archive table (through db link). There is provision to bring data back to production system if there is a need.

Here is a white paper:
https://www.informatica.com/downloads/7050_ILM_OBES_wp_web.pdf

~Biju

On Thu, May 10, 2018 at 1:24 PM Bala <oratips_at_gmail.com> wrote:

> Gurus,
>
> Any recommendations or experience in implementing "Archiving and Purging"
> solution in EBS R12.2.7 running on Sun Solaris 11 ? --
>
> Any tools in the marketplace that are good ? ( we are for now using
> oracle supplied default purge programs with options).
>
> Thank you for your time.
>
> Best
>
>
> --
> Bala Rao
>

-- 
Best,
Biju Thomas
www.bijoos.com

--
http://www.freelists.org/webpage/oracle-l
Received on Fri May 11 2018 - 05:37:28 CEST

Original text of this message