Systems talking to each other

Hello,

Is it possible to make sql server 2015 talk to Sun Java System Web Server.
Cheers
RIASAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Nakul VachhrajaniConnect With a Mentor Technical Architect, Capgemini IndiaCommented:
Yes, sure. If the system on the Sun server is exposing data over ODBC, you can surely import it using SSIS or any other integration technology - SQL Server won't even realize as long as one of the supported data access protocols is being used.
0
 
Nakul VachhrajaniTechnical Architect, Capgemini IndiaCommented:
What do you mean when you say "talk to"? Do you want SQL Server to invoke some process that is on another Web Server? Or do you want the Web Server to be able to connect to the SQL Server instance and exchange data with a database on the SQL Server?
0
 
RIASAuthor Commented:
Hello,
Thanks, need to import a 2 columns from a sun system table to sql server 2015.
0
 
RIASAuthor Commented:
Basically, import data from sun system to sql server
0
 
Eugene ZConnect With a Mentor Commented:
get from www.oracle.com drive:  Sun Java System JDBC Driver for Microsoft SQL Server
more:
Using the JDBC API for Database Access
https://docs.oracle.com/cd/E19957-01/819-0079-10/dgjdbc.html

or check MS version of such driver
Microsoft JDBC Drivers 6.0, 4.2, 4.1, and 4.0 for SQL Server https://www.microsoft.com/en-us/download/details.aspx?id=11774
0
All Courses

From novice to tech pro — start learning today.