I can only describe techs used on my part. SSIS MS SQL, C#/.net MS Office. In a certain case all intersect.

Due to NDA, details are not allowed

Complex thread controlled Unit task row digestor, expanding into a data parcel ingestor with file cluster property.

Dates are estimates, it was a long term effort. Project interfaced and was called directly under AutoDesk AutoCAD, to bring up a custom window, use that window to gather a form of specifications, then draw ing to the current instance accoring to the data given.