dbTalk Databases Forums  

Analysis Services and XMLA over TCP/IP - what should go into the socket?

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Analysis Services and XMLA over TCP/IP - what should go into the socket? in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
yurikagan@gmail.com
 
Posts: n/a

Default Analysis Services and XMLA over TCP/IP - what should go into the socket? - 10-26-2006 , 05:31 AM






Books Online says,
"The server component of Analysis Services is the msmdsvr.exe
application, which ordinarily runs as a Windows service. This
application consists of an XML for Analysis (XMLA) listener component
and internal components..."

"The native protocol for Analysis Services is XML for Analysis (XML/A).
Analysis Services provides several data access interfaces for client
applications, but all of these components communicate with an instance
of Analysis Services using XML for Analysis."

"Both client and middle tier applications can communicate directly with
Analysis Services without using a provider. Client and middle tier
applications may send XML for Analysis in SOAP packets over TCP/IP,
HTTP, or HTTPS. The client may be coded using any language that
supports SOAP. Communication in this case is most easily managed by
Internet Information Services (IIS) using HTTP, although a direct
connection to the server using TCP/IP may also be coded. This is the
thinnest possible client solution for Analysis Services."

Does anyone know what exactly should go into the socket so that
communication works over TCP/IP?
Plain XML doesn't work.


Reply With Quote
  #2  
Old   
Jéjé
 
Posts: n/a

Default Re: Analysis Services and XMLA over TCP/IP - what should go into the socket? - 10-26-2006 , 07:38 AM






you can access and execute XML/A commands using the ADOMD.NET API.
but this access is more designed for manging purpose then querying purpose.

for end user access, you have to use IIS and the msmdpump.dll component
if your user can access the server directly then use the native and direct
access which is more powerfull then the HTTP access.

<yurikagan (AT) gmail (DOT) com> wrote

Quote:
Books Online says,
"The server component of Analysis Services is the msmdsvr.exe
application, which ordinarily runs as a Windows service. This
application consists of an XML for Analysis (XMLA) listener component
and internal components..."

"The native protocol for Analysis Services is XML for Analysis (XML/A).
Analysis Services provides several data access interfaces for client
applications, but all of these components communicate with an instance
of Analysis Services using XML for Analysis."

"Both client and middle tier applications can communicate directly with
Analysis Services without using a provider. Client and middle tier
applications may send XML for Analysis in SOAP packets over TCP/IP,
HTTP, or HTTPS. The client may be coded using any language that
supports SOAP. Communication in this case is most easily managed by
Internet Information Services (IIS) using HTTP, although a direct
connection to the server using TCP/IP may also be coded. This is the
thinnest possible client solution for Analysis Services."

Does anyone know what exactly should go into the socket so that
communication works over TCP/IP?
Plain XML doesn't work.




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.