Update Feature Class Attributes Automatically

Discussion created by ModernGIS on Oct 25, 2012
Latest reply on Oct 26, 2012 by ModernGIS
    I am working on a work-flow process that will automatically update the attributes of a specific feature class from a scheduled python script that will run overnight. Here is what I am trying to accomplish:

Feature Class: Service Locations (Electric Meter Locations with account, meter and location data stored in our CIS system.)
    I currently have a python script the pulled the data from our Oracle System and produces it into a Geodatabase table that sits in the same geodatabase as the Service Location feature class. What I need to do is to take the individual fields from the table and update the fields in the feature class.

This is what I have done:
    I made a data model through model builder to 1) Make a Feature Layer 2) Add Join 3) Calculate Field (Update the feature class field with the same field from the data table.

Problem is - when I run the data model or the script - it takes a LONG time. The one script I build and tested only have 7 fields (so 7 Calculate Field processes) and it took about 4 hours to run.

Is there an easier way to do this?

Thanks in advanced