0

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!!

Improve this question

2 Answers 2

Reset to default
1

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

Improve this answer
5
  • can you provide some reference as well please :) Commented Nov 9, 2012 at 9:03
  • Don't have any reference tho... cause its more like try and see thing :) Commented Nov 9, 2012 at 10:29
  • ah right, I just wanted to read a bit more about it as its sounds quiet interesting and usefull Commented Nov 9, 2012 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!! Commented Nov 12, 2012 at 13:12
  • No problem, here to help! :) Commented Nov 12, 2012 at 14:59
0

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

Improve this answer
2
  • 1
    Quite irrelevant answer brother! Commented Nov 8, 2012 at 23:37
  • true, but I tried to search on topic and find that irrelevant information but thanks for correcting me :) Commented Nov 9, 2012 at 9:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.