7.1 Work with Data Entities

A Data Entity is a tabular representation of a data structure.

It includes Database Tables or Views that can be used in a mapping as a source or target. They are simply the metadata for sources and targets. They are used in creating data flows.

You can add Data Entities to your newly created project in one of the following two ways:

• Importing Data Entities
• Creating Data Entities

All the newly created or imported Data Entities along with their details are displayed in the Data Entities page. The details include:

• Name of the Data Entity
• Connection for which the Data Entity was created
• Schema to which the Data Entity is associated
• Click the Actions icon () next to the selected Data Entity to perform the following operations:
  • Select Edit, to edit the existing details.
  • Select Preview, to preview the selected Data Entity. If the data entity belongs to an Oracle database, you can also view statistics of the table. See View Statistics of Data Entities for more details.
  • Select Delete, to delete the selected Data Entity.
• To delete the Data Entities in bulk, in the Data Entities page, select the check boxes of the respective Data Entities and click Delete.
• You can also search for the required Data Entity to know its details based on the following filters:
  • Name of the Data Entity
  • Connection for which the Data Entity was created
  • Schema to which the Data Entity is associated
  • Tag that is associated with the Data Entity