Solved

Write to an MSSQL database from an Oracle Trigger

Posted on 2007-11-19
7
680 Views
Last Modified: 2013-12-19
I want to write to an MSSQL server database from an Oracle trigger. Is there a way that I can achieve that ?

Thanks
0
Comment
Question by:cscg1976
7 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 20311391
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.
0
 

Author Comment

by:cscg1976
ID: 20311409
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 ?
0
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 20311475
0
Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

 

Author Comment

by:cscg1976
ID: 20312200
I have an Oracle Express Database and I want to update an MSSQL database using Oracle Triggers. Can i do that using heterogeneous services ?
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 20312236
AFAIK, you cannot use heterogeneous services with the oracle express edition.
0
 
LVL 42

Expert Comment

by:EugeneZ
ID: 20313459
0
 
LVL 1

Expert Comment

by:michaeljoneill
ID: 20361994
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.
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

Suggested Solutions

Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
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.

746 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

12 Experts available now in Live!

Get 1:1 Help Now