Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I would like Sharepoint to present the content of a view from another server. There is no need to modify the data, but sorting would be nice.

Can I accomplish this without (too much) coding?

share|improve this question
    
What do you mean by "other server"? Is it another SharePoint or something else? –  Toni Frankola May 20 '09 at 13:44

3 Answers 3

You have a few options:

  1. Run custom code in SharePoint that connects to the database and queries the information. This could be a custom webpart or a new page that you put in the _layouts folder.
  2. Instead of connecting to the database directly, you could publish the data using a web service or an RSS feed. That way, you don't have to worry about a DB connection. You could connect to this using a Content Editor webpart and custom JavaScript.

Those are just two options--there are others. Really, it depends a lot on what you need to do. For example, should any SharePoint user be able to see the data pulled from the database? How are you going to handle security? Are there dozens of rows you're pulling from the database or millions?

Anything you do will require some amount of coding.

share|improve this answer
    
+1. Totally spaced on the web service idea. –  vinny May 20 '09 at 14:24

Off the top of my head, you could use reporting services on your SharePoint box to present the data, if you're running SRS. Alternately, you could dig into the business data catalog (BDC):

http://msdn.microsoft.com/en-us/library/ms563661.aspx

The latter assumes you're running MOSS 2007.

share|improve this answer

As i understand you just want to fetch data from another database, may be of SqlServer. If this is the case you can simply use SPD to accomplish your task.

Open SPD, Create a new DataSource, and connect to your desired database, and table/view. then go to the page where you want to display the data inside SPD. Edit page in normal mode, place cursor at the place where you want to display the data and goto Insert > Data View > (and select your desired source from DataBase connections)

It should be done.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.