I need to set up an ODBC link to a remote software program to pick up pricing information for the catalog.

Basically, they enter their inventory prices in another system and they want that to automatically update their website pricing as well. The software developer said we could do an ODBC link to their program and pick-up the pricing information automatically (i.e. real time).

Has anyone done this before? Any pointers on this?

Thanks,
Angel