Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 166
  • Last Modified:

Systems talking to each other

Hello,

Is it possible to make sql server 2015 talk to Sun Java System Web Server.
Cheers
0
RIAS
Asked:
RIAS
  • 2
  • 2
2 Solutions
 
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
 
Nakul VachhrajaniTechnical 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
 
Eugene ZCommented:
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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now