Customizing Extract, Transform and Load (ETL) processes

After the replication is setup the WebSphere Commerce Analyzer will replicate data from the WebSphere Commerce database, into staging tables on the WebSphere Commerce Analyzer server, when you run the replication. The ETL process moves the data from IWH schema in the data mart to WCA schema in the data mart, which can be accessed by the WebSphere Commerce Analyzer to view reports.

There are two tasks involved for customizing the ETL process:
1. Create a new data mart table in the WebSphere Commerce Analyzer
2. Customizing the ETL process.

Related tasks

• Customizing the WebSphere Commerce Analyzer