Regarding Tableau, we need an ODBC driver for Phoenix, as Tableau isn't Java. Maybe Tableau would be interested in providing this, or perhaps one of the custom driver companies?
On Wed, Apr 23, 2014 at 4:53 PM, James Taylor <[email protected]>wrote: > This is fantastic, Juan! Thanks so much for posting this. Would be > fantastic if you did a guest blog on this at > https://blogs.apache.org/phoenix. > > Regards, > James > > > On Wed, Apr 23, 2014 at 11:25 AM, Juan Rodríguez Hortalá < > [email protected]> wrote: > >> >> >> Hi, I've been able to use Phoenix with Saiku http://meteorite.bi/saikuacting >> as a Mondrian front-end, using Phoenix 3.0.0 and HBase 0.94.6 >> CDH4.4.0. I use the following configuration for the Saiku datasource ( >> http://docs.analytical-labs.com/saiku/documentation/configuration/2013/08/15/datasources.html): >> >> >> type=OLAP >> name=phoenix >> driver=mondrian.olap4j.MondrianOlap4jDriver >> >> location=jdbc:mondrian:Jdbc=jdbc:phoenix:localhost;Catalog=res:phoenix/Phoenix.xml;JdbcDrivers=org.apache.phoenix.jdbc.PhoenixDriver >> >> And for example for a simple HBase table like >> >> create 'phoenix', 'fact', 'customer', 'day' >> >> which Phoenix table is: >> >> CREATE TABLE "phoenix" ("key" VARCHAR not null primary key, >> "fact"."count" INTEGER, "customer"."name" VARCHAR, "day"."month" INTEGER); >> >> the cube definition in Phoenix.xml can be as follows: >> >> <Cube name="Customers"> >> <Table name="phoenix"/> >> <Dimension name="Customer"> >> <Hierarchy hasAll="true" allMemberName="All Types"> >> <Level name="Name" column="customer.name" uniqueMembers="true"/> >> </Hierarchy> >> </Dimension> >> <Dimension name="Day"> >> <Hierarchy hasAll="true" allMemberName="All Assignees"> >> <Level name="Month" column="day.month" uniqueMembers="true"/> >> </Hierarchy> >> </Dimension> >> <Measure name="Count" column="count" aggregator="sum" >> formatString="Standard"/> >> </Cube> >> >> Greetings, >> >> Juan Rodríguez Hortalá >> >> >> >> 2014-04-23 19:28 GMT+02:00 Vladimir Rodionov <[email protected]>: >> >> There have been attempts to "marry" Mondrian OLAP server and Phoenix. I >>> think it is still work in progress. With Mondrian OLAP server you can use >>> any BI tool that support MDX: Pentaho, Jaspersoft. >>> >>> >>> On Tue, Apr 22, 2014 at 11:51 PM, anil gupta <[email protected]>wrote: >>> >>>> Hi All, >>>> >>>> We are looking into the possibility of using Phoenix with Tableau. So, >>>> i would like to get feedback from users who tried using Tableau with >>>> Phoenix. >>>> I have never used tableau so i just know that its a Data visualization >>>> application. >>>> I saw this post and as per this it looks like Phoenix cannot be used >>>> with Tableau: >>>> https://groups.google.com/forum/#!topic/phoenix-hbase-user/Oz9Du8tQuCE >>>> >>>> What other data visualization products focused on business >>>> intelligence are being used with Phoenix? >>>> >>>> -- >>>> Thanks & Regards, >>>> Anil Gupta >>>> >>> >>> >> >
