Moving from an import process of loading .csv files over to a direct connector

I'm not sure I understand the question, but it sounds like something you could solve with Derivative rules targeting the necessary intersections. You are not limited to allocating numbers once, with derivatives you can create new records. That, coupled with a sprinkle of code in Complex Expressions if you need to do custom calculations, will likely be able to accomodate anything you need.