Sample Adapter Settings

The following table shows the Adapter Area settings used by some of the adapters shipped with Oracle Life Sciences Data Hub.

You can see all settings for the shipped adapters in CDR_ADAPTER_AREAS_V.

Note:

The system treats No and Null the same way.

Table 4-2 Sample Adapter Settings

Column Name	Oracle Tables and Views Load Set Adapter	Text Load Set Adapter	SAS Load Set Adapter	SAS Data Mart Adapter	Generic Visualization Business Area Adapter
OBJ_VER	1	1	1	1	1
ADAPTER_NAME	ORACLE_DATABASE	Text	SAS	SAS EXPORT	GENERIC_VISUALIZATION
ADAPTER_VERSION	1	1	8.2	1	1.0.1.2
ADAPTER_TYPE	LOADSET	LOADSET	LOADSET	DATAMART	BUSAREA
TECHNOLOGY_TYPE_ID	(Generated)	(Generated)	(Generated)	(Generated)	(Generated)
ALLOW_COLUMN_UPLOAD	YES	NO	File	NO	NO
COLUMN_UPLOAD_FUNCTION	CDR_ATK_OracleDB_Services.UploadColumns	Null	CDR_ATK_SAS_Services.UploadOperatorColumns	NO	Null
ALLOW_MANUAL_TAB_DESC_FLAG	YES	YES	YES	YES	NO
AUTO_ADD_TAB_DESC_LOV	CDR_ATK_OracleDB_Services.CreateMultipleOperators	NO	NO	NO	NO
ALLOW_AUTO_ADD_TAB_DESC	YES	NO	NO	YES	NO
AUTO_ADD_TAB_DESC_FUNCTION	CDR_ATK_OracleDB_Services.GetDataOperList	Null	Null	NO	Null
CURRENCY_FUNCTION	Null	Null	Null	NO	Null
DEFINE_TIME_FUNCTION	CDR_ATK_OracleDB_Services.CreateLogFilePlannedOutput	CDR_ATK_Text_Services.CreateLogFilePlannedOutput	CDR_ATK_SAS_Services.CreateLogFilePlannedOutput	CDR_ATK_DM_SAS_SERVICES.createPlannedOutput	Null
DEFINE_TIME_CONNECT_FLAG	YES	NO	NO	NO	NO
INSTALL_TIME_CONNECT_FLAG	YES	NO	NO	NO	NO
RUNTIME_CONNECT_FLAG	YES	NO	NO	NO	NO
TABLES_AS_VIEWS_FLAG	YES	NO	NO	NO	NO
TABLES_AS_VIEWS_FUNCTION	Null	Null	Null	NO	Null
ACTIVE_FLAG_RC	$YESNO$YES	$YESNO$YES	$YESNO$YES	$YESNO$YES	$YESNO$YES
DEF_PARAM_FLAG_RC	$YESNO$YES	$YESNO$YES	$YESNO$YES	$YESNO$YES	$YESNO$YES
RUN_PARAM_FLAG_RC	$YESNO$YES	$YESNO$YES	$YESNO$YES	$YESNO$YES	$YESNO$NO
TD_PARAM_FLAG_RC	$YESNO$YES	$YESNO$NO	$YESNO$NO	$YESNO$NO	$YESNO$NO
STATUS_RECALC_FUNCTION	Null	Null	Null	CDR_ATK_DM_SAS_SERVICES.synchronizeDatamart	Null
SECURITY_RECALC_FLAG_RC	$YESNO$NO	$YESNO$NO	$YESNO$NO	$YESNO$NO	$YESNO$NO
SECURITY_RECALC_FUNC	Null	Null	Null	Null	Null
INSTALL_SCHEMA_FLAG_RC	$YESNO$YES	$YESNO$NO	$YESNO$NO	$YESNO$NO	$YESNO$NO
INSTALL_SCHEMA_SUFFIX	Null	Null	Null	Null	Null