Uploaded image for project: 'Solution Center'
  1. Solution Center
  2. SOL-290

How to create ODBC Logfiles with Tableau

    Details

    • Solution:
      Hide

      Note: This solution is no longer maintained. For the latest information, please refer to our documentation:

      https://community.exasol.com/t5/database-features/how-to-create-odbc-logfiles-with-tableau/ta-p/1244

      Background

      You want to create an ODBC logfile from Tableau.

      Prerequisites

      • Create a copy of your Tableau workbook
      • Open your Tableau workbook copy with a text-editor (the format is XML)

      How to create ODBC Logfiles with Tableau 

      Step 1

      Find your datasource and edit the connection class:

      <workbook>
        <datasources>
          <datasource caption='your_datasource_name' ...>
            <connection class='exasolution' odbc-connect-string-extras='' port='8563' schema='YOURSCHEMA' server='192.168.10.11..22:8563'...>
      

      Step 2

      Now modify the odbc-connect-string-extras

            <connection class='exasolution' odbc-connect-string-extras='EXALOGFILE=D:\logfiles\TableauODBC.log;LOGMODE=DebugComm' port='8563' schema='YOURSCHEMA' server='192.168.10.11..22:8563' ...>
      

      Step 3

      Now open this workbook again with Tableau and do everything you want to have within the ODBC logfile.

      Additional References

      For all ODBC logfile options, please refer to the user manual

       

      Show
      Note: This solution is no longer maintained. For the latest information, please refer to our documentation: https://community.exasol.com/t5/database-features/how-to-create-odbc-logfiles-with-tableau/ta-p/1244 Background You want to create an ODBC logfile from Tableau. Prerequisites Create a copy of your Tableau workbook Open your Tableau workbook copy with a text-editor (the format is XML) How to create ODBC Logfiles with Tableau  Step 1 Find your datasource and edit the connection class: <workbook> <datasources> <datasource caption= 'your_datasource_name' ...> <connection class= 'exasolution' odbc-connect-string-extras= '' port=' 8563 ' schema=' YOURSCHEMA ' server=' 192.168.10.11..22:8563'...> Step 2 Now modify the  odbc-connect-string-extras <connection class= 'exasolution' odbc-connect-string-extras= 'EXALOGFILE=D:\logfiles\TableauODBC.log;LOGMODE=DebugComm' port= '8563' schema= 'YOURSCHEMA' server= '192.168.10.11..22:8563' ...> Step 3 Now open this workbook again with Tableau and do everything you want to have within the ODBC logfile. Additional References For all ODBC logfile options, please refer to the user manual  
    • Category 1:
      3rd Party Tools - Vizualization & Analytics
    • Category 2:
      Clients, Interfaces & Drivers - ODBC

      Attachments

        Activity

          People

          • Assignee:
            CaptainEXA Captain EXASOL
            Reporter:
            CaptainEXA Captain EXASOL
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: