I used a replicated view once in a similiar situation.

basically set up a view on your database that has the same name as the table on the ms erp database, ...