WCS | Dataload Utility | Catalog Dataload | Mediator List

If you wanted to use the WebSphere Commerce Dataload utility, it expects the input source as CSV or XML file. If your Datasource is neither of these, then you need to write custom data reader for  reading the source and mediators for pushing the data to WCS tables.

If your target tables are standard Catalog tables, then you can use OOB mediators itself and no need to write explicit mediators. Here are the common mediators, which are used as part of Catalog dataload,

Type: Catalog Groups

OOB Mediator : com.ibm.commerce.catalog.dataload.mediator.CatalogGroupMediator

Tables Affected :

   CATGROUP
   SEOURL
   SEOPAGEDEF
   STORECGRP
   CATGRPDESC
   CATTOGRP
   CATGRPREL
   CATGPCALCD

Type : Attribute Dictionary

OOB Mediator : com.ibm.commerce.catalog.dataload.mediator.AttributeDictionaryAttributeMediator

Tables Affected :

   ATTR
   ATTRDESC
   SRCHATTR
   SRCHATTRPROP
   ATTRDICTSRCHCONF
   FACET 
   ATTRVAL
   ATTRVALDESC

Type : Catalog Entries

OOB Mediator : com.ibm.commerce.catalog.dataload.mediator.CatalogEntryMediator

Tables Affected :

   SEO
   BASEITEM
   BASEITMDSC
   STOREITEM
   ITEMVERSN
   DISTARRANG
   VERSIONSPC
   STORECENT
   CATENTDESC
   CATGPENREL
   LISTPRICE
   CATENTSHIP
   CATENTSUBS
   CATENCALCD

 

Type: Catalog Entry Attribute Dictionary Attributes

OOB Mediator : com.ibm.commerce.catalog.dataload.mediator.CatalogEntryAttributeDictionaryAttributeMediator

Tables Affected:

   ATTRDICT
   ATTRVAL
   ATTRVALDESC
   CATENTRYATTR

Type: Catalog Entry Merchandising Associations

OOB Mediator : com.ibm.commerce.catalog.dataload.mediator.CatalogEntryAssociationMediator

Tables Affected :

   MASSOCCECE

Type : Attachment Assets

OOB Mediator :  com.ibm.commerce.content.dataload.mediator.AttachmentMediator

Tables Affected :

   ATCHTGT
   ATCHTGTDSC
   ATCHAST
   ATCHASTLG

Type : Offer & Offer Prices

OOB Mediator : com.ibm.commerce.price.dataload.mediator.OfferMediator

Tables Affected :

    OFFER
    OFFERDESC
    OFFERPRICE