communicate Oracle to Sybase database - Heterogeneous Connectivity

hi,
how to connect the one database(oracle) to other database
(Sybase......) through the sql prompt..
how to operate the DML/TCL Commands in above case...
IT'S RK 

You can use the Transparent Gateway for Sybase to connect from an Oracle client to Sybase.
For more information on how to set this up please refer to the following manuals:
-- Heterogeneous Connectivity Administrator's Guide v9.0.1(http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/server.901/a88789/toc.htm)
-- Oracle9i Transparent Gateway for Sybase Administrator's Guide (http://otn.oracle.com/docs/products/gateways/content2.html) 

hai,
The links are not available which you are provide..
if u know some other links pl let me know.....
Itsrk.

For more information on how to set this up please refer to the following manuals:
-- Heterogeneous Connectivity Administrator's Guide v9.0.1http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/server.901/a88789/toc.htm -- Oracle9i
Transparent Gateway for Sybase Administrator's Guide http://otn.oracle.com/docs/products/gateways/content2.html

Related

Create dblink in Oracle/Linux (RHEL4) to MS SQL Server/Windows?

Hi,
Can anyone share me the procedure to Create dblink in Oracle/Linux (RHEL4) to MS SQL Server/Windows?
Thanks 
Hi,
to access non-Oracle systems you must use Oracle Heterogeneous Services.
You have to follow the instructions from Heterogeneous Connectivity Administrator's Guide to perform it.
Regs,
Acr

How to setup a DBLink between Oracle 11g Database to Microsoft SQLServer?

Hi All,
We need to setup a dblink between orace database to microsoft sql server.
I have 2 questions.
1) Is it possible to setup sblink between oracle and micorsoft sqlserver?
2) If yes, what are the steps to achieve the same.
Thanks in advance.
Sachin 
Sachin,
Yes, this is possible. You can use either the Database Gateway for SQL*Server or the Database Gateway for ODBC.
There are differences in the functionality and licensing for both gateways and you can find further information in these notes available on My Oracle Support -
Master Note for Oracle Gateway Products (Doc ID 1083703.1)
Note.233876.1 Options for Connecting to Foreign Data Stores and Non-Oracle Databases
Note.252364.1 Functional Differences Between DG4ODBC and Specific Database Gateways (Doc ID 252364.1)
Note.232482.1 Gateway and Generic Connectivity Licensing Considerations
and the Gateways website here -
http://www.oracle.com/technetwork/database/gateways/index.html
The note 1083703.1 has links to further information, including the documentation and notes on how to download, install and configure the gateways.
Have a look at these notes and site then get back if you have any specific questions.
Regards,
Mike 
If the integration is small you could use Java Stored Procedures. I did it once to talk to a Sybase DB from Oracle.

DB2 on mainframe

Hi,
We are having DB2 v5 on OS390 box. We want to connect to that using Oracle Transparent Gateway. We have Oracle 9i. Does that support DB2 v5?
Regards
Ashok 
Perhaps you can find out that information here:
Heterogeneous Connectivity Administrator's Guide Contents / Search / Index / PDF
http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96544.pdf
Joel Pérez

Oracle Data Warehouse Builder - direct connection via JDBC / ODBC

I would want to bind an "other DB than Oracle", but:
1. I don't know where to define the connection via JDBC
2. The ODBC-Configuration point to / refer to the Oracle installation
Is there any document about it ?
Regards,
Michel 
Michel,
OWB support access to non-Oracle databases with Oracle Heterogeneous Services.
For setting up access over ODBC/OLEDB loook at Oracle Database Heterogeneous Connectivity Administrator's Guide, chapter "7. Generic Connectivity":
http://download.oracle.com/docs/cd/B19306_01/server.102/b14232/gencon.htm#sthref343
As I know OWB doesn't support direct connection over JDBC.
Regards,
Oleg

Creating Database link from Oracle9i to SQL server 2000

Pls how do I create connectivity from Oracle9i database to query a table in an SQL server 2000 database.
Pls I need the necessary steps to take.
Thanx 
There are 2 solutions that you can use:
1) Transparent Gateway for SQL Server
2) Generic Connectivity
Generic Connectivity is free with the database but has less features than the Gateway. For Generic Connectivity you will need to obtain an ODBC driver.
The steps for using the gateway are available in the gateway manual and the steps for using Generic Connectivity is available in Chap 7 of the Heterogeneous Connectivity Administrator's Guide. 
Heterogeneous Connectivity Administrator's Guide Contents / Search / Index / PDF
http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96544.pdf
Joel P�rez 
or you can link a linked server in SQLSERVER to get directly connection from SQLSERVER to Oracle.
In Corporate Administrative > Security
you are going to find that option.
Joel P�rez

Categories

Resources