title: Hyperion Essbase Connection in SSIS
body: <p>How can I get SSIS to connect to an Oracle Hyperion Essbase cube to use it as a data source?  Googling this returned the following:</p>
  
  <ol>
  <li><p>A <a href="https://stackoverflow.com/questions/71476/what-are-the-options-for-extracting-data-out-of-hyperion-7-3-with-ssis#">similar question</a> was asked about a specific version with no real answer other than "a third party tool can do it."</p></li>
  <li><p>A <a href="http://social.technet.microsoft.com/wiki/contents/articles/ssis-and-data-sources.aspx" rel="nofollow noreferrer">microsoft SSIS connectors wiki</a> indicates you can do this through <a href="http://social.technet.microsoft.com/wiki/contents/articles/hyperion-star-analytics.aspx" rel="nofollow noreferrer">Star Analytics</a>.</p></li>
  <li><p>Beginning with SQL Server 2005 SP2, <a href="http://www.google.com/url?sa=t&amp;rct=j&amp;q=&amp;esrc=s&amp;frm=1&amp;source=web&amp;cd=1&amp;sqi=2&amp;ved=0CDEQFjAA&amp;url=http://download.microsoft.com/download/4/7/a/47a548b9-249e-484c-abd7-29f31282b04d/UsingSSRSandESSbase.doc&amp;ei=qm0PT5DLBomciQLVvPi6DQ&amp;usg=AFQjCNEJE1aEUXQpBIPzROhr5Ebokyju2A&amp;sig2=6AQJrjSRZg9UlbH5gblBeA" rel="nofollow noreferrer">Reporting Services</a> (SSRS) has a data source connection.  This product feature didn't seem to translate to any objects for SSIS.  One blogger suggested this may have been done as a <em>quid pro quo</em> arrangement back before Oracle purchased Hyperion since Hyperion began supporting connecting to SQL Server 2005 SSAS cubes at that time.</p></li>
  <li><p>As per @billinkc he use to connect to it with straight .NET.  A little digging returned <a href="http://www.oracle.com/technetwork/middleware/bi-foundation/hab-net-099325.html" rel="nofollow noreferrer">Hyperion Application Builder .NET</a> (HAB.NET).  At first this appeared to be a promising solution, but it turns out the product was discontinued with the 11.1.3 release.  @billinkc also provided a code sample now, so I will test it out and see if this works.</p></li>
  </ol>
  
  <p>Aside from licensing the Star Analytics server product which is cost prohibitive (for me), are there any other solutions out there?</p>