IBM BPM, V8.0.1, All platforms > Authoring services in Integration Designer > Services and service-related functions > Access external services with adapters > Configure and using adapters > IBM WebSphere Adapters > Oracle E-Business Suite > Overview of IBM WebSphere Adapter for Oracle E-Business Suite > Technical overview

Tables, views, and synonyms overview

The Oracle database provides the common database objects such as tables, views, synonyms.

Table is a common database schema object in a database. The table objects are used to store data in the database. Oracle provides a number of table types for entering data into the database such as object, normal, nested, clustered, index-organized. Data can be entered into the database table either directly or through the Oracle open interface tables. The Oracle open interface tables interface between two systems. These tables import data from one system, validates data, identifies errors if any, and transfers the valid data to the Oracle base tables appropriately.

View is a database object that is considered as a virtual table or a stored query. Views do not store the data physically in them; instead they derive the data from the base table on which they are created. All the operations that are performed on the tables can be performed on views too.

Synonym is an alias or an alternative name given for the database objects such as the tables, views, and other database objects.

Technical overview of IBM WebSphere Adapter for Oracle E-Business Suite