multidimensional SQL connector
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
somebody has already experience with multidimensional SQL connector?
like the SSAS?
found this link:
https://gallery.alteryx.com/#!app/SSAS-Connector/5da5b2e8826fd3112c85d012
any help will be welcome!
thanks
Monica
- Labels:
- Connectors
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
What is your question around this? Are you trying to connect to one?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
yes, actually is a database coming out from olap...and has a lot of hierarchies and levels...and quite difficult...I have already the access to tableau, but I do not know how to do it via alteryx...and I saw the video from SSAS connector...and I´m just asking if somebody has experience with something similiar...
Do you?
regards
Monica
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @maxtla, Alteryx natively doesn't pull data from OLAP systems. There are 3rd party connectors that enable users to make the bridge between OLAP cubes (like the one you shared) and Alteryx but they typically tend to be a paid service. Alternatively, you could explore making MDX queries via Python scripts and integrate it within Alteryx using the Python tool.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Monica,
Funny, I don't know that app and the app I used is no longer on the public gallery... That one had a visual studio solution that I downloaded. The only thing I had to do was update references to dll's (ADO connector) and rebuild the solution. The resulting SSAS.exe can be used in run command tool in Designer. Only thing you need is server name, and mdx query. It's pretty fast (as OLAP should be).
I attached zip containing the vs solution if you want to play with it.
Simon
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi Simon,
thanks a lot for your reply.
I tried several times, but I cannot get into the ADO connector...I´m beginner a little bit...maybe can I call you or do you have time to help?
will appreciate it very much!
thanks
Monica
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hey Monica,
yeah DM me.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
Thanks for your reply...I asked this connector (the one I shared) SSAS...but they do not do it anymore...and to be honest I need something like that...do not know how they could cost...cause the I have no experience with that MDX queries via Phyton...no idea...do you have experience with those connectors? will appreciate your advice...
thanks and regards
Monica
