I am looking to import data from a Relational SQl Server Database that is hosted externally by a 3rd Part vendor. My task is to import all the data that is entered by the external customers into the Sharepoint lists. The external users are presented with a free form Registration page where they enter their data. For the internal users, we want to pull that data in real time and display in lists.
So inother words as soon as the data is entered on the form and user submits it, the database and the sharepoint list should reflect changes simultaneously. That is all the changes need to be replicated in real time on the content database from the external SQL database.
Please give direction as to how can this possible.