使用SSIS从Hyperion 7.3中提取数据的选项有哪些？ [英] What are the options for extracting data out of Hyperion 7.3 with SSIS?

问题描述

我们需要使用SSIS从某些Hyperion多维数据集（数据库）中获取数据。是否有可用的连接管理器？有人这样做吗？

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?

推荐答案

我知道这是一个非常老的问题，但我碰巧遇到了这个问题，并认为我会提供一些看法。没有内置支持使用SSIS从Hyperion中获取数据。但是，还有几种方法。

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.

您可以轻松地将带有计算或报告脚本的Hyperion数据导出到text / SQL。您可以使用SSIS运行批处理文件，该文件从Hyperion作业开始，该作业将加载SQL数据库或文本文件，然后然后用SSIS加载该文件。

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, then load it with SSIS.

有一些带有Essbase适配器的工具，因此，如果您不使用SSIS，则可以使用它们。

There are a handful of tools with Essbase adapters so you can use those if you aren't using SSIS.

这篇关于使用SSIS从Hyperion 7.3中提取数据的选项有哪些？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！