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 |
