You can use the following properties to configure automatic data type detection, which is enabled by default.

TypeDetectionScheme: You can use this property to enable or disable automatic type detection based on the value specified in RowScanDepth.

RowScanDepth: This property determines the number of rows that will be scanned to determine column data types.

The adapter enables the granular control useful in more complex integrations or network topologies; for example, connecting from behind a firewall. In this section you can find more advanced adapter configurations, as well as steps to troubleshoot connection errors.