After you create a data mediation profile and define the data feed and structure of the external data, you can import the data. You can import database profiles as needed and schedule them to occur at a later time.
You can import data from a file or from an Ingres, SQL Server, or Oracle database table. Data is loaded into database tables when imported.
The database tables created by Data Mediation include the following types:
Contains reference data to be used as lookup tables (usm_mr_iref).
Contains partial usage event data, meaning that all server mandatory fields are not present, implying that normalization may be necessary (usm_mr_itemp).
Contains complete usage event data (usm_mr_ievent).
Contains aggregated event data (usm_mr_iresult).
|
Copyright © 2013 CA.
All rights reserved.
|
|