Depends....
Robert, February 21, 2007 - 11:51 am UTC
If Oracle is on *nix, the simplest way is thru ODBC, just google it, only one vendor makes it really.
re "screen shots" :
thanks for making me nearly spit coffee all over the keyboard
Oracle on *nix & HS
Duke Ganote, February 21, 2007 - 1:38 pm UTC
At a former employer, the DBAs configured Oracle on a small networked PC, dedicated to Heterogeneous Services (in our case, data pulls from DB2). As much as the DBAs liked *nix, at that time, setting up a PC with Oracle was cheaper and faster than getting ODBC drivers on *nix.
A reader, February 21, 2007 - 3:01 pm UTC
Sudheer,
I got a better idea why not provide Tom a VPN connection so you can watch while he configures :-)
Rahul.
Just load JDBC into Oracle
Kurt Look, February 21, 2007 - 9:10 pm UTC
What we did was load JDBC into Oracle. We then wrote Java routines callable from PL/SQL that connect to SQL Server, query tables, close the connection, etc. It works reliably and performance is fine.
February 22, 2007 - 8:36 am UTC
if you like writing java code all of the time, sure.
Me, I'd rather just be able to query it using SQL from any environment - for that reason the generic connectivity is very nice.
JDBC vs HS
Duke Ganote, March 08, 2007 - 6:57 pm UTC
March 08, 2007 - 8:51 pm UTC
hmm, why would jdbc (something written in java doing the OCI protocol under the covers) be necessarily faster than odbc (something written in C using the native OCI drivers)
And tell me how fast that dba could code the java for:
insert into local_table select * from remote_table@dblink;
?
A reader, March 09, 2007 - 9:33 am UTC
yeah, right
Robert, March 09, 2007 - 12:30 pm UTC
>> Duke Ganote said
>> setting up a PC with Oracle was cheaper and faster than getting ODBC drivers on *nix.
ummm, that PC is not donated and you're paying for the license on that DB right ?
>> A reader said:
>> Or use MS SQL Server's DTS tool to move the data between the databases.
Only if you're 100% Windows there, unfortunately
Duke replies...
Duke Ganote, March 11, 2007 - 7:58 pm UTC
Duke Ganote said: setting up a PC with Oracle was cheaper and faster than getting ODBC drivers on *nix.
To which Robert said: ummm, that PC is not donated and you're paying for the license on that DB right ?
Duke replies: As I recall, we'd just gotten through our periodic replacement of PCs, and they just used one of the "old" PCs. I'm not the licence guy, but we did have an enterprise license.
HS and XE ?
Duke Ganote, March 12, 2007 - 9:39 am UTC