1. System Administration Guide
  2. Data Sources

Data Sources

A data source is the specific location of data or distributed processing. EnterpriseOne data sources can be:

  • An entire database in a specific location, regardless of the type of database, such as a MSDE located in a specific directory or a library in DB2 for i.

  • A specific machine in the enterprise that processes logic.

The platform and data sources work together. You must define both the server that processes the logic and the databases that store the data. If multiple databases within one database management system (DBMS) reside on a machine, you must define each database to EnterpriseOne.

Do not confuse Microsoft open database connectivity (ODBC) data sources with EnterpriseOne data sources. The ODBC data source defines databases to various third-party communication products such as Client Access, Rumba, SQL Server, and MSDE. EnterpriseOne data sources define both databases and logic servers to EnterpriseOne.

This list describes EnterpriseOne data sources that you might use in the configuration:

Oracle DBMS

An EnterpriseOne data source for an Oracle DBMS points to an Oracle Connect String and a Table Owner.

Oracle OEE

An EnterpriseOne data source for an Oracle DBMS points to an Oracle Connect String and a Table Owner.

SQL Server DBMS

An EnterpriseOne data source for a SQL Server DBMS points to a SQL Server Database (ODBC data source) and a Table Owner.

DB2 for i DBMS

An EnterpriseOne data source for a DB2 for i DBMS points to a RDB directory entry and a Library (ODBC data source).

MSDE DBMS

An EnterpriseOne data source for a Microsoft Data Engine (MSDE) DBMS points to a MSDE database (OLBC data source).