Share this page

# PPM_ODATA_DATA_SOURCES

This table stores the OData data sources that are available in Self-Service Portlet.

## Foreign Keys

This table does not any foreign keys.

## Column Descriptions

Column Name | Null? | Data Type | Description
--- | --- | --- | ---
ODATA_DATA_SOURCE_ID | NOT NULL | NUMBER | System generated identifier from sequence PPM_ODATA_DATA_SOURCES_S
SQL_DATA_SOURCE_REFERENCE_CODE | NULLABLE | VARCHAR2(200) | The reference code of the Dashboard SQL data source if this OData data source gets data from a SQL data source. NULL if it is getting data from a Java data source.
JAVA_DATA_SOURCE_CLASS_NAME | NULLABLE | VARCHAR2(200) | Full Java class name of the data provider class if this OData data source gets data from a Java data source. NULL if it gets data from a SQL data source.
REFERENCE_CODE | NOT NULL | VARCHAR2(200) | Reference code
ODATA_ENTRY_SET_NAME | NULLABLE | VARCHAR2(200) | Name of the OData EntitySet that will hold the records at the root of the Service
ODATA_SERVICE_NAME | NOT NULL | VARCHAR2(200) | Name of the OData service (in the OData URL). It must be unique.
NAME | NOT NULL | VARCHAR2(200) | Name of the OData data source.
DEFINITION_LANGUAGE | NULLABLE | VARCHAR2(40) | Definition language of the OData data source
DESCRIPTION | NULLABLE | VARCHAR2(400) | (Optional) Description of the OData data source

## Indexes

Index Name | Index Type | Sequence | Column Name
--- | --- | --- | ---
PPM_ODATA_DATA_SOURCES_IX1 | UNIQUE | 1 | ODATA_DATA_SOURCE_ID
PPM_ODATA_DATA_SOURCES_IX2 | UNIQUE | 2 | REFERENCE_CODE
PPM_ODATA_DATA_SOURCES_IX3 | UNIQUE | 3 | ODATA_SERVICE_NAME

## Sequences

Sequence Name | Sequence Type
--- | ---
PPM_ODATA_DATA_SOURCES_S | ODATA_DATA_SOURCE_ID

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: