BW Data Archiving in BI

Former Member · ‎11-16-2007

Hello Gurus!!!!

I just want to know the future of BW Data Archiving in BI as its new technology................. Kindly explain .................

Points would be rewarded for helpful answers

Thanks,

Aryayn

Former Member · ‎11-16-2007

answered

Former Member · ‎11-16-2007

hi aryan,

Archiving is playing a major part in bi. so in future it has to be there and grow the with different technologies.we can't simply omit this in future. if u want to know more about it's operational aspects and future. please check the following pdf.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/342cba90-0201-0010-0d99-ab4bfb86...

if it's not responding means. refresh the screen. it will show.

regards

harikrishna N

former_member187400 · ‎11-16-2007

Hi Aryan,

In my oppinion, BW data archiving has a good future, because you can save your space from your BW Server (after archiving, system will delete the data too).

And after you've archived, then if your user someday need the data, you can make it by restore.

You also can combine the data between data that has been archived w/ the new data.

Here some document link(s) :

http://help.sap.com/saphelp_45b/helpdata/en/8d/3e4e81462a11d189000000e8323d3a/frameset.htm

http://help.sap.com/saphelp_nw04/helpdata/EN/8d/3e4f1d462a11d189000000e8323d3a/frameset.htm

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/b32837f2-0c01-0010-68a3-c45f8443...

Hopefully it can helps you a lot.

Regards,

Niel.

(Many thanks for any points you choose to assign).

Former Member · ‎11-16-2007

hi,

Archiving is possible in BI 7.0 also (here we can do by Information Life Cycle Management ).

Some notes on archiving:

Data Archiving – a service provided by SAP NetWeaver – removes mass data that the system no longer needs online, but which must still be accessible at a later date if required, from the database.

Generally large amounts of database data is produced in the production system of a business application, which often times is reflected in a deterioration of system performance and an increased use of resources. Costs can also be negatively affected by large data volumes, since resources and efforts spent on database administration go up as a result.

Therefore, data from closed business processes, meaning data that is no longer needed in every day business processes, should be moved out of the database, in order to gain a reduction in costs, and improve performance and system availability. Simply deleting this data is often not a valid option, due to legal data retention requirements. This means that the data has to be removed from the database and stored in such a way that it is always accessible for reading if necessary. This is the task of SAP Data Archiving, which allows you to removed data from the database and store it in a consistent and secure manner. The archived data is stored in a file system and from there can be moved to other, more cost efficient storage media.

Data archiving is an administrative task that must be performed regularly, particularly if you are facing fast growing data volumes. How often you archive largely depends on the growth rate of your database tables.

The technological foundation of data archiving is located in the SAP NetWeaver Application Server and is available in two different variations:

• ADK-based Archiving - ADK-based archiving is used only by ABAP applications that employ ABAP archiving objects in their data archiving projects.

• XML-based Archiving - XML-based archiving is employed for XML archiving objects that are used by ABAP applications with XML interfaces, and for archiving sets used by JAVA applications.

Also please check this link for more information on this

http://help.sap.com/saphelp_nw2004s/helpdata/en/8d/3e4c11462a11d189000000e8323d3a/frameset.htm

Check out this

http://help.sap.com/saphelp_nw04/helpdata/en/e8/df7e3c6f5ee42be10000000a114084/content.htm

There is a How-to guide on archiving which gives you a step by step on the process.

See link below:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/c05da82c-e36e-2910-27bd-abb7c1bc...

Please check the below urls also

https://www.sdn.sap.com/irj/sdn/advancedsearch?cat=sdn_all&query=archiving&adv=false&sortby=cm_rnd_r...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/b32837f2-0c01-0010-68a3-c45f8443...

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/documents/a1-8-4/sap%20bw%...

This thread may help you.