Setup Oracle in SQL Server

[NuniPR]

Hi Guys!!!

Ok, so I changed jobs. Now I have a few tasks that didn't have before (duh!) so I need your help once more.

Here's the deal:

Database A = SQL Server
Database B = Oracle DB

I am developing a web application that allows customers to see their account info in real-time.

B is the production DB. All customer information goes into B. The most current info is in B.

A will have web configuration information (i.e. - My Yahoo type of configuration, where you can choose what to see, and even the color of the page), customer username and password, and other information.

Customer information is stored in B. But customer's username and password are stored in A. I need to link these two in order to synchronize them so that when the customer info changes in B, A gets refreshed. In other words, the customer needs to be able to see his/her info in realtime.

The question is, how do link/sync these two systems? I know ODBC is very slow, and in some cases will give errors requiring to restart the SQL Server, which cannot happen since this web portal has to be up 24/7.

Has anyone done it before? What steps need to be taken? Can you give me an example, tell me how or at least point me into the right direction?

As usual, thanks in advance.



Nunina
Cognos BI Administrator
San Juan, PR

 

[SQLDenis]

lookup (linked servers, access Oracle database instance) in BOL

“I sense many useless updates in you... Useless updates lead to defragmentation... Defragmentation leads to downtime...Downtime leads to suffering..Defragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/

 

[NuniPR]

Thanks!

Nunina
Cognos BI Administrator
San Juan, PR