Solved

Systems talking to each other

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

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 12

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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

PRTG Network Monitor lets you monitor your bandwidth usage, so you know who is using up your bandwidth, and what they're using it for.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…

773 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