Configure Simple Properties
Properties on the first several Configuration subtabs are collectively called “simple properties” because they have just one value. They let you specify a value data type, allowable values, and an adapter-specified value.
The fields for data type and allowed values are grayed out for properties defined by TDV because they should not be modified by the user. When you add a custom property, such fields are enabled for that custom property.
Value Data Type
When you add a custom property, you can assign it one of the following data types:
— STRING
— PASSWORD_STRING
— BOOLEAN—implicit allowable values are true or false
— DOUBLE
— FLOAT
— LONG
— INTEGER
— FILE_PATH_STRING
— PATH_STRING
— FOLDER
Allowed Values
Type a comma-separated list of the allowable values for this property.
Property Value
Type a value for this property. This becomes the default value for any data source instance that uses this adapter.
Some properties have a value already specified, some do not. If the group-level flag, or the flag for this property overriding it, has a value of True for Data source must specify value, the property value needs to be specified in the data source.
When a data source is created, it inherits the current value of the property as defined by the adapter. At that point the inheritance ends: if the adapter changes the value of this property later, the change is not propagated to the data source. Even if the data source sets the value to empty or NULL, the effective value for that data source will be empty or NULL.
If you specified allowable values, the value you type for this property must be one of those values. If this is not the case and you try to save the adapter configuration, an error message box appears and the configuration is not saved.
Configuring the MPP Engine
You can use the “Simple Properties” in the Overrides tab to assign a value for the MPP Engine property “Concurrent Request Limit”. If concurrentRequestLimit is set to 0, then partitioned queries will not be issued against the data source and the query engine will not operate in parallel mode against the data source. For any value greater than 0, the query engine will throttle concurrency to X number of concurrent connections, where concurrentRequestLimit=X.
Note: This property can only be set for the data sources that currently support MPP Engine. For a list of data sources that support MPP Engine, refer to the TDV Users Guide, Chapter Configuring the TDV Massively Parallel Processing Engine.