About PALO

Palo is an open source MOLAP server available here. This distribution DOES NOT provides an XMLA interface.

However, the company behind Palo (JEDOX AG) has a premium solution here. This one DOES provide an XMLA interface. While Jedox has their own provider this one works too.

As connection string use:

Location=127.0.0.1:4242

Everything else about creating a new connection is explained here