The Surveyor General Branch of NRCan uses FME to automate their workflows, running them overnight without intervention.
By the time they arrive for work in the morning, FME has pulled together data from diverse datasets across the country, de-normalized database information for business intelligence, and identified all the errors that have spilled into the databases the previous day. They use FME Desktop to create the workflows and to automate sending success/failure details.
Using FME, they produce KML files for Google Earth, DWG files for AutoCAD, Shape files for many users, keep web applications up-to-date, and provide data to map services.
The Surveyor General Branch (SGB) of National Resources Canada (NRCan) operates dynamic data from 48 databases in 32 projections with 60,000 features in SHP, ArcSDE, DWG, and SQL Server.