Skip to main content

 

ThoughtSpot

Change the ODBC Configuration on Windows

Overview

Explains what the feature is or what its benefits are to the user or customer.

Feature

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:

  1. Launch the ODBC Administrator. You can find it in your programs under ThoughtSpot ODBC Driver.

    Figure: Launch the ODBC Administrator

    File:Integration_Guides/Data_Integration_Guide_3.5/020/010/010/010/odbc_install_8.png
  2. Click the System DSN tab.
  3. Select the data source you want to modify, and click Configure.

    Figure: System DSN

    File:Integration_Guides/Data_Integration_Guide_3.5/020/010/010/010/odbc_logs_1.png
  4. Some properties are exposed through the dialog box, and you can make the settings there. If you want to change or add a custom property, click Options.

    Figure: ODBC data source options

    File:Integration_Guides/Data_Integration_Guide_3.5/020/010/010/010/odbc_data_source_options.png
  5. To change a custom property, click Edit Property. To add a new custom property, click Add.

    Figure: Edit a custom property

    File:Integration_Guides/Data_Integration_Guide_3.5/020/010/010/010/odbc_options.png
  6. 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.

    Figure: Edit a custom property

    File:Integration_Guides/Data_Integration_Guide_3.5/020/010/010/010/odbc_add_schema.png
  7. Edit any other custom properties you need to change, and click OK again.
  8. Test the settings by clicking Test Connection.
  9. If everything is working, click OK, to save your settings. If not, you may want to enable ODBC logging.
  • Was this article helpful?