• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 700
  • Last Modified:

Write to an MSSQL database from an Oracle Trigger

I want to write to an MSSQL server database from an Oracle trigger. Is there a way that I can achieve that ?

1 Solution
Guy Hengel [angelIII / a3]Billing EngineerCommented:
only if you have heterogeneous database in place, so that you can query the ms sql server database from oracle.
this is not trivial, though.
cscg1976Author Commented:
Is there a way that i can integrate the 2 systems if it's 2 difficult to be implemented with heterogeneous databases ?

How difficult is to implement it with heterogenous databases ?

Do you have more resources that i can use to find out how to implement this ?
A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

cscg1976Author Commented:
I have an Oracle Express Database and I want to update an MSSQL database using Oracle Triggers. Can i do that using heterogeneous services ?
Guy Hengel [angelIII / a3]Billing EngineerCommented:
AFAIK, you cannot use heterogeneous services with the oracle express edition.
Eugene ZCommented:
This is trivial to do.  It is called Service Oriented Architecture (SOA).  Deploy a simple web service (in the language of your choice) that is invoked by the Oracle trigger code.  PL/SQL can HTTP POST with whatever parameters you want very easily.  Then have the web service connect to your SQL Server database and "write" whatever is appropriate.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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