Once installation is complete, you can use the ODBC Administrator to change the ODBC configuration. For example, you may want to add a default schema or change the server IP address or the default database.
It is recommended to add a default schema. If you don’t specify a default schema, you will need to supply it every time you use the ODBC driver. If you aren’t using schemas in ThoughtSpot, you should specify the default schema, which is “falcon_default_schema”. If you don’t supply a default schema, and you don’t specify a schema when using the ODBC driver, you will see an error that says the schema could not be found.
To make changes to the ODBC settings on Windows:
-
Launch the ODBC Administrator. You can find it in your programs under ThoughtSpot ODBC Driver.
- Click the System DSN tab.
-
Select the data source you want to modify, and click Configure.
Some properties are exposed through the dialog box, and you can make the settings there.
-
To change or add a custom property, click Options.
-
To change a custom property, click Edit Property or to add a new custom property, click Add.
-
Type in the key (if needed) and add the value and click OK.
You can add a default schema to use by adding a new custom property with the key “SCHEMA”. If you don’t use custom schema names in ThoughtSpot, use the value “falcon_default_schema”. If you add a default schema, that will save you from having to supply the schema every time you use the ODBC connection.
- Edit any other custom properties you need to change, and click OK again.
- Test the settings by clicking Test Connection.
-
If everything is working, click OK, to save your settings.
If not, you may want to enable ODBC logging.