We are in the process of working on getting our people records updated with the latest from our org store. Is it possible to do a direct import into the database or will it need to be done through the data exchange?
I would say, that the only way is data exchange. Creating new records in the database is next to impossible, because the method to generate OIDs is not known. Updating data is possible but not recommendend and not supported by hp.
Though the only option is data exchange but what you can do is updating that data using scripts..You can define the import and export scripts for data updates and run those scripts using windows scheduler.This is what we have done during LDAP integration.