Attempting to achieve
I'd like to be able to populate the data in an entity from a SQL table. It's for a list of buildings. This information should be updated regularly.
Things tried
I tried using a dataflow but it seems like no matter what I tried, it would wipe out the data and replace it. This breaks every lookup field that uses the entity.
How are people accomplishing this in their environments?