Aarto
Reputable Poster
Extract/export millions of records from several tables to "external" database
Hi all!
A customer has divested some business units (JDE companies) that have been live for years in JDE XE. There are millions of records in F0911, F4211, F4311, F4111 (Especially F0911 is huge) which the customer must make available to the party that acquired the concerned business units
One year of F0911 has about 1 million records for one of the JDE company codes and we are talking about 4 companies for which data has to be made available (Each of these is a unique KCOO)
- The file format created from this extract should be a database format or possible to import to a database since it must be possible to query the data
- It must be possible to export a pre-defined set of tables (not all tables are required) but if the tool has logic to extract all data relevnt to the affected company codes then it is a plus
- There is no requirement to purge this data from JDE XE. It should be possible to extract the data without purging (but purging option wuld be nice, of course)
- The JDE XE instance is running on AS/400 using db2
I'm looking for any tips / tools / techniques and success stories that we could benefit from in order to make this happen by mid-may this year
With kind regards
Aarto
Hi all!
A customer has divested some business units (JDE companies) that have been live for years in JDE XE. There are millions of records in F0911, F4211, F4311, F4111 (Especially F0911 is huge) which the customer must make available to the party that acquired the concerned business units
One year of F0911 has about 1 million records for one of the JDE company codes and we are talking about 4 companies for which data has to be made available (Each of these is a unique KCOO)
- The file format created from this extract should be a database format or possible to import to a database since it must be possible to query the data
- It must be possible to export a pre-defined set of tables (not all tables are required) but if the tool has logic to extract all data relevnt to the affected company codes then it is a plus
- There is no requirement to purge this data from JDE XE. It should be possible to extract the data without purging (but purging option wuld be nice, of course)
- The JDE XE instance is running on AS/400 using db2
I'm looking for any tips / tools / techniques and success stories that we could benefit from in order to make this happen by mid-may this year
With kind regards
Aarto