Hello Mike Brady,
Please check the article Customizing Modules -> Adding Providers in the User Manual. It pretty much explains what the purpose of several providers is.
You can have more than one provider for a given module. Each provider is associated with connection string. Once you add another provider to the application, you will see a drop down in the corresponding module, which will allow you to select with whose provider you are working with.
the Telerik team