Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>If I understand you correctly, you should create BDC Model. In such a case Sharepoint will call your custom methods (which get external data) and you can see it in Sharepoint external list.</p> <p>You can start here: <a href="http://msdn.microsoft.com/en-us/sp2010devtrainingcourse_businessconectivityserviceslab_topic4.aspx" rel="nofollow">http://msdn.microsoft.com/en-us/sp2010devtrainingcourse_businessconectivityserviceslab_topic4.aspx</a></p> <p>Also you can watch this video: <a href="http://msdn.microsoft.com/en-us/vstudio/ff623022.aspx" rel="nofollow">http://msdn.microsoft.com/en-us/vstudio/ff623022.aspx</a></p> <p>If it is not enough, just let me know and I'll try to help you in more details.</p> <p><strong>UPDATE1:</strong> If it is a mandatory case that all this software should work on the client side. I can see two ways (in both you don't need to use additional SP dll's on the client side): </p> <ol> <li>Use BDC model as I suggested above, but model will be only a proxy to code in client and code from this model will make calls to the client side (using WebServices for example). In such a case when user needs new data (by clicking on external list for example) SP makes call to your code in BDC model, which makes call to the client machine. In other words, initiator of getting data is SP and sequence looks like: <strong>User -> SP -> BDC model -> Client Data.</strong></li> <li>You can create custom WebService in SP to update its lists when your client needs it. In such a case, your client received new data and it get to know it must update it in SP. After this it makes call through your custom WebService on SP side, which adds new data to SP using SP object model. In other words initiator of update is client side. Sequence looks lile: <strong>Client data -> custom SP WebService, which updates this data on SP side.</strong></li> </ol> <p>In the first case you can organize caching on SP side (for example, make calls to client not often than once a day).</p> <p>But you have to notice that when you have a lot of data, replicating it in the SP (using the second way) usually is not a good idea and it can take additional efforts to manage it (when to update, what data is already updated, what if part of data is updated and other isn't in time when user gets it he will get inconsistent data and so on).</p>
    singulars
    1. This table or related slice is empty.
    1. POHow can I load external data in Bdc Service
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USMikhailSP
    1. USMikhailSP
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow can I load external data in Bdc Service
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COThank for answer, but i have throubles with this solution. In **SharePoint Customization Wizard** must be entered local site address to debugging, i don't have any site in my machine, i have only site on another computer. There are any ways to do that? Or i should create site on my machine?
      singulars
      1. PO
      1. USPopov Sergey
    2. COAs far as I know, you should have Sharepoint installed on machine where you develop a solution for it (where Visual Studio installed, not exactly on machine where production SP installed). Because installation of SP is not so simple task you can use Sharepoint Easy setup script: http://www.microsoft.com/en-us/download/details.aspx?id=23415
      singulars
      1. PO
      1. USMikhailSP
    3. COOk, suppose i installed all requirements, but software which i am working should work on our client's machine's. Where client should be get required Dll's to work with our software? Should he install Sharepoint Server also?
      singulars
      1. PO
      1. USPopov Sergey
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload