How to increase column size limit for Active Directory(AD) data source in TIBCO Data Virtualization?
Article ID: KB0076907
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | 7.0.8, 8.x |
Description
In Active Directory (AD) data source, by default the string type column size is 2000 characters. It can be verified by looking at AD data source table's columns in TDV. This article explains the process of increasing this column size.
Issue/Introduction
Resolution
There is a property called 'DefaultColumnSize' that can be set via 'Other' configuration in AD data source to override the default column size. It allows to specify the column size, e.g. "DefaultColumnSize=3500;". This parameter sets the default length of string data type columns for AD data source when the data source does not provide column length in the metadata.
Steps to add the 'DefaultColumnSize' configuration:
-
Open the Active Directory data source.
-
In the Connections configuration window, navigate to 'Other' property. Then add "DefaultColumnSize=3500;" in 'Other' property and save the changes.
-
After adding that property, delete the table(s) (or all resources) under the AD data source. You can use 'Add/Remove Resources' operation for the same.
-
Now add the deleted (or required) resources again to AD data source using 'Add/Remove Resources'.
-
Verify the table column size and now it should show value 3500.
Note: Value 3500 is just an example, any char limit can be used in configuration 'DefaultColumnSize' based on the requirement.
Feedback
