Sage 100 Interface with

Looking for someone that has experience interfacing Sage 100 with via an ODBC connection.  I want to link the SO header table to, enter the SO number, then populate the fields using the header table fields (similar to what you do with UPS).  And to add icing to the cake, is it possible to write back weight and dollars to a csv file for importing.

I hope this isn't a big ask.