Configure the 1010data ODBC driver

You must configure the 1010data ODBC driver with connection-related information such as your 1010data login credentials and other 1010data-specific settings so that Tableau can communicate with 1010data using the 1010data ODBC driver.

If you have not already done so, you must download and install the 1010data ODBC driver. See the 1010data ODBC Driver User's Guide for instructions.

Note: The 1010data ODBC driver is only available for clients who have purchased API access along with their 1010data account. If you don't have API access, or aren't sure if you do, contact your 1010data sales representative.

To configure the 1010data ODBC driver to work with Tableau:

  1. Navigate to the folder containing the 1010data ODBC configuration programs.
    1. Click the Start button.
    2. Click All Programs.
    3. Click 1010data.
    4. Click 1010odbc.
  2. Open the configuration program corresponding to the versions of Tableau and Windows you are using.
    • If you are using the 32-bit version of Tableau on a 64-bit version of Windows, click Configure 32-bit ODBC.
    • Otherwise, click Configure Native ODBC.

    If you are not sure whether you are using the 32-bit or 64-bit version of Tableau, open Tableau and click Help > About Tableau. The About Tableau dialog shows which one you are using.

    Once you have selected the configuration program corresponding to the version of Tableau you are using, the ODBC Data Source Administrator dialog is displayed.

  3. Click the System DSN tab.
    Note: You must have administrative privileges to create or modify system DSNs. If you do not have administrative privileges, contact your system administrator.
    The list of System Data Sources is displayed.

  4. Click Add to add a new DSN specifically for Tableau.

    The Create New Data Source dialog appears.

  5. In the Create New Data Source dialog, select the driver corresponding to the version of Tableau you are using.
    • If you are using the 32-bit version of Tableau, click 1010data ODBC Driver.
    • If you are using the 64-bit version of Tableau, click Native 1010data ODBC Driver.
  6. Click Finish.
    The SQL1010 ODBC DSN Configuration dialog appears.

  7. Provide your connection-related information.
    1. In the SQL1010 ODBC DSN Configuration dialog, click the Connection tab.
    2. In the DNS field, enter a name for this configuration (e.g., TableauOn1010data).
    3. In the User ID and Password fields, enter your 1010data credentials.
    4. Select both Binary mode and Compression.
      Note: 1010data recommends selecting both of these options unless you have a specific reason or have been directed by a 1010data support representative not to select them.

  8. Import Tableau-specific options.
    1. In the SQL1010 ODBC DSN Configuration dialog, click the Logging tab.
    2. Click the Browse button next to the Import Options field.

      The Save log as dialog appears.

    3. In your Documents library, double-click the Tableau_ODBC_Config folder.
    4. Double-click the tableau_odbc 1010data configuration file.

      The Import Options field is populated with the path to the selected 1010data configuration file.

    5. Click Import Options to import the options from the selected 1010data configuration file.

      If the options are imported successfully, a notification dialog displays a message indicating success.

      If there is an error, the notification dialog displays a message with information related to the problem.

    6. Click OK to dismiss the notification dialog.
  9. Click OK to close the SQL1010 ODBC DSN Configuration dialog.
  10. Click OK to close the ODBC Data Source Administrator dialog.

The 1010data ODBC driver is now configured to work with Tableau.

You can verify that the options you imported have been set correctly in your configuration. See Verify your 1010data ODBC configuration.