You could use partitions, but since you have only 1 data source this would mean setting up linked servers, which I would try to avoid (performance wise).

You would also have to resolve the issue that you have conflicting customer IDs.