Using Pass-through Optimization with SQL Server Data Source Clients
Pass-through optimization affects DATE, DATETIME, DATETIME2, MONEY, SMALLDATETIME, SMALLMONEY, and TIME data types in Microsoft SQL Server data sources. The default value of Pass Thru Optimizations is true. To take advantage of this optimization for 6.1.0.1 JDBC clients, leave it set it to true. For pre-6.1.0.1 JDBC, ODBC and ADO.NET clients, set it to false.
To set pass-through optimization for SQL Server data source clients
1. Log into Studio as the admin user.
2. From the Administration menu, choose Configuration.
3. In the tree pane, navigate to Configuration > Data Sources > MS SQLServer Sources > Performance.
4. If you are using a 6.1.0.1 JDBC client for this data source, leave Enable Pass Thru Optimizations set to true; otherwise, set it to false.
5. Click Apply.
6. Click OK.
7. Restart the TDV Server to implement any changes you have made.