Hi,
I have done this in .Net, but that is easy because you get .Net libraries to help you connect and send XMLA over TCP/IP.
I would want to do the same using Java:
Connect to SSAS 2005 on TCP/IP, or even SOAP over TCP/IP
Then execute XMLA commands
and retrieve XMLA responses.
How to accomplish this?
Regards
Vijay R
The TCP/IP bindings to XMLA that AS use as proprietrary and also patented, therefore you cannot connect directly over TCP/IP to AS. You can use HTTP instead.|||
Hi Mosha,
Thanks a lot,
But to use HTTP we need to use IIS,
any other way to do this?
Regards
Vijay R
|||But to use HTTP we need to use IIS
Yes. What is a problem with using IIS ?
|||Hi Mosha,
Thanks for the quick reply,
No problem with IIS, but the dependency increases and my customer does not want to spend extra on another server.
They use java based servers like JMS.
I have told them that either we need to use AMO.Net in an .Net code or use IIS.
The problem is because of the xmla specification and ssas 2005 information given in books,
My customer points out to me that we can do an SOAP over tcp/ip and pass XMLA commands, as printed in the books!
I am not finding a valid technical angle to tackle this.
apart from that I had another related question:
we can use oledb and connect to ssas2005, right?
1) can we pass xmla commands using oledb? command like <Create>, <Alter> etc
2) the new jdbc driver for sql 2005, does it allow to connect to ssas 2005?
Thanks once more mosha
Regards
|||No problem with IIS, but the dependency increases and my customer does not want to spend extra on another server
There is no need to spend extra on another server. You can have IIS and Analysis Services server on the same machine.
My customer points out to me that we can do an SOAP over tcp/ip and pass XMLA commands, as printed in the books!
Your customer is wrong. He cannot do that. Microsoft's OLEDB driver and ADOMD.NET can do that, but as I pointed earlier the TCP/IP bindings to XMLA are proprietrary and patent protected.
we can use oledb and connect to ssas2005, right?
Correct
1) can we pass xmla commands using oledb? command like <Create>, <Alter> etc
Yes
2) the new jdbc driver for sql 2005, does it allow to connect to ssas 2005?
No
|||Hi Mosha,
Thanks a lot :-)
I have been quite a fan of yours!! I am currently in the US, any chance that you are here?
If possible, I was hoping to meet you.
No problem anyway, bye
Thanks again.
Regards
Vijay R
|||
Hi Mosha,
I can java, but donn't like it, therevore i use .Net pure and can communicate with SSAS through XMLA over TCP from my own code without adomd.net and other proprietary junk. Yes I haven't compression and encription, but it runs!!!
What law I break?
|||Hi,
I tried some java code,
that opens a socket connection and sends the xmla in a soap envelope as a string.
but the connections itself in ssas profiler displays as anonymous logon,
the query does not come through to the server at all !
Regards
Vijay R
|||Hi all,
When reading the following statements by Mosha, i was very excited:
we can use oledb and connect to ssas2005, right?
Correct
1) can we pass xmla commands using oledb? command like <Create>, <Alter> etc
Yes
Then I had to ask... How? Do I need to use a different provider / connection string? Do I need to wrap my XMLA in anything? Where can I find further information on this.
Thankyou
Aranda
|||You should send SSPI handshacke info. How to obtain it in java I don't know. In the .Net it is pretty easy.
|||Hi,
can you please explain in detail as to how to send the SSPI handshake info In a .net program?
it would be helpful if you can give a code snippet that expains the procesure.
Regards
|||Hi,
Mosha wrote "as I pointed earlier the TCP/IP bindings to XMLA are proprietrary and patent protected."
Therefore here is not a right place to speak it about.
Regards
|||:-)
So how about this Vladimir Chtepa: vijay_rb@.yahoo.com
in any case, thanks for the interaction.
Regards
No comments:
Post a Comment