Proccesing SSAS OLAP Cubes

[Anonymous]

Hello,

I would like to know if there is a way to process my SSAS OLAP Cubes using the tSystem component by executing an xmla in talend ?

I have browsed the web but I did not find any consistent answers in order to start.

Anyone can give me a hint or a way to achieve this ?

Kind regards,

Mohammad

[Anonymous]

Hello,

Do you want to submit XMLA code to SQL Server Analysis Services?

So far, there is no a connector for integrating with SQL Server Analysis Services right now.

Best regards

Sabrina

[dbeltritti · Accepted solution]

There's an option to use HTTP to send the XMLA file to Analysis server, it would require you to configure IIS (https://docs.microsoft.com/en-us/analysis-services/instances/configure-http-access-to-analysis-servi...)

Then from Talend you can do an HTTP post and provide the xmla in the body