ODBC for QuickBase

Application Note for QuNect ODBC for QuickBase

How to Attribute Integration Reads to Each Particular Piece of Code that uses QuNect ODBC for QuickBase

To attribute a piece of code to its integration reads just use a DSN configured for the piece of code. In the DSN configuration dialog just fill in the User Agent field. This is useful for identifying the source of API calls in the Quickbase Platform analytics Usage reports. The user agent string is "QuNect ODBC/X.XX.XX.XX (Operating System)", where X.XX.XX.XX is the version of QuNect ODBC for QuickBase and the operating system is either "Windows" or "Linux". For example, if you enter "MyApp" in the text box above, the user agent string will be "QuNect ODBC/X.XX.XX.XX (Windows)MyApp". You can also use a connection string parameter called USERGENT to set the user agent string. The connection string parameter takes precedence over the DSN setting.

You can use a single DSN to create multiple linked servers and differentiate them using the Provider string property. For example, you can specify the provider string as follows: "USERGENT=MyApp". This will override the user agent string set in the DSN configuration. This is particularly useful when you want to dynamically assign user agent strings for different linked servers without modifying the DSN settings.