<p>We need to get data out of some Hyperion cubes (databases) using SSIS. Are there any connection managers available for this? Has anyone done this? </p>

[{'answer_id': 84765, 'author': 'CodeRot', 'author_id': 14134, 'author_profile': 'https://Stackoverflow.com/users/14134', 'pm_score': 0, 'selected': False, 'text': "<p>I don't have any experience with Hyperion, but can you make use of the Script Task in SSIS?</p>\n"}, {'answer_id': 141349, 'author': 'Brad_Z', 'author_id': 22273, 'author_profile': 'https://Stackoverflow.com/users/22273', 'pm_score': 1, 'selected': False, 'text': "<p>There are some third party connectors out there. Don't think any exist from oracle or microsoft.</p>\n"}, {'answer_id': 11457735, 'author': 'jwj', 'author_id': 611797, 'author_profile': 'https://Stackoverflow.com/users/611797', 'pm_score': 1, 'selected': False, 'text': "<p>I know this is a very old question but I just happened upon it and thought I would offer some perspective. There isn't build in support for getting data from Hyperion with SSIS. There are a few ways to go, however. </p>\n\n<p>You can fairly easily export Hyperion data with a calc or report script to text/SQL. You could use SSIS to run a batch file that kicks off a Hyperion job that loads up a SQL database or text file, <em>then</em> load it with SSIS. </p>\n\n<p>There are a handful of tools with Essbase adapters so you can use those if you aren't using SSIS. </p>\n"}]
['https://Stackoverflow.com/questions/71476', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/-1/']