Access external data from sharepoint list, best practice.

busapps
busapps used Ask the Experts™
on
Hi,

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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Hey,

This you can achieve in 2 ways,

1) using Sharepoint object model
2)using sharepoint webservices.

Basically, you have to write a program/Componet, which will talk to sharepoint list using either object model or webservices. read the content and dump into your db. If you need more help let me know.

Thanks,
Arun
Top Expert 2010

Commented:
if the other data is in SQL, why import it to sharepoint?  you can just display it in sharepoint using Data View web part.

unless you have a specific need to *import* it.

Author

Commented:
Hey Arun,

Could you provide some more information as to how to do either of the steps or may be an article for reference. Also now does that replicate instantaneously into the other DB.
How to Generate Services Revenue the Easiest Way

This Tuesday! Learn key insights about modern cyber protection services & gain practical strategies to skyrocket business:

- What it takes to build a cloud service portfolio
- How to determine which services will help your unique business grow
- Various use-cases and examples

Author

Commented:
Hi Zephyr ,
The sharepoint database is used by internal users and is manipluated by them as per their needs. The SQL at remote location primarily servers for storing the data for the external customers, so we cannot have the same DB.

Thanks
Ritu
Hi,

Add sharepoint list webserive as a webserive reference, then create an instance of the same, using the listname you can call GetListItems() web mehtod which returns xml.

Thanks,
Arun
Commented:
Hey Arun,
I want to invoke a service that runs once a day and returns an XML parsed DataView from the remote server :
Inorder to parse the XML I am looking to use a tool called Moss BDC Design Studio. However I need a secured  connection to the remore server to have access to the data . Any suggestions as to how can I access it safely over the internet.

Once done we want to also have the functionalituy to sych the data from the sharepoint list. Any suggestions on this too would be greatly appreciated.

Thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial