Solved

Systems talking to each other

Posted on 2016-10-08
  • Java
  • Routers
  • Networking
  • Web Servers
  • Microsoft SQL Server 2008
  • +1
5
141 Views
Last Modified: 2016-10-26
Hello,

Is it possible to make sql server 2015 talk to Sun Java System Web Server.
Cheers
0
Comment
Question by:RIAS
  • 2
  • 2
5 Comments
 
LVL 13

Expert Comment

by:Nakul Vachhrajani
ID: 41835318
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
 

Author Comment

by:RIAS
ID: 41835327
Hello,
Thanks, need to import a 2 columns from a sun system table to sql server 2015.
0
 

Author Comment

by:RIAS
ID: 41835329
Basically, import data from sun system to sql server
0
 
LVL 13

Accepted Solution

by:
Nakul Vachhrajani earned 250 total points
ID: 41835377
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
 
LVL 42

Assisted Solution

by:EugeneZ
EugeneZ earned 250 total points
ID: 41835473
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

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to set-up an On Demand, IPSec, Site to SIte, VPN from a Draytek Vigor Router to a Cyberoam UTM Appliance. A concise guide to the settings required on both devices
In this article, I am going to show you how to simulate a multi-site Lab environment on a single Hyper-V host. I use this method successfully in my own lab to simulate three fully routed global AD Sites on a Windows 10 Hyper-V host.
This theoretical tutorial explains exceptions, reasons for exceptions, different categories of exception and exception hierarchy.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question