Application Programming Interface Guide > DSL API > Data Sources > System Tables
 
System Tables
There are 3 system tables under /services/databases/system/model directory, representing information about datasources:
ALL_DATASOURCES
ALL_RESOURCE_PROPERTIES
SYS_DATASOURCE_ATTRIBUTE_DEFS
ALL_DATASOURCES
The model.ALL_DATASOURCES table is similar to /services/databases/system/ALL_DATASOURCES, however, it includes both published as well as non-published datasources. It also includes an extra column "IS_PUBLISHED" that indicates if the datasource is published or not. Information about these columns can be viewed from the "Info" tab of the respective system table from Studio. The columns of this table are :
Column Name
TDV JDBC DataType
Nullable
Description
DATASOURCE_ID:
INTEGER
 
Identifier of the data source
DATASOURCE_NAME:
VARCHAR
 
Datasource Name
DATASOURCE_TYPE:
VARCHAR
 
Type of Datasource
ADAPTER_NAME
VARCHAR
 
Name of the Adapter
IS_PUBLISHED
VARCHAR
 
Identifies if datasource is published or not
GUID:
VARCHAR
 
128 bit unique identifier.
ANNOTATION
VARCHAR
Yes
Annotation for the data source
OWNER_ID
INTEGER
 
Identifier of the user who created/owns the data source.
OWNER
VARCHAR
 
User name of the person that owns/created the data source
PARENT_PATH
VARCHAR
 
Path to the parent container
DATASOURCE_CREATOR_ID
INTEGER
 
Identifier of the user who created this data source.
DATASOURCE_CREATION_TIMESTAMP
BIGINT
 
Timestamp when the data source was created.
DATASOURCE_MODIFIER_ID
INTEGER
 
Identifier of the user who last modified this data source.
DATASOURCE_MODIFICATION_TIMESTAMP
BIGINT
 
Timestamp of the last modification of this data source.
ADAPTER_TYPE_CATEGORY
VARCHAR
 
Adapter type category. Could be one of RELATIONAL, EXCEL_FILE, WEBSERVICE, REST, DELIMITED_FILE, XML_FILE, CJP.
ALL_RESOURCE_PROPERTIES
The columns of this table are:
Column Name
TDV JDBC Data Type
Nullable
Description
METADATA_ID
INTEGER
 
Primary key identifier of the table
PROPERTY_NAME
VARCHAR
 
Name of the property
DATA_TYPE
VARCHAR
 
Data type of the property
PROPERTY_VALUE
VARCHAR
 
Value of the property
SYS_DATASOURCE_ATTRIBUTE_DEFS
This table contains the datasource attribute definitions for all adapters. The information from this table could be used in the SET NATIVE PROPERTIES syntax of DSL API while creating datasources:
Column Name
TDV JDBC Data Type
Nullable
Description
ADAPTER_NAME:
VARCHAR
 
Name of the database adapter
ADAPTER_TYPE
VARCHAR
 
Type of the adapter
ADAPTER_TYPE_CATEGORY
VARCHAR
 
Adapter type category.
DEFINITION_NAME:
VARCHAR
 
Name of the attribute definition
DISPLAY_NAME:
VARCHAR
 
Display name used for this attribute definition
DEFINITION_TYPE:
VARCHAR
 
Type of the attribute definition
REQUIRED:
BIT
 
Indicates if the attribute definition is mandatory
DEFAULT_VALUE:
VARCHAR
 
Default value of the attribute definition
ALLOWED_VALUES:
VARCHAR
 
Allowed values for this attribute definition
EDITOR_HINT:
VARCHAR
 
Editor hint of this attribute definition
IS_ADVANCED
BIT
 
Indicates if the attribute is an advanced attribute
DISPLAY_PARENT_NAME
VARCHAR
 
Parent of the DISPLAY_NAME column
DEPENDENCY_EXPRESSION
VARCHAR
 
Indicates the attribute definition's "Depends on Item" and "Depends on Value”.
UPDATE_RULE
VARCHAR
 
Update rule. Could be one of READ_ONLY, READ_WRITE, WRITE_ON_CREATE,WRITE_ON_EDIT, WRITE_ON_IMPORT
ANNOTATION
VARCHAR
 
Annotation for the attribute definition
DEFINITION_PARENT_NAME
VARCHAR
 
Attribute definition's parent name usually prefixed with adapter name so as to resolve similar definition names in different adapters.