-
1. Re: Using OLAP in 8.1 embedded version
ichanjasper Aug 17, 2012 7:16 PM (in response to ichanjasper)Typos. I meant any* sample code/ test code for OLAP? Thanks.
-
2. Re: Using OLAP in 8.1 embedded version
rareddy Aug 17, 2012 8:49 PM (in response to ichanjasper)1 of 1 people found this helpfulIvan,
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..
-
3. Re: Using OLAP in 8.1 embedded version
rareddy Aug 17, 2012 8:55 PM (in response to rareddy)1 of 1 people found this helpfulAlso 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.
-
4. Re: Using OLAP in 8.1 embedded version
ichanjasper Aug 21, 2012 1:48 PM (in response to rareddy)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 Aug 21, 2012 3:15 PM (in response to ichanjasper)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 Aug 21, 2012 5:43 PM (in response to rareddy)Thank you, Ramesh!
-
7. Re: Using OLAP in 8.1 embedded version
rareddy Aug 23, 2012 10:47 AM (in response to ichanjasper)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..