Share this page

# PPM_ODATA_LINKS

This table stores the OData links 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.

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: