If a user connects to AX 2012 using a standard SQL connector and decides to switch to the Dynamics Finance provider, the switch is implemented as a cloning. This cloning does unfortunately not “remember” the selected tables and fields in the original data source … effectively preventing the provider switch in larger solutions.
It would be nice with an option to retain all metadata (including keys, incremental rules, etc.) when cloning a data source … also when it’s a standard cloning and not a provider change.