3 Replies Latest reply on May 18, 2017 9:13 AM by Shankar Radhakrishnan

    Generic ODBC (Oracle BI Server 1) to Tableau

    Praveen Alamuru

      Hi,

       

      Tableau Desktop Version - 10.1 and OBIEE is 11.1.1.9

      I am trying to connect Tableau with OBIEE Metadata, and been unsuccessful.

      I created ODBC connection and followed the steps from

      https://community.tableau.com/docs/DOC-9858

       

      After establishing the connection,  When I select Database (From Subject Areas) ,  Nothing Happens from this step.

       

      I placed .tdc file at C:\Users\<user>\Documents\My Tableau Repository\Datasources

       

      and the contents are

      <?xml version='1.0' encoding='utf-8' ?>

      <connection-customization class='genericodbc' enabled='true' version='10.1'>

        <vendor name='Oracle Business Intelligence' />

        <driver name='Oracle BI Server 1' />

        <customizations>

          <customization name='CAP_SET_ISOLATION_LEVEL_VIA_ODBC_API' value='no' />

          <customization name='CAP_SUPPRESS_DISCOVERY_QUERIES' value='no' />

          <customization name='SQL_CATALOG_USAGE' value='0' />

          <customization name='SQL_SCHEMA_USAGE' value='0' />

          <customization name='CAP_FAST_METADATA' value='yes' />

        </customizations>

      </connection-customization>

       

      Tried with the location C:\Users\user\Documents\My Tableau Repository\Mapsources

       

      No Luck.

       

      In Tabprotosrv.log I see this

       

      {"ts":"2017-01-20T12:12:53.900","pid":5128,"tid":"99c","sev":"warn","req":"-","sess":"-","site":"{47B354A1-2F0A-41F7-B788-FB1CE9E6FF2E}","user":"-","k":"msg","v":"ODBCProtocolImpl::SetIsolationLevelViaODBC : Unable to set transaction isolation level.","ctx":{"client-type":"desktop","procid":"5516","tid":"5580","version":"10100.16.1223.0056"}}

      {"ts":"2017-01-20T12:12:53.901","pid":5128,"tid":"99c","sev":"warn","req":"-","sess":"-","site":"{47B354A1-2F0A-41F7-B788-FB1CE9E6FF2E}","user":"-","k":"database-error","v":{"error-records":[{"error-desc":"[NQODBC] [SQL_STATE: HYC00] [nQSError: 10090] The driver is not capable of processing the given request.\r\n","error-record":1,"native-error":10090,"sql-state":"HYC00","sql-state-desc":"SQLSTATE_API_OPT_FEATURE_NOT_IMPL_ODBC3x"}],"file":"d:\\tc\\builds\\tableau-16-q4\\tableau-16-q4.16.1223.0056\\modules\\connectors\\tabmixins\\main\\db\\ODBCProtocolImpl.cpp","line":1822,"protocol":"45d9683990","retcode":-1,"retcode-desc":"SQL_ERROR"},"ctx":{"client-type":"desktop","procid":"5516","tid":"5580","version":"10100.16.1223.0056"}}

      {"ts":"2017-01-20T12:12:53.901","pid":5128,"tid":"99c","sev":"info","req":"-","sess":"-","site":"{47B354A1-2F0A-41F7-B788-FB1CE9E6FF2E}","user":"-","k":"protocol-added-to-group","v":{"group":{"attributes":{":odbc-hwnd":"",":odbc-prompt":"2",":protocol-customizations":"","class":"genericodbc","dbname":"","odbc-connect-string-extras":"","odbc-dbms-name":"","odbc-driver":"Oracle BI Server 1","odbc-dsn":"tab","odbc-suppress-connection-pooling":"","odbc-use-connection-pooling":"","password":"","port":"","server":"","username":""},"closed-protocols-count":"0","connection-limit":"1","group-id":"0","in-construction-count":"0","protocols-count":"1","this":"0x00000045d9601a60"},"protocol-id":"0"},"ctx":{"client-type":"desktop","procid":"5516","tid":"5580","version":"10100.16.1223.0056"}}

      {"ts":"2017-01-20T12:12:53.903","pid":5128,"tid":"99c","sev":"warn","req":"-","sess":"-","site":"{47B354A1-2F0A-41F7-B788-FB1CE9E6FF2E}","user":"-","k":"connection-info-mismatch","v":{":odbc-hwnd":"<empty>",":odbc-prompt":"(MISMATCH) <empty> <=> 2",":protocol-customizations":"<empty>",":thread-session":"(MISMATCH) 0 <=> <missing>","class":"genericodbc","dbname":"<empty>","odbc-connect-string-extras":"<empty>","odbc-dbms-name":"(MISMATCH) Oracle Business Intelligence <=> <empty>","odbc-driver":"Oracle BI Server 1","odbc-dsn":"tab","odbc-suppress-connection-pooling":"<empty>","odbc-use-connection-pooling":"<empty>","password":"(MISMATCH) ******** <=> <empty>","port":"<empty>","server":"<empty>","username":"(MISMATCH) weblogic <=> <empty>"},"ctx":{"client-type":"desktop","procid":"5516","tid":"5580","version":"10100.16.1223.0056"}}

       

      Any Help is appreciated.