Search code examples
oracle11gsap-commerce-cloudhybris-data-hub

SAP Hybris6.2 Database Tables Structure in Oracle11g

I have just connected the Hybris 6.2 to Oracle 11g Db. In the Sql developor i can see all the tables, however due to large number of table its been hard to find things. I found a table called CMSComponent but unable to find CMSParagraphComponent,CMSImageComponent , MiniCartComponent in it. Is it in some other table? More so if i create a new Component or any exisiting, where are they stored in database table?

Please any help is appreciated in understand the Hybris database structure!

Solution

  • I found a table called CMSComponent but unable to find CMSParagraphComponent,CMSImageComponent , MiniCartComponent in it. Is it in some other table?

    To check where all instance of current ItemType stores

    Go to HMC/BackOffice > System > Type > Search for your type and select it from result > go to extended tab > check for Table attribute value

    enter image description here

    If I create a new Component or any existing, where are they stored in database table?

    <deployment table="tableName" typecode="20005" />

    The deployment tag is used to define database table while declaring itemType. So if you define deployment tag for your custom type then it's all instances will be stored in define table otherwise it will be stored in it's parent itemtype(defined using extends attribute). By default all itemType extends GenericItem so if you don't declare extends attribute for your itemsType it will be stored in genericitems table (declared for GenericItem)

    Remember

    • A deployment table must be defined for all Items extending GenericItem
    • A deployment table must not be defined for any Items extending any item other than GenericItem

    Refer to this wiki for more detail example

    Please any help is appreciated in understand the Hybris database structure!

    Refer this post, explaining hybris database structure in detail