Table of Contents

Search

  1. Preface
  2. Introduction
  3. IDD Concepts
  4. Implementation Process
  5. IDD Configuration Manager
  6. Manual IDD Configuration
  7. IDD Global Properties
  8. Sizing and Platform Requirements
  9. Application Components
  10. IDD Security Configuration
  11. Data Security
  12. Example Role-Based Security Configuration
  13. Data Masking
  14. Siperian BPM Workflow Engine
  15. Locale Codes
  16. Troubleshooting
  17. Glossary

Data Director Implementation Guide

Data Director Implementation Guide

Informatica Data Director Global Properties Reference

Informatica Data Director Global Properties Reference

The following table lists global properties that control runtime behavior of all the Informatica Data Director (IDD) applications on a single Hub server.
The table describes each properties and its default value. These properties are stored in the CMX_SYSTEM.C_REPOS_DS_PREF_DETAIL table. If properties are not defined then the specified default values are used.
The application server must be restarted for changes to the following global properties to take effect.
Property
Default value
Usage
allowDsEmptyChildren
false
Determines if users can view child records when you configure a security filter on a grandchild column, but there are no grandchild records.
If
true
, users can view the child records when there are no grandchild records.
If
false
, users cannot view the child records when there are no grandchild records.
asyncChildLoading
false
Loads the child data in the Data View, when you explicitly open the child record of the primary object. You can set the property value to true to load the children data when you open the record in the Data View.
bulkexportloadsize
500
Maximum size of the load for each thread when you export data to a Microsoft Excel file. Default is
500
records. The maximum is
1000
records. If set to greater than
1000
, the default load size is used.
CompositePagerTotalRecords
500
Maximum number of ActiveVOS tasks that IDD sorts case-insensitively at a time. If tasks exceed the set value, IDD sorts ActiveVOS tasks according to the database type. If the database is Microsoft SQL Server, the sorting is case insensitive. If the database is Oracle or IBM Db2, the sorting is case sensitive.
convert2DigitYearTo4Digit
false
Enables the adjustment of a two-digit year entry to a four-digit year entry. Set to
true
to enable the adjustment of entered dates to 80 years before and 20 years after the current date.
For example, if you enter
1/Jan/30
as the date, IDD interprets the entry as January 1, 2030. If you enter
1/Jan/70
as the date, IDD interprets the entry as January 1, 1970.
credentialsAutofillDisabled
false
For security reasons, if you want to control user's browser from saving the login credentials such as username and password, you can set this value to 'true'.
CSVColumnSeparator
Comma (,)
Determines the character to use as a column separator when you export the data to a comma-separated values (CSV) file. You can also use a tab, semicolon, and space as a delimiter.
deleteMovedRelInExplorerView
true
Determines whether to delete the old relationship when you create a new relationship in Hierarchy Manager explorer view. Set to false to end-date the old relationship.
enableCreateBEMenuGrouping
false
Specifies whether you can define logical groups for the
New
window. Required if you have a large number of subject areas.
Set to
true
to define logical groups for the
New
window.
Set to
false
if you do not want to define logical groups for the
New
window.
enableRememberCredentials
true
When true, the Remember Me checkbox is displayed on the login page. Users remain logged in for the period determined by rememberCredentialsPeriod.
enableSaveForPeriodDialogForHmRel
true
Enables the effective period dialog box that appears when you update a Hierarchy Manager-enabled record in IDD. Set to
false
to disable the effective period dialog box.
enableTaskAttachments
false
Specifies whether users can attach files to tasks when using the legacy views with Data Director.
Set to
false
to disable attachments and to hide the
File Attachments
section in the
Task Details
dialog box and in the
Create Task
dialog box.
Set to
true
to enable attachments.
To see your change in the IDD application, use the IDD Configuration Manager to clear the IDD application cache.
expandDropDownListShowFullValue
false
Enables expansion of the drop-down list in the
Search
tab for lookup records. Set to
true
to allow the list to adjust to accommodate the longest list item.
exportusingmultithread
false
Enables multithreading for data export to a Microsoft Excel file. Set to
true
to enable multithreading for data export.
handleUserExitBeforeShowingDialog
false
Determines when IDD calls the SendForApprovalHandler user exit.
Set to
true
to have IDD call the SendForApprovalHandler user exit when the user clicks
Send for Approval
.
Set to
false
to have IDD call the SendForApprovalHandler user exit when the user clicks
Ok
from the
Send for Approval
dialog box.
HeaderBgColor
#000000
Specifies the HTML color code of the background color of the IDD header area.
hideSystemColumnsInResult
false
Specifies whether to show system columns in IDD search results. Set to
true
to hide system columns in IDD search results. When
true
, you can still customize the table view to manually select system columns to display.
hmInactiveRelationshipsAvailable
false
Set to
true
so the user can view inactive relationships in Hierarchy Manager.
IDD2COCSConverter.prefixCoNames
false
When the Informatica Data Director configuration is converted to a business entity configuration, determines if a prefixed subject area name is used for the business entity name.
Set to
false
to use the subject area name as the business entity name.
Set to
true
to use the subject area name prefixed with the Informatica Data Director application name as the business entity name.
isEffectiveDateIncluded
false
Specifies whether to include the Effective Date field for search queries in the Informatica Data Director.
Set to
true
to display the current date in the Effective Date field.
Set to
false
to hide the Effective Date field.
isFillOnGap
false
Specifies whether to enable the Fill on Gap property for operations in Informatica Data Director.
Set to
true
to enable the Fill on Gap property.
Set to
false
to disable the Fill on Gap property.
lookupCacheUpdatePeriod
300000 (5 min)
The number of milliseconds that lookup data can be in the IDD cache before it will be reloaded.
minModalWidth
1100
Determines the minimum width in pixels of the
Search
window.
maxCopiedChildrenNumber
10
Determines the maximum number of child records for each child type that are copied when a user copies a subject area.
maxCopiedGrandChildrenNumber
10
Determines the maximum number of grandchild records for each child type that are copied when a user copies a subject area.
maxImportThreads
5
Determines the maximum number of threads to use during data import.
maxParallelPromoteThreads
1
Determines the maximum number of threads to use when you approve a task.
When maxParallelPromoteThreads is greater than 1 and you promote records from multiple base objects, the promote process runs in parallel.
The maximum value of maxParallelPromoteThreads is equal to the number of server CPU cores.
maxParallellSavedQueriesThreads
true
Determines whether queries load through multiple threads. Multi-threaded queries load faster.
Set to
true
to enable multi-threading.
Set to
false
to disable multi-threading.
maxParallelBvtThreads
1
Determines the maximum number of threads to use when IDD loads a task to view.
maxSearchResultsExportedRows
5000
Maximum number of rows of search result data that will be exported.
maxXrefSearchReturnCount
100
Specifies the maximum number of cross-reference records that a search request returns.
needLoadChildOnOpen
false
Set to
true
to initially display only the parent records in the Matches view. Child records are displayed as you expand the child record tabs.
Set to
false
to initially display the parent records and all child records in the Matches view.
openDashboardAfterTaskClose
false
Set to
true
for Informatica Data Director to open the
Start workspace
after you complete any task.
Set to
false
for Informatica Data Director to open the previous tab in Data View after you complete any task.
overrideTextAreaColumnOrder
true
By default, if you configure a column as a text area in a subject area, the text area column always appears at the bottom of the layout regardless of column order.
Set to
true
to ensure text area columns in a subject area appear at the bottom of the layout regardless of column order.
Set to
false
to ensure text area columns appear in their specified order in a layout.
proactiveMatchResultSort
sortbyscorethenaction
Specifies the sort order in which the potential matches appear. Set to
sortbyscorethenaction
to sort by match scores and then by action. Set to
sortbyactionthenscore
to sort by action, such as open and import, and then by match scores.
qrytaskidfromprocessidtotalretry
2
Number of attempts that IDD makes to reload an ActiveVOS task. Set to a higher integer value if you use a user exit to handle ActiveVOS tasks and tasks are not appearing correctly in IDD.
qrytaskidfromprocessidwaitintrvlmillis
1000
Number of milliseconds that Informatica Data Director waits before attempting to reload an ActiveVOS task. Set to a lower integer value if you use a user exit to handle ActiveVOS tasks and tasks are not appearing correctly in IDD.
rememberCredentialsPeriod
24 (hours)
Length of time (in hours) that user credentials are remembered if the 'Remember Me' checkbox is selected.
samCacheUpdatePeriod
600000 (10 min)
Determines how long (in milliseconds) SAM roles (resources with privilege assignments) can be in the IDD cache before they will be reloaded.
serverPageSize
100
Affects paging of search results and child data. IDD displays to the user a page of 10 records. However, the number of records it fetches from the MDM Hub is determined by this property. With the default setting, IDD will not request additional data until the user goes to the 11
th
page of data.
search_empty_date
false
Determines if the effective date field in the search dialog box is empty or contains the Data view effective date when you create a child record.
Set to
true
to have an empty effective date field.
Set to
false
to have the Data view effective date populate the effective date field.
searchForDuplicatesBeforeTaskDialog
false
Determines if the
Potential Duplicates
dialog box appears before or after you send a task for approval.
Set to
true
to have the
Potential Duplicates
dialog box appear before the
Create Task
dialog box appears.
Set to
false
to have the
Potential Duplicates
dialog box appear after you click
Ok
from the
Send for Approval
dialog box.
shouldDisableSearchFieldIfDependentFieldAbsence
false
Enables or disables the dependent lookup field on the search form if the parent lookup field is not present on the search form or the parent lookup field has no value. Set to
true
to enable the dependent lookup field on the search form. Set to
false
to disable the dependent lookup field on the search form.
showMatchedColumns
#DBF5EC
Specifies the HTML color code of the color that identifies matched columns.
showShadowColumns
true
Specifies whether to show shadow columns in the Cross-reference view. Set to
true
to show shadow columns. Set to
false
to hide the shadow columns.
subjectAreaCopyDisabled
false
Determines if users can select Copy from a subject area Actions menu to copy a subject area.
Set to
true
disable the option to copy a subject area.
Set to
false
to allow the option to copy a subject area.
table_default_width_key
-1
Determines the percentage minimum width of search result columns.
tableMaxColumns
25
Determines the number of columns that are visible in the table view of child records and grandchild records. The default value allows for 20 visible columns and 5 hidden columns. To ensure that you have visible columns, specify an integer >5.
tabsExpandByDefault
n/a
Determines which child records are expanded by default in the data view.
To expand child records by default in the data view, specify the name of each subject area separated by a comma. To expand the
XREF
tab by default, specify
xref
. To expand the
Relationships
tab by default, specify
hm_relationship
.
For example, to expand the XREF tab, the Ship Address tab, and the Organization tab by default, specify
xref, ShipAddress, Organization
.
If you do not set a value for tabsExpandedByDefault, no child records are expanded by default in the data view.
threadSchedulerIdleTime
5000 (seconds)
Determines the maximum thread scheduler idle time.
transactionTimeout
30 (seconds)
The number of seconds that transactions have to complete execution before timing out.
updateExistingPeriodByDefault
false
Determines if the Update existing period checkbox is enabled by default.
Set to
true
to enable by default.
Set to
false
to disable by default.
writeBOM
false
Exports Informatica Data Director search results as a CSV file using UTF-8 encoding with a byte order mark. If the search contains extended ASCII characters, set writeBOM to
true
to see valid data when you open the CSV file.

0 COMMENTS

We’d like to hear from you!