Synonym Support for Oracle Database

To enable synonym support for an Oracle database, you must specify connectionproperties={includeSynonyms=true} in the Other Properties field for the adapter connection. For information about configuring connections, see Configuring Adapter for JDBC Connections.

The following table lists the adapter services and notifications that support synonyms.

Adapter Services	Adapter Notifications
SelectSQL	Basic Notification
DeleteSQL	Delete Notification
InsertSQL	Insert Notification
UpdateSQL	Ordered Notification
StoredProcedure	Stored Procedure Notification
	Update Notification

Consider the following limitations when using synonyms with adapter services:

If you want to use synonyms for stored procedures, you cannot use the StoredProcedureWithSignature adapter service. Use the StoredProcedure service instead.

The SelectSQL, DeleteSQL, InsertSQL, and Update SQL services support synonyms only for database tables and views.

For information about configuring adapter services, see Overview of Adapter Services. For information about configuring adapter notifications, see Overview of Adapter Notifications.