Datahub tables

[Former Member]

Hi Experts,

I am using Datahub with hsql. I want to understand which tables are created by datahub in hsql so that I can connect to hsql and retrieve the data which is stored for canonical/target model.

[Slava]

Here is the list of tables with regards to the features you requested:

• CanonicalItemMeta - contains canonical item types

• CanonicalAttrDef - canonical item attributes and their mapping to raw types

• CanonicalAttrModDef - canonical attribute characteristics, e.g. localized, collection, etc

• TargetSystem - definition of target systems for publications

• TargetItemMeta - definition of target item types

• TargetAttrDef - target item attributes

I think those should be enough for understanding metadata only.

[Former Member]

Hi ,

Thanks for the info.

1) May I know which .data file I need to connect to view these tables and what i the path for the same? I tried connecting to hybris .data file i.e. hybris\data\hsqldb\mydb.data but this does not contain the tables which you have mentioned.

2) It will be great to know the tables where actual item data is stored.

[Slava]

DataHub uses its own database. In your comment you refer to the ECP database. My recommendation would be to look into DataHub's local.properties and get connection properties from there.

The items are stored in CanonicalItem and TargetItem tables.

[Slava]

Here is the list of tables with regards to the features you requested:

• CanonicalItemMeta - contains canonical item types

• CanonicalAttrDef - canonical item attributes and their mapping to raw types

• CanonicalAttrModDef - canonical attribute characteristics, e.g. localized, collection, etc

• TargetSystem - definition of target systems for publications

• TargetItemMeta - definition of target item types

• TargetAttrDef - target item attributes

I think those should be enough for understanding metadata only.