Accessing Java within SQL Server

have a Java Class that I want to be able to access from within a SQL Server Stored procedure. I know we can access C# and other .NET Framework code, but how can you access a Java Class?

How would you access a Java class from "normal" .NET code?

Niels

Access SSAS 2005 Data from Java

I have a C# ASP.NET 2.0 application that is using ADOMD to access my cube data in SSAS and it works very well.

I have another project in Java and would like to integrate SSAS cube data. Is this possible? I know Microsoft makes SQL Server drivers for Java. Is there anything like ADOMD for Java? If not, is there a OLAP type tool that is similar to SSAS that is Java friendly?

I know Java and Microsoft are usually competing and incompatible technologies. Please don't tell me to switch or turn this into a political thread.

Any tips are greatly appreciated.

Thanks in advance!
use XMLA. there are plenty of opensource solutions and examples it about.|||

Here are links to two good open source tools which use Java to access Analysis Services through XMLA:

1. JPivot http://jpivot.sourceforge.net/

2. REX http://sourceforge.net/projects/whex/

Access SSAS 2005 Data from Java

I have a C# ASP.NET 2.0 application that is using ADOMD to access my cube data in SSAS and it works very well.

I have another project in Java and would like to integrate SSAS cube data. Is this possible? I know Microsoft makes SQL Server drivers for Java. Is there anything like ADOMD for Java? If not, is there a OLAP type tool that is similar to SSAS that is Java friendly?

I know Java and Microsoft are usually competing and incompatible technologies. Please don't tell me to switch or turn this into a political thread.

Any tips are greatly appreciated.

Thanks in advance!use XMLA. there are plenty of opensource solutions and examples it about.|||

Here are links to two good open source tools which use Java to access Analysis Services through XMLA:

1. JPivot http://jpivot.sourceforge.net/

2. REX http://sourceforge.net/projects/whex/

Access java webservices from CLR function on sql server in DMZ.

Hello,
First excuse me for my bad english.
I have developed a sql server funtion CLR calling external webservices (java
).
Everything works perfectly when i execute the function on my test server.
But i need to deploy it on my production sql server 2005, but the cluster is
in DMZ (private network), and from it i don't have a direct access on
internet.
What is the best secure solution :
- NAT?
- install a sql express on the web server, and connect the cluster on it?
thanks for your response.
DraganNo response for me doesn't matter
I found my answer alone. For everyone who wan't to use a CLR UDF table
fonction who get some data from distant web service, and where the sql serve
r
was in private network, behind a webserver simply mail me
Have a nice weekend
"Draggi" wrote:

> Hello,
> First excuse me for my bad english.
> I have developed a sql server funtion CLR calling external webservices (ja
va).
> Everything works perfectly when i execute the function on my test server.
> But i need to deploy it on my production sql server 2005, but the cluster
is
> in DMZ (private network), and from it i don't have a direct access on
> internet.
> What is the best secure solution :
> - NAT?
> - install a sql express on the web server, and connect the cluster on it?
> thanks for your response.
> Dragan|||> I found my answer alone. For everyone who wan't to use a CLR UDF table
> fonction who get some data from distant web service, and where the sql
> server
> was in private network, behind a webserver simply mail me
Why not post your solution here so that others with the same problem can
easily find the answer?
Hope this helps.
Dan Guzman
SQL Server MVP
"Draggi" <Draggi@.discussions.microsoft.com> wrote in message
news:08984EC0-25A3-4E42-BB63-8E291C275BF1@.microsoft.com...[vbcol=seagreen]
> No response for me doesn't matter
> I found my answer alone. For everyone who wan't to use a CLR UDF table
> fonction who get some data from distant web service, and where the sql
> server
> was in private network, behind a webserver simply mail me
> Have a nice weekend
>
> "Draggi" wrote:
>