Power BI
Needs VotesHow to adjust the Teradata .NET Data Provider Connection settings in Power BI
rupal on 08 Jan 2019 01:25:46
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.
- Comments (1)
RE: How to adjust the Teradata .NET Data Provider Connection settings in Power BI
Re: UseXViewsHardcoding 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 schemasDefault Database is not set UseXXiews=True Otherwise,When user needs objects from single schemaDefault 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).