Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 933
  • Last Modified:

Does it possible to use SSIS to retrieve data from a cube using MDX queries?

Does it possible to use SSIS to retrieve data from a cube using MDX queries?  Thanks.
0
thomaszhwang
Asked:
thomaszhwang
  • 4
  • 3
  • 2
1 Solution
 
ValentinoVBI ConsultantCommented:
SSIS allows data retrieval from any source for which you've got an OLE DB driver.  There is an OLE DB driver for SSAS, so yes, you can retrieve data from a cube.

On SSIS 2008, the driver is labelled "Microsoft OLE DB Provider for Analysis Services 10.0".
0
 
Jason Yousef, MSSr. BI  DeveloperCommented:
hi, yes as Valentino said, it could get the data from SSAS but not using MDX, just a straight load connection.
0
 
ValentinoVBI ConsultantCommented:
Hey Jason,

Why not MDX?  I tried it out (using the regular OLE DB Source in the data flow) and it seems to work fine (if you ignore the warning)?

Regards,
V.
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
Jason Yousef, MSSr. BI  DeveloperCommented:
Hey Valentine,

Oh really! excuse my ignorance then, sorry...I should try it then

Thanks for letting me know that
Jason
0
 
ValentinoVBI ConsultantCommented:
Repeat after me (x100): "I will try it out before commenting" ;)
0
 
Jason Yousef, MSSr. BI  DeveloperCommented:
don't have time.... I'll cheat and use:     Replicate ("I will try it out before commenting", 100)
0
 
ValentinoVBI ConsultantCommented:
Good one! :)

Thomas: sorry to get a little off topic here, just let us know if you need further info on this.
0
 
thomaszhwangAuthor Commented:
whatever...
0
 
thomaszhwangAuthor Commented:
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

  • 4
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now