Configuring FCC_CM_STUDIO Table

2.6.1 Configuring FCC_CM_STUDIO Table

Update the FCC_CM_STUDIO database table in ECM by replacing the placeholders with the user-specified values to integrate Investigation Toolkit with ECM.

The following table describes the placeholders that must be replaced with the required values, which will replace the corresponding rows in the FCC_CM_STUDIO database table.

Note:

The keys DATA_STUDIO_URL, DATA_STUDIO_API_VERSION, DATA_STUDIO_SSO_TOKEN, GRAPH_SERVICE_URL, and DATA_STUDIO_DOMAIN_NAME are mandatory. The remaining keys are optional, and some have default values assigned. Optional parameters should be updated only when necessary.
During an upgrade, the username and password parameters in the FCC_CM_STUDIO table are deprecated and replaced by the DATA_STUDIO_SSO_TOKEN value.

Table 2-2 FCC_CM_STUDIO Table Details

N_ID	V_KEY	V_VALUE	Description
1	DATA_STUDIO_URL	##DATA_STUDIO_URL##	Data studio URL.
1	DATA_STUDIO_URL	##DATA_STUDIO_URL##	https://<FULLY QUALIFIED HOSTNAME OF CS>:<DATASTUDIO PORT NO>/cs. For example, https://testserver.com:7008/cs
2	DATA_STUDIO_API_VERSION	##DATA_STUDIO_API_VERSION##	Data studio API version. Replace placeholder to 20230913
3	DATA_STUDIO_SSO_TOKEN	##DATA_STUDIO_SSO_TOKEN##	Data studio API token
4	GRAPH_SERVICE_URL	##GRAPH_SERVICE_URL##	Graph service URL
			https://<FULLY QUALIFIED HOSTNAME OF CS>:<GRAPH SERVICE PORT NO>/graph-service
			Ex: https://testserver.com:7059/graph-service
5	DATA_STUDIO_SYSTEM_ADMIN_USER	MMGUSER	Data studio system admin user.
5	DATA_STUDIO_SYSTEM_ADMIN_USER	MMGUSER	Default value: MMGUSER
6	DATA_STUDIO_SYSTEM_ADMIN_ROLE	DSUSRGRP	Data studio system admin role.
6	DATA_STUDIO_SYSTEM_ADMIN_ROLE	DSUSRGRP	Default value: DSUSRGRP
7	NOTEBOOK_NAME_PATTERN	ECM Case {CASE_ID} Notebook	Notebook name pattern. {CASE_ID} is replaced with case id value.
8	CASE_FIRST_PARAGRAPH_TITLE	Case Details	First Paragraph title name of ECM IH template notebook
9	FL_HIDE_TOOL_BAR_ACTIONS	TRUE	Flag to hide tool bar actions in notebook. Accepts Values: TRUE or FALSE
10	FL_HIDE_ADD_PARA_ACTIONS	TRUE	Flag to hide add paragraph action in notebook. Accepts Values: TRUE or FALSE
11	FL_HIDE_PARA_ACTIONS	FALSE	Flag to hide paragraph actions in notebook. Accepts Values: TRUE or FALSE
12	FL_HIDE_PARA_CODE	TRUE	Flag to hide paragraph code. Accepts Values: TRUE or FALSE
13	FL_EXEC_PRE_PROC_REFRESH_CASE	TRUE	Flag to execute pre -procedure in refresh case. Accepts Values: TRUE or FALSE
14	FL_EXEC_POST_PROC_REFRESH_CASE	TRUE	Flag to execute post procedure. Accepts Values: TRUE or FALSE
15	DURATION_AUTH_TOKEN_RENEW	PT3H	Duration for renewal of auth token. Default value is PT3H. The auth token will be refreshed every 3 hours.
16	DURATION_NOTEBOOK_ACTIVITY_STEP	PT1M	Duration for notebook activity step. Default value: PT1M. for every 1M. we track notebook activity
17	DURATION_NOTEBOOK_ACTIVITY_INTERVAL	PT10M	Duration for notebook activity interval. Default value: PT10M. Next request to track notebook activity is will be after this duration from last activity duration.
18	DURATION_NOTEBOOK_ACTIVITY_MAX_SLEEP	PT3H	The max duration to wait before verifying the activity in the notebook.
18	DURATION_NOTEBOOK_ACTIVITY_MAX_SLEEP	PT3H	Default value: PT3H
19	ACTIVE_USER_COUNT	200	Active user count.
20	FL_TRACK_ACTIVITY_IN_NOTEBOOK	TRUE	Flag to track activity in notebook. Accepts Values: TRUE or FALSE
21	FL_LOG_TRACK_ACTIVITY_IN_NOTEBOOK	TRUE	Flag to log tracked activity in notebook. Accepts Values: TRUE or FALSE
22	FL_CACHE_IH_CONFIGURATION	FALSE	Flag to cache IH configurations. Accepts the value TRUE or FALSE.
22	FL_CACHE_IH_CONFIGURATION	FALSE	If the value is set to TRUE, all the configurations fetched initially will be cached.
23	FL_LOG_NOTEBOOK_REST_DETAIL	FALSE	Flag to log notebook rest detail. Accepts the value TRUE or FALSE.
24	N_DB_CONNECTION_TRY_COUNT	5	Connection try to DB before timeout
25	N_DB_CONNECTION_WAIT_MILLIS	1000	Wait time for connection setup.
26	DURATION_HTTP_READ_TIMEOUT	PT2M	http read duration timeout
27	DURATION_HTTP_CONNECTION_TIMEOUT	PT2M	http connection timeout
28	FL_MASK_NOTEBOOK_REST_RESPONSE	FALSE
29	DATA_STUDIO_DOMAIN_NAME	##DOMAIN_NAME##	Domain name where datastudio is installed
30	DATA_STUDIO_COOKIE_NAME	ORA_OLDS_SESSION	Cookie name, this name cookie will be saved in browser while logging in.
31	LB_DATA_STUDIO_STICKY_COOKIE_NAME	ORA_OLDS_TEST	Sticky cookie name while load balancer is active
32	FL_LOAD_BALANCED_STUDIO	FALSE	Flag for load balancer active or not
33	NO_OF_LOAD_BALANCER_INSTANCES	2	No of load balancer instances
34	INTERPRETER	java	Default interpreter for notebook.
35	CODE_CASE_INIT	out.println(caseId);	Case initialization code snippet for the default interpreter.
36	CODE_UPDATE_CASE	ihub.initializeVisibleGraph(visible_graph); out.println(generateUpdateCaseButtonOutput());	Case update code snippet for the default interpreter.