PPM_ODATA_LINKS

This table stores the OData liks that are available in PPM.

Foreign Keys

This table has no foreign keys.

Column Descriptions

Column Name Null? Data Type Description
URL_KEY NOT NULL VARCHAR2(50) Unique random key generated for the OData Link. Used in the URL to identify the link. This is the primary key.
DESCRIPTION NULLABLE VARCHAR2(2000) Description of the OData link.
NAME NULLABLE VARCHAR2(200) Name of the OData link.
ODATA_DATA_SOURCE_ID NOT NULL NUMBER ID of the OData data source that this OData link points to.
ODATA_CONFIG NULLABLE CLOB JSon configurations of the filters that are sent to the data source for the OData link.
ACCESS_COUNT NOT NULL NUMBER

Number of the times that the OData link was called to retrieve data.

Note that importing data only once in Excel or PowerBI will result in multiple calls to the OData link as metadata has to be retrieved in separate calls, which are all counted.

LAST_ACCESSED_ON NULLABLE DATE Date when the OData link was last used.
CREATED_BY NOT NULL NUMBER ID of the PPM user who created the OData link. When using the OData link, the data will be retrieved by this user.
CREATION_DATE NULLABLE DATE Date when the OData link was created.
EXPIRATION_DATE NULLABLE DATE

Expiration date of the OData link.

Not used at this point. No effect on the OData link.

ENABLED_FLAG NOT NULL VARCHAR(1) Whether the OData link is enabled (‘Y’) or not (‘N’ or any other value). A disabled OData link cannot be used to retrieve data.

Indexes

This table has no indexes.

Sequences

This table uses no sequences.