Mike
We offer several ways of updating the data
And new records
add new records update old records
update records
The data synchronization strategy depends on number of factors
Amount of data in source tables Amount of updates performed daily Level of access you have for the source system Workload of the source system
If source tables are very small you can just copy all data every day
for larger tables you need to be able to identify which records were updated since last synchronization
In some cases it might be required to modify source source schema
For example you may add last_modification field and use it as filter
select * from table where last_modification<current_date-1
or you may write a trigger to populate logging table
It all all depends whether you have enough user rights to do it or whether you can do it without performance implications
Anyway sky is the limit
Peter
