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

How to create ODBC Logfiles with Tableau

    XMLWordPrintable

    Details

    • Type: How To
    • Status: Published
    • Affects Version/s: EXASolution 5.0, EXASOL 6.0.0, Exasol 6.1.0
    • Fix Version/s: None
    • Component/s: 3rd Party Tools, ODBC
    • Labels:
      None
    • Solution:
      Hide

      If you want to create an ODBC logfile from Tableau, you'll find the required steps below:

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

      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'...>

      now modify 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' ...>

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

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

      Show
      If you want to create an ODBC logfile from Tableau, you'll find the required steps below: Create a copy of your Tableau workbook Open your Tableau workbook copy with a text-editor (the format is XML) 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'...> now modify 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' ...> For all ODBC logfile options, please refer to the user manual Now open this workbook again with Tableau and do everything you want to have within the odbc logfile.
    • 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: