Replicating Oracle with SQL

[julianf]

Howsit,

This is a bit complex...but here it goes...

I work for a hotel. Our reservations package is Micros Fidelio Front Office and it runs on an Oracle 8 DB.

The hotel has a website, which also provides an online-bookings facility. (Which does not plug directly into Fidelio)

At present, the online bookings form a SQL database and is just for clients to make general booking requests. All info is stored in the SQL DB and then viewed by the reservations staff when they want. There is not much automation.

I would like to give clients the ability to view the hotels availability figures from the website. To do this, some kind of interface/replication solution is needed between the Fidelio Oracle DB and the websites SQL DB. I thought of setting up replication between the Oracle and Fidelio, and replicating the "availability info"...then the website would be able to display the replicated info in real-time. (Availability figures must be real-time).

Does anyone have more info on this or a possible solution.

Much appreciated,

Julian

 

[Swany]

Why not just connect to the oracle database from the web server using ADODB (I assume you are using IIS and ASP) and run queries against it?

You will need to install the oracle client on the web server and set up your tnsnames file, then you should be
able to use ASP to connect to your oracle database. .
.. Eat, think and be merry .
... ....................... .

 

[julianf]

Hi Swany,

Tks for the info - The only issue with your solution is that the website is hosted at a off-site. We are connected to them via VPN - but it is not that fast.

I would have to look at replicating the Oracle tables accross the VPN or something like that.

Any ideas?

Regards,

Julian

 

[sem]

On 9.2 you may try so called CHANNELS, a new technology, that allows logical replication (logging updates not via changes in database blocks but also by storing source sql statements). It may be used (or at least it's said so) to replicate data to non-Oracle databases. Though I did not try it so have no real life expperince in it.

Another idea is to run some job, that queries Oracle tables and makes appropriate changes in SQL via jdbc or http(s). I'd suggest you to do not use triggers for some reasons (possible connection lost, managing transactions...).

Unfortunately this task needs some coding
Regards, Dima

 

[emso]

Hi,

There are also the possibility to conenct to one of the professonial providers of Internett bookings.

Some of these has interfaces to Fidelio, but it requires a interface fee from Micros-Fidelio....

Please tell how you solved this...