Large amount of attachment and non-attachment data ( close to 60k Items, boms , Mfg and Mfg parts) have to be extracted out of Agile .
Large amount of attachment and non-attachment data ( close to 60k Items, boms , Mfg and Mfg parts) have to be extracted out of Agile.
Consultant needs to be develop Agile SDK custom jobs to export these data out of Agile in the format ( or template ) supported by different PLM
Does it need to be done all at once, or a bit at a time?
If you want to extract smaller sets of data, then an SDK app could be the way to go. If you need the entire set of data all together, using PL/SQL would probably be more efficient. You can do the smaller data sets using PL/SQL scripts as well, but you have to have a good criteria by which to then pick and choose the objects you need at that time.
I am very familiar with the Agile schema, and I have a set of scripts that are intended to extract data into tables approximating the load tables. From there, it can be reformatted and output into the format(s) you need.