| Heterogeneous database integrated [message #569666] |
Tue, 30 October 2012 21:49  |
JADYCHEN
Messages: 82
Registered: July 2010
|
Member |
|
|
Hi!! All Experts,
Now I have a question :
I had Application ERP (use Oracle 10g) and another Application PLM(use MSSQL) , I want to
integrated this two application,but I do'nt know how to begin ?? ,
is this any document can study??
Beside , Is Oracle 10.2.0.1 transparent Gateway for MSSQL is free?? or charged?? ,
if free , where to download??
Please help me , I am very appreciated!! , Thanks!!
|
|
|
|
|
|
| Re: Heterogeneous database integrated [message #569669 is a reply to message #569667] |
Wed, 31 October 2012 00:04  |
JADYCHEN
Messages: 82
Registered: July 2010
|
Member |
|
|
Hi!! Dear BlackSwan ,
My expect/desire is :
1. I want to access data from Oracle to MSSQL by trigger , ODBC or Oracle 10.2.0.1 transparent Gateway(OTG)
2. I want to access data from MSSQL to Oracle by trigger , ODBC or Oracle 10.2.0.1 transparent Gateway(OTG)
Is this two way accessible??
|
|
|
|
|
|
| Re: Heterogeneous database integrated [message #569683 is a reply to message #569678] |
Wed, 31 October 2012 05:07 |
JADYCHEN
Messages: 82
Registered: July 2010
|
Member |
|
|
Hi!! Dear John Watson,
Sorry , My expect/desire is not clear , What I need is :
When I insert a BOM bill at ERP(Oracle) , I want to insert same record at PLM(MSSQL) immediately ,
Maybe , there are not same fields at Oracle-MSSQL ,
and I can't to manipulate at Application level , because I can't touch this two application ,
so , I must handle this topic from Database level , to synchronize two database side's data ,
I hope that I had a mechanism to let me meet this goal ...
and this is my challenge , my Oracle is 10g(10.2.0.1) and MSSQL is SQL Server 2012
|
|
|
|
| Re: Heterogeneous database integrated [message #569685 is a reply to message #569683] |
Wed, 31 October 2012 05:19 |
John Watson
Messages: 3181
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
You know, it would have saved people (including you) time if you had said this at the beginning, and raised the topic in the EBS forum.
However:
This is application integration, not database integration. I would do this through Oracle Alert. The alert will have to trigger on the creation of a bill, and then invoke some code to propagate the bill to PLM. Or, if you have pots of money, go through the SOA Gateway or the e-Commerce Gateway. You might find a ready-written interface that uses these. But an Alert is probably the easiest way.
[Updated on: Wed, 31 October 2012 05:20] Report message to a moderator |
|
|
|
] 
Members
Search
Help
Register
Login
Home
