Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I hope I am putting this question in the right place because this is more of a content then code question.

I am new to making external list, so my question is, will the external list I have connected to my SQL database table update itself with the new data put into the database, or will I have to run some type of a timer job or something to update the external list. I need to be able to grab data in real time ( if possible ) from my database and load it into the external list.

Is there a way to do this? Also, what would be the best practices to do so?

Thanks!!

share|improve this question
add comment

2 Answers 2

up vote 1 down vote accepted

External Lists are updated runtime, all data is sync and there is no need to run any job/service to sync data between External List and your SQL database!

Its just a PAGE REFRESH will be needed if the page was already open :)

So either you add data from SharePoint Form or any other resource to database, they both are sync... Because each time you open External List view, it actually gets data from database, it has no local storage/cache anywhere else!

If you want that page remains open and new data is shown [to make it feel real time].. you can put simple javascript to reload the page every X seconds...

I hope this helps

share|improve this answer
    
can you provide some reference as well please :) –  Muhammad Raja Nov 9 '12 at 9:03
    
Don't have any reference tho... cause its more like try and see thing :) –  Arsalan Adam Khatri Nov 9 '12 at 10:29
    
ah right, I just wanted to read a bit more about it as its sounds quiet interesting and usefull –  Muhammad Raja Nov 9 '12 at 10:37
    
Great that is what I needed to know and what I kinda figured. Like I said, newbie here on External List and their functionality :) Thanks a bunch!! –  lazoDev Nov 12 '12 at 13:12
    
No problem, here to help! :) –  Arsalan Adam Khatri Nov 12 '12 at 14:59
add comment

EDIT

External Lists are actually updated runtime, all data is sync and there is no need to run any job/service to sync data between External List and your SQL database as said by Arsalan Adam Khatri

share|improve this answer
    
Quite irrelevant answer brother! –  Arsalan Adam Khatri Nov 8 '12 at 23:37
    
true, but I tried to search on topic and find that irrelevant information but thanks for correcting me :) –  Muhammad Raja Nov 9 '12 at 9:03
add comment

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.