Tools for Creating Metadata for Source Data. Oracle Enterprise Manager uses CWM1 Write APIs. SQL*Plus and similar programs can be used to execute the CWM2 Write APIs.