2 Replies Latest reply on Mar 9, 2016 5:34 AM by Giridhar Marichetty

    Cognos Cube to Tableau connectivity

    Giridhar Marichetty

      Hi Team,

       

      I am working on Cognos Cube based Tableau Reporting. Tableau does not provide direct connectivity to tableau and the only option left over is to use the ODBC Connectivity.

      For connecting to Cognos Cube i assume some cognos driver has to be installed. Using this driver we will be setting up the ODBC Connectivity.

      If so does this Cognos-ODBC connectivity supports data Extract ??,i assume Cube data source does not support tableau extract and not sure about ODBC connection.

      Could any one through some light on my issue.

       

       

       

      Thanks,

      Giridhar

        • 1. Re: Cognos Cube to Tableau connectivity
          Tharashasank Davuluru

          Hi Giridhar,

           

           

          The following workarounds will sometimes allow you to connect to a Cognos cube.

           

          Option 1:

          Use the Other Databases (ODBC) connection to connect to Cognos and create a data extract.

          Warning: Although it may be possible to connect to Cognos using the Other Databases (ODBC) data connection, success often varies, and full compatibility with Tableau features cannot be guaranteed.

           

          Option 2:

          Move the data from the unsupported data source onto a supported data source, such as SQL Server, MySQL, or Oracle, and then connect to the database using the supported data connection.

           

          Cause

          The ability to connect to Cognos from Tableau Desktop is not currently supported.

           

           

          CarpeDatum has a product called TM1Connect. It simplifies the connectivity issues caused by multidimensional olap tools dramatically.Please have a look at this link also

          TM1Connect - CarpeDatum Consulting Inc.

          • 2. Re: Cognos Cube to Tableau connectivity
            Giridhar Marichetty

            Thanks TharaShasank Davuluru,

            By the way do you know more about Cognos ODBC Connectivity to Tableau.

            I am not sure from where i need to download the ODBC Driver..

            I will try and keep you posted.