Other
Specifies additional hidden properties for specific use cases., to be used only when our Support team advises it, to address specific issues. See Remarks for details.
Data Type
string
Default Value
""
Remarks
This property allows advanced users to configure hidden properties for specialized situations, with the advice of our Support team. These settings are not required for normal use cases but can address unique requirements or provide additional functionality. To define multiple properties, use a semicolon-separated list.
Note: It is strongly recommended to set these properties only when advised by the Support team to address specific scenarios or issues.
Integration and Formatting
| Property | Description |
| DefaultColumnSize | Sets the default length of string fields when the data source does not provide column length in the metadata. The default value is 2000. |
| ConvertDateTimeToGMT=True | Converts date-time values to GMT, instead of the local time of the machine. The default value is False (use local time). |
| RecordToFile=filename | Records the underlying socket data transfer to the specified file. |
OAuth Properties
| InitiateOAuth | Set this property to initiate the process to obtain or refresh the OAuth access token when you connect. The following options are available:
|
| OAuthSettingsLocation | The location of the settings file where OAuth values are saved when InitiateOAuth is set to true. When InitiateOAuth is enabled, the driver saves OAuth values to a settings file to avoid requiring the user to manually enter OAuth connection properties. When the user's OAuth session expires, the driver automatically obtains a new access token if InitiateOAuth is enabled.
If InitiateOAuth is enabled but OAuthSettingsLocation is not defined, the driver uses a default settings file, %AppData%\CData\PostgreSQL Data Provider\OAuthSettings.txt on Windows. On macOS, this file is located in ~/Library/Application Support/CData/PostgreSQL Data Provider/OAuthSettings.txt. On Linux, ~/cdata/.config. |
| OAuthAccessToken | The OAuthAccessToken is retrieved from the OAuth server as part of the authentication process. It has a server-dependent timeout and can be reused between requests.
The access token is used in place of your user name and password. The access token protects your credentials by keeping them on the server. |
| OAuthRefreshToken | The OAuthRefreshToken property is used to refresh the OAuthAccessToken when using OAuth authentication. |