Smart cities

A city needs a new reporting service to access selected records from an older departmental system. Which integration method is generally preferable to repeatedly copying data by hand?