5
Understanding Data Sources
5-1
5
Understanding Data Sources
This chapter contains the following topics:
Section 5.1, "Data Sources"
Section 5.2, "Required Data Source Types"
Section 5.3, "Database Structures"
Section 5.4, "System Data Source Connections"
Section 5.5, "System Table Caching"
5.1 Data Sources
The data sources define where the database tables reside and where the software runs
logic objects for the enterprise. Data sources can point to:
A database in a specific location (for example, a local database, such as E1Local
located in \E900\data, or an IBM i data library, such as PRODDATA)
A specific machine in the enterprise that processes logic
Data source definitions are stored in the Data Source Master table (F98611).
Workstations use a Common table F98611, which generally resides in the system data
source on the enterprise server. Oracle's JD Edwards EnterpriseOne servers that
process logic and request data require their own unique definitions for data sources;
therefore, they have their own table F98611 in the server map data source.
A least two sets of table F98611 exist. They reside in a centralized system data source
normally kept on an enterprise server which is accessed by workstations, and in a
server map data source, which each logic server requires.
5.1.1 Data Source Types
Data sources are the building blocks that you use to set up an enterprise configuration.
Data sources define all the databases and logic machines required by the Oracle JD
Edwards EnterpriseOne configuration. Each database and machine in the enterprise
must be defined as a data source for JD Edwards EnterpriseOne to recognize it.
There are two types of data sources:
Database Data Sources
A database is a grouping of tables in a database management system. You must
identify databases to the applications that access them. You can distribute databases
across a network and involve various servers and database management systems. A