How to adjust the Teradata .NET Data Provider Connection settings in Power BI

[rupsterman]

Please expose Teradata .NET settings in Teradata Connector for query performance and network transfer performance tuning. Customers should have the ability to set 'any' data source attribute per their enterprise environment requirements...whether through a UI or config file. At minimum, the following (non-credential) attributes should be configurable to users: AuthMeth= Database= Restrict to Default Database=[True|False] Use X Views=[True|False] Read Ahead=[True|False] (or hardcode to True) Response Buffer Size= SessionCharset= This should apply to all MS products interfacing w/ Teradata.

[rupsterman]

Re: UseXViews

Hardcoding UseXViews = True, generates additional security calls when trying to get list of user objects. The use case when to set this should be: ​

• When user needs objects from multiple schemas
• Default Database is not set​
• UseXXiews=True ​

Otherwise,

• When user needs objects from single schema
• Default Database is set
• UseXViews=False ​
• Restrict to Default Database = true ​

Re: Response Buffer Size 

Not exposing Response Buffer Size attribute limits users from experimenting if better performance can be achieved. The default response-buffer size may work well for on-prem. However, environments with high-latency will most likely benefit from higher Response-Buffer size (i.e. reduce round-trip calls). ​