7 Replies Latest reply on Aug 23, 2012 10:47 AM by rareddy

    Using OLAP in 8.1 embedded version

    ichanjasper

      I am trying to create ConnectorManager for OLAP.  What should I return in getConnectionFactory() ?  Do you guys have another sample code/ test code for OLAP?  Thanks.

       

      - Ivan

        • 1. Re: Using OLAP in 8.1 embedded version
          ichanjasper

          Typos.  I meant any* sample code/ test code for OLAP?  Thanks.

          • 2. Re: Using OLAP in 8.1 embedded version
            rareddy

            Ivan,

             

            The Teiid OLAP connector uses OLAP4J JDBC Driver in the connection factory. However, that should not limiting if OLAP4J does not support your OLAP system. The ConnectionFactory is designed such that you can provide connection in any form that you wish, as along as you can use that connection object on the translator to issue the olap specific commands and read results from.

             

            Ramesh..

            1 of 1 people found this helpful
            • 3. Re: Using OLAP in 8.1 embedded version
              rareddy

              Also I want to add that the aim of Teiid "embedded" version is to provide a fully functional data virtualization engine such that user can combine any type of sources and integrate data between them. Thus we do not provide any ready made connection factories in "embedded", if you need them defined then I suggest the regular Teiid version, where it defines whole connection management semantics.

              1 of 1 people found this helpful
              • 4. Re: Using OLAP in 8.1 embedded version
                ichanjasper

                Thanks.  If I am using OlapExecutionFactory and not using JNDI, I assume I need to override getConnectionFactory() function in ConnectorManager.  What object type should I return for the connection object in getConnectionFactory() in order to use it for OlapExecutionFactory?

                • 5. Re: Using OLAP in 8.1 embedded version
                  rareddy

                  As i mentioned above Teiid provided OlapExecutionFactory  works with OLAP4J JDBC driver. It looks for a javax.sql.DataSource class as ConnectionFactory and java.sql.Connection as connection. However, if you re-write the OlapExecutionFactory (as you see Teiid has very thin wrapper) you can redo those to what ever connection semantics you provide.

                   

                  Ramesh..

                  • 6. Re: Using OLAP in 8.1 embedded version
                    ichanjasper

                    Thank you, Ramesh!

                    • 7. Re: Using OLAP in 8.1 embedded version
                      rareddy

                      Ivan,

                       

                      As you can see our implementation of OLAP Translator is very thin, when we were trying to develop it, we saw it was very difficult to convert SQL based queries into MDX queries without intimate knowledge of the MDX for optimized pushdown to occur to the source system. However, if you are familiar with MDX and would like re-write this translator, we would like extended any help we can if you can contribute back. Please do let us know if you need any help with translator semantics.

                       

                      Thanks

                       

                      Ramesh..