[teiid-issues] [JBoss JIRA] Updated: (TEIID-1011) Add support for connecting to Mondrian

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-1011?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins updated TEIID-1011:
----------------------------------

    Fix Version/s: 7.4
                       (was: 7.3)


pushing to 7.4.  Upon further analysis with Ramesh we see two possible approaches:

1. just leverage soap functionality.  extraction from tabular results would be quite easy with xmltable.  some wrappering could be added that makes this almost as easy as mdx in, and rows out.
2. use jdbc4olap, or olap4j, or a custom approach, that would need a set of functions and tabular metadata to issue MDX like queries.  This however would provide little abstraction value (you would issue something like "SELECT ONCOLUMN(DIM.LEVEL) ..." where the metadata for the dimension table serves no purpose other than to form the MDX-like queries).  It also would be require potentially a large set of functions to provide the functionality of MDX.

Given those alternatives we're leaning toward #1, which is currently doable without a custom translator.

It would be good for Ken to weigh in on what intended use case would be for this integration.

> Add support for connecting to Mondrian
> --------------------------------------
>
>                 Key: TEIID-1011
>                 URL: https://issues.jboss.org/browse/TEIID-1011
>             Project: Teiid
>          Issue Type: Feature Request
>          Components: JDBC Connector
>    Affects Versions: 7.1
>            Reporter: Steven Hawkins
>            Assignee: Ramesh Reddy
>             Fix For: 7.4
>
>
> We should add support for connecting to Mondrian (and multidimensional datasources in general) through http://www.jdbc4olap.org/. 

-- 
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira