• EN
Solved

Connecting to SQL Server Analysis Services Tabular

  • 13 July 2017
  • 2 replies
  • 24 views
notmyname
Rank
Badge

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

icon

Best answer by markatsafe 14 July 2017, 18:44

View original

2 replies

M
Badge +2

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
Rank
Badge

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

 

 

Reply


Community Stats

28,799
Posts
109,770
Replies
36,617
Members
Terms & ConditionsCookie settings
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.