Skip to main content
Solved

Connecting to SQL Server Analysis Services Tabular

  • July 13, 2017
  • 2 replies
  • 136 views
notmyname
Participant
Forum|alt.badge.img

Hello,

Does anyone know if FME is able to connect directly to an Analysis Services (SSAS) Tabular model. I know it can connect to SQL Server. I also know I can read an excel sheet that is connected to the tabular model, but I would like to connect directly to a tabular model.

Thanks,

David

Best answer by markatsafe

I don't think we've heard of anyone trying to directly connect to Analysis Services Tabular from FME. From a quick search of the MS website, it looks like connection options to SSAS are OLE DB , HTTP (no mention of REST), or mostly MS clients like Excel, PowerBI, SQL Server.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

M
Forum|alt.badge.img+2
  • markatsafe
  • 1891 replies
  • Best Answer
  • July 14, 2017

I don't think we've heard of anyone trying to directly connect to Analysis Services Tabular from FME. From a quick search of the MS website, it looks like connection options to SSAS are OLE DB , HTTP (no mention of REST), or mostly MS clients like Excel, PowerBI, SQL Server.

notmyname
Participant
Forum|alt.badge.img
  • notmynameParticipant
  • Author
  • Participant
  • 22 replies
  • July 17, 2017

I don't think we've heard of anyone trying to directly connect to Analysis Services Tabular from FME. From a quick search of the MS website, it looks like connection options to SSAS are OLE DB , HTTP (no mention of REST), or mostly MS clients like Excel, PowerBI, SQL Server.

Thanks for the response,

 

The desire to connect to SSAS is probably not a common one. I wanted to make sure there was not a simple way that was being overlooked.

 

 

David

 

 

Community Stats

32,058
Posts
121,724
Replies
39,687
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.