Solved

Systems talking to each other

Posted on 2016-10-08
5
153 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 14

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 14

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 43

Assisted Solution

by:Eugene Z
Eugene Z 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

WordPress Tutorial 4: Recommended Plugins

Now that you have WordPress installed, understand the interface, and know how to install new parts, let’s take a look at our recommended plugins.

Question has a verified solution.

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

Lease-to-own eliminates the expenditure of hardware replacement and allows you to pay off the server over time. Usually, this is much cheaper than leasing servers. Think of lease-to-own as credit without interest.
What You Need to Know when Searching for a Webhost Provider
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Suggested Courses

635 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