This diagram is used to model the Databases, Tables, and ETL Jobs.
Data Architecture Toolbox
Data Architecture Toolbox
Package
EDB Schema – a DB Schema that does not belong to a specifc Business System but rather to the enterprise as a whole.
DB Schema – a DB Schema that belongs to a specific Business System. It should only be modeled if the DB Schema is accessed by components outside the Business System.
DB Interface – See (EA)<sup>2</sup> Data Architecture Toolbox.
ETL Job – a software component that extracts data from a DB Schema, translates the data and loads it into another DB Schema. The ETL Job may represent a script that is run by a generic ETL Tool or a custom program written for the specific ETL process.
Table – database table
Entity – conceptual piece of information
(EA)<sup>2</sup> DB Access Interfaces
Exposed interfaces used on applications, application components, and DB Schemas. The types of exposed interfaces are show below. How a DB Access Interface is implemented is shown by its name which is provided by the <<DB Interface>> elements that you create within your model. Examples of <<DB Interface>> elements you can create in your model include ODBC, and SQL.
R/O – access to the DB Schema is restrict to read only.
R/W – access to the DB Schema is both read and write.
ETL – this exposed interface type represents an ETL job that extracts data from one or more database tables, translates the data, and loads it into one or more database tables.
Exposed DB Interface – generic form of a DB Access Interface.
