We have a large database of 20,000+ items on a local database that we need to get into Sharepoint Online 2013 in O365 to use as metadata for various documents in multiple locations. New entries and changes need to be synced into the choice list. Can anyone offer some insight on the best way to accomplish this?
1) BCS External Content Type: but how to get past the 2000 item throttle limit?
2) Managed Metadata: manual updates only? This offers the best functionality but seems like a nightmare to administer.
3) 3rd party tool? Still subject to 5000 throttle limit?
4) Use a JQuery data table and a custom edit form to "select" from an xml extract of the database and inject it into a text field (however this would not apply any "updates" if data changes).
I am at my wits end in seeing how this might be possible in O365.