Explains what the feature is or what its benefits are to the user or customer.
This section lists the properties you can set for ODBC or JDBC connections.
Setting Properties for ODBCThe properties information here comes mostly from the document Configuring SimbaClient for ODBC, published by Simba Technologies. You can access it directly here. Not all the parameters Simba accepts are supported by the ThoughtSpot ODBC clients, and ThoughtSpot has added some properties, which are listed separately here. All configuration properties use the type String (text).
You can set these properties on Windows by using the ODBC Administrator.
Setting Properties for JDBC
For JDBC, these properties are passed as key value pairs in the connect string. For more information, see Use the JDBC Driver.
Properties ReferenceThe following tables summarize the configuration properties.
|DATABASE||DSN or Driver||The default database to connect to.|
|SCHEMA||DSN or Driver||The default schema to connect to.|
|Description||DSN||A brief, human-readable description of the DSN. This describes the DSN to users who are deciding which DSN to use.|
|Driver||DSN or Driver||In the driver configuration location, Driver should contain the path to the driver binary. In the DSN configuration location, Driver could contain the path to the driver binary, or it could contain the driver entry in the registry.|
|Idle Timeout||DSN||The time to wait for a response from the server, in seconds. This property is optional, but SimbaClient will wait indefinitely for SimbaServer to respond to a request made to the server unless you specify a timeout period. IdleTimeout specifies how many seconds that SimbaClient will wait before aborting the attempt and returning to the application with an error. This timeout corresponds to ODBC’s CONNECTION_TIMEOUT property and is only used when more specific timeouts, such as QUERY_TIMEOUT or LOGIN_TIMEOUT aren’t applicable.|
|Locale||DSN||The connection locale. If this value is set, it overrides the driver-wide
locale. For example, the driver-wide locale could be en-US. If the client would
prefer fr-CA, it can set the connection locale to fr-CA.
Values are composed of a 2-letter language code (in lower case), and an optional 2-letter country code (in upper case). If the country code is specified, it must be separated from the language code by a hyphen (-).
|LoginTimeout||DSN||The timeout, in seconds, to wait for a response from the server when attempting to log in. A value of 0 means no timeout. The default value is 60.|
|Query Timeout||DSN||The timeout, in seconds, to wait for a response from the server during Prepare, Execute, and ExecuteDirect. A value of 0 means no timeout. The default value is 60.|
|ServerList||DSN||A comma separated list of all servers (IP address and port number) to connect to. SimbaClient must be able to find SimbaServer on the network. This property enables server discovery. SimbaClient will try to make a network connection to the servers in the order specified until a connection is made.|