× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Group,

Sorry I was not very clear on my request. We rum BPCS, as well as several other ERPs, on several platforms. We are looking at some way to save the data and have it accessible / usable after we migrate off the ERP as well as off the supporting platform. We are currently looking at ETL (Extract Transform and Load) tools (Data warehouse tools kind of fall in this category) that cover multiple platforms.
Thanks to all that responded.

Bill



-----Original Message-----
From: bpcs-l-bounces+bill.moy=invensys.com@xxxxxxxxxxxx [mailto:bpcs-l-bounces+bill.moy=invensys.com@xxxxxxxxxxxx] On Behalf Of Milt Habeck
Sent: Monday, July 12, 2010 5:09 PM
To: BPCS user group
Subject: [BPCS-L] Archive BPCS data outside of the AS400 / iSeries / IBM i

< vendor >
Good afternoon ...



I spoke with our technical staff to make sure I understood the concept of "de-normalized
format." Maybe I'm the only one on the BPCS BBoard who didn't immediately know what that
meant .... but in case there is another person on the BBB like me, here's what I learned:

Vanilla BPCS is in "3rd form" normalization, which is the most common data storage

approach we've found on the IBM i. Basically that means that the files don't carry
redundant data. For example, the BPCS vendor master file carries information about
the vendor but the A/P invoice file only carries the vendor number which refers
back to the vendor master rather than storing redundant information (e.g. vendor's
name, address, etc.)



"3rd form" normalization also means that a single record would not carry groups
of like data; each of those occurrences would be it's own record. For example,
there is a separate order line file with one record for each order line rather
than an order file with 25 fields for item and another 25 fields for price, etc.


Now, a de-normalized format archiving strategy would summarize and maybe consolidate
information for historic reference. To illustrate, perhaps a company wants to summarize
sales history by item and date rather than keeping all the order line detail.



So, to us, Bill's request reads like a project to populate a data warehouse with a format his

enterprise would find most useful. That sounds like an assignment for reporting software

which has Cognos-like functionality.



I wish we could sell you our made-specifically-for-BPCS or ERP LX archiving software called
Locksmith ( www.unbeatenpath.com/software/locksmith/archiving.pdf ), but the result of
that product is archived records that have precisely the same database structure as the
production files. The records are removed from the production libraries and written to an
archiving library where they can be accessed for historical information or saved to tape
for removal from the IBM I.



Warm regards,

Milt Habeck

Unbeaten Path

(888) 874-8008

+(262) 681-3151

www.unpath.com



< /vendor >







Date: Thu, 8 Jul 2010 12:50:17 -0500
From: "Moy, Bill"
To: "bpcs-l@xxxxxxxxxxxx"
Subject: Archive BPCS data outside of the AS400

Fellow Users,

I have been asked to research / find software that will archive BPCS
data in a de-normalized format for historic Analysis/audit purposes.
They would like to store access it outside of BPCS, and off the AS400.
Does anyone know of a product that would accomplish this?

Thanks in advance

Bill Moy
Business Systems Analyst
Invensys Controls
191 E. North Avenue
Carol Stream, IL 60188
T 1.630.260.3303 M 1.630.715.9401
F 1.630.260.3280 E Bill.Moy@xxxxxxxxxxxx
www.InvensysControls.com



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.