Synching SharePoint 2013 List with Oracle
<p>I'm having an issue where a customer wants to populate a SharePoint 2013 List with a data from Oracle (using a query) and have that List automatically synched with the Oracle database daily.</p>

<p>From my understanding the External Content Type is just a direct view of the external database pulled in real-time to SharePoint? What if in the SharePoint the user adds more data for the External List? When the External List is refreshed, will the key/id relationship (if any) exist in the External List so that user entry will map to the correct External List entry (with the data from Oracle)?</p>

<p>How should I go about any Oracle data synchronization with any List in SharePoint automatically? What are the ways I should go about doing this?</p>