• Sometimes, instead of returning an empty value, “Select * from table where columnname = 'value'” may throw an exception, if there is no value in the column.

• Some adapters support ORDER BY, but sometimes there are only a few objects within that data source that support ORDER BY. TDV displays a message if the tables do not support ORDER BY.

• Tables might need to be filtered with mandatory inputs for querying the contents for table scans to work as expected. For example for google apps directions, the starting location and ending location might be needed to retrieve the results.

• Sharepoint adapters support direct Kerberos authentication.

• Bulk inserts are not supported.

• GoogleSheets does not support client side filtering.

• Table names or column names with the period character are not supported.

• Eloqua data sources where the password value is entered when creating the data source will persist the password and it cannot be changed.

• For the Sharepoint Excel Services adapter, during introspection all String data types are mapped to VARCHAR.

• The DynamicsCRM, DynamicsNAV, DynanoDB, GoogleBigQuery, and SharePoint adapters do not support "is not null" syntax.

• Queries that contain "LIMIT"are not supported.

• For MongoDB, updating schema files within a running instance of TDV is not supported.

• Deployment Manager is case sensitive when using it with these adapters.

• Deployment Manager attributes for these adapters can cause plans to fail.

• “Ignore case sensitivity mismatch between CIS and data source” and “Ignore trailing space mismatch between CIS and data source” override the server side setting for a data source.
By default these two overrides are enabled so that queries are always pushed. This is the case even when there is a mismatch and the query does not contain UPPER or RTRIM or similar options.

• Set these attributes to false or disable the push to get the consistent results as when the query is run with in the TDV.