Hi,
For an Oracle DRM project I am currently working on we have the requirement that some of the hierarchies are sourced from an external system. As maintenance on this data remain in the external system, we will receive regular full snap shots of the data to be imported in to DRM. The format of the import files is a simple CSV structure. Every file will result into 1 hierarchy in DRM.
Functionally we want to achieve the following (via the batch utility):
1) Receive files in CSV format from external system at a weekly basis;
2) Create new version in DRM
3) In the new version remove the hierarchies and nodes and import the new files
My question is about the import of the CSV files. I believe there are two options:
(Option A) Convert the CSV files to ODRM import format (with the [version],[hierarchy] etc. headers) and import this data batch utility.
OR
(Option B) Convert the CSV files to Action Scripts and execute the script via the batch utility.
Both options require some ETL programming to transform the CSV to one of the two formats.
My question to you is: what would be the best approach to source CSV data into ODRM, option A or B? Or is there a cleverer approach to get CSV Files in to DRM on a regular basis?
Regards,
Marco