A key struggle of data integration at an enterprise level can be summarized by the Last Mile Problem, which is often used to describe the large increase in difficulty and cost of transporting physical goods from distribution centres to customers. Data sitting in corporate databases faces a similar reality – different user segments will have different requirements of said data. The data, therefore, needs to be transformed and blended before it can be useful.
Using FME and FME Server, we can streamline and automate business logic to shorten that ‘last mile’ between data centres and business applications. In this talk, we will cover the typical life cycle of a ‘last mile’ ETL and the organizational cultural changes that can supercharge improvement efforts.