Hi Matt,
Yes absolutely. This is how most archiving solutions for JDE configure their "Archive" Environment.
Basically create a copy of your existing Prod environment's mappings for the new archive environment and then just add mappings for the specific tables that you want to point to the archive datasource.
Now there are some considerations to take when you have business views that go over master and detail tables and they are all not in the same datasource.
JDE has a limitation that the number of tables in a cross datasource join cannot be more than two. A very common business view used is F0901 , F0006 and F0911. In this case you might have the two masters F0901 and F0006 in your Production Data Datasource and F0911 in your Archive datasource. JDE will not be able to fetch from this business view in this case.
For master tables that are in such joins , what you can do is one of the two
- copy these masters also to the archive datasource and add OCM mappings ( and periodically refresh them)
- create a view (logical file) in the archive library pointing to the physical table in the Production Data library and add OCM mappings.
There are some other ways too to handle cross datasource join limitations , but the above should give you a general idea on how to proceed.