Data providers are the software components that allow the client - in this case Office SharePoint Designer 2007 - to communicate with the database.
Each database management system was unique, and each had its own programming language for accessing and updating data.