 Oracle AS/Integration [message #146278] |
Wed, 09 November 2005 12:35  |
Intr
Messages: 1
Registered: November 2005
|
Junior Member |
|
|
Hi, could u advise me on the following?
There are 2 sites
1st one has someone data source
2nd owns Oracle Database
comm. channel is not great
I'm looking for a kind of software channel with api, meaning that data is put in at the 1st site and pulled out at the 2nd site and then put into Oracle Db
For instance if we had oracle database installed on the 2nd site we would use adv. replication or Oracle Streams. But what to do if we don't have oracle db on the 2nd site?
Has Oracle AS/Integration such technologies?
|
|
|
|
| Re: Oracle AS/Integration [message #146664 is a reply to message #146278] |
Fri, 11 November 2005 19:28  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
The site not having Oracle could still have an Oracle client. Using that, it could insert/extract data from Oracle.
From pl/sql, you could use UTL_TCP to FTP a file or you could use UTL_HTTP to suck a text or HTML file into Oracle from a remote web server.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
