Share via

connect to Essbase cube from SSIS . use a MDX query to pull data

dilip uddagiri 1 Reputation point
2022-03-01T01:21:11.157+00:00

Hi expexts.
i have a MDX query from Essbase cube. i want to use that query to pull into ( table/file) using SSIS. is this possible ? will oldb/ado.net source help? or do we need to write a Script task? any input is appreciated .

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,702 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 41,491 Reputation points
    2022-03-01T07:25:16.633+00:00

    Hi @dilip uddagiri ,

    There is no OLEDB provider for Essbase.

    You may try with ODBC source to see if it could connect to Essbase cube.

    I'm not familiar with Essbase and code writing, check this thread to see if you could connect to it with C#.

    Regards，

    Zoe

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.