The problem:
I am about to develop a Drupal site for a company that stores a lot of data in a sharepoint environment (products, recipes etc...). I need to get that information into my Drupal system somehow. Preferably saving it as drupal nodes.
That information will also be edited/added in the sharepoint system, so on top of just saving the data to drupal it will also have to check for updates on a regular basis.

One idea for a solution is using some sort of web-service to retrieve data, but i have no idea of how that would be done in drupal.

So my question(s) is: Has anyone done anything like this, if so how, or does anyone have any suggestions to how one would go about doing this?

Any answers would be highly appreciated.

/Anders