Solved

Systems talking to each other

Posted on 2016-10-08
  • Java
  • Routers
  • Networking
  • Web Servers
  • MS SQL Server 2008
  • +1
5
107 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 11

Expert Comment

by:Nakul Vachhrajani
Comment Utility
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
Comment Utility
Hello,
Thanks, need to import a 2 columns from a sun system table to sql server 2015.
0
 

Author Comment

by:RIAS
Comment Utility
Basically, import data from sun system to sql server
0
 
LVL 11

Accepted Solution

by:
Nakul Vachhrajani earned 250 total points
Comment Utility
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
Comment Utility
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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

When it comes to security, there are always trade-offs between security and convenience/ease of administration. This article examines some of the main pros and cons of using key authentication vs password authentication for hosting an SFTP server.
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This tutorial will introduce the viewer to VisualVM for the Java platform application. This video explains an example program and covers the Overview, Monitor, and Heap Dump tabs.
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.

743 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now