Data warehousing systems use a variety of data extraction and
cleaning tools, and load and refresh utilities for populating
warehouses. Data extraction from “foreign” sources is usually
implemented via gateways and standard interfaces (such as
Information Builders EDA/SQL, ODBC, Oracle Open
Connect, Sybase Enterprise Connect, Informix Enterprise
Gateway).