Configure multiple connections on Windows

You can add multiple ODBC data sources.

Use this procedure if you want to add an additional data source after creating installing ODBC on Windows. The main reason for needing to set up multiple ThoughtSpot ODBC data sources is that you have a production cluster and a test or development cluster.

  1. Locate and open the ODBC Data Source Administrator (64-bit) application.

    odbc windows search1

  2. Click the System DSN tab.

  3. Select Add.

    The system lists the available drivers.

    ODBC choose new data source to add
  4. Choose the ThoughtSpot ODBC Driver and click Finish.

    The system displays the Client Configuration Dialog dialog.

    ODBC config dev source connect
  5. Enter the your data source configuration.

    Configuration Property Value

    Data Source Name

    The name you want to call the data source.

    Description

    A description of the data source.

    Server IP

    A list of the IP addresses for each node, separated by commas.

    Server Port

    12345

    Idle Timeout

    Time in seconds after which an idle ODBC connection times out.

    Login Timeout

    Time in seconds after which a login request times out.

    Query Timeout

    Time in seconds after which a query times out.

  6. Configure custom properties by clicking Options.

    The system displays the Options dialog.

    ODBC add custom property
  7. Add these properties using the Add to enter an option and click OK after to save an option.

    Option Value

    DATABASE

    The default database to connect to.

    SCHEMA

    The default schema to connect to. Use falcon_default_schema if you aren’t sure.

    CONNECTIONTIMEOUT

    Optional. Seconds before an idle connection times out.

    The key must be defined exactly as it appear here, using all capital letters. You can find other supported properties in ODBC and JDBC configuration properties.

    ODBC add custom property new data source
  8. When you are done, click OK to save your new configuration.

    odbc new config
  9. Click Test Connection to test your database connection.

    windows odbc success

    If your test connection fails, enable ODBC logging to troubleshoot.

  10. Click Cancel to close the DSN Configuration dialog.

  11. Click OK to close the Client Configuration Dialog the dialog.

  12. Click OK to close the ODBC Data Source Administrator (64-bit) application.