CONNECTING TO MICROSOFT SQL SERVER DATABASE FROM ORACLE USING DATABASE GATEWAY USING SQL SERVER GATEWAY FOR ORACLE

Author:-SOUMEN KUMAR DAS   Connecting to Microsoft SQL Server database from Oracle using SQL SERVER GATEWAY FOR ORACLE   Hostname Port DB Name Oracle Database (Source) esesslxXXXX.world 1521 ORAPROD1 SQLSERVER Data base (Target) ESESSMW9999.world 1433 SQLDB_PROD Oracle Gateway esesslxXXXX.world 1522 DG4MSQL   Following steps are involved.. Download Oracle Database Gateways CD if you have notContinue reading CONNECTING TO MICROSOFT SQL SERVER DATABASE FROM ORACLE USING DATABASE GATEWAY USING SQL SERVER GATEWAY FOR ORACLE

Database Link Oracle to Heterogeneous Database Systems SAP HANA

1 Background Often in many IT projects (involving Oracle as the primary RDBMS), we face an issue of bringing data from disparate systems. Now, the problem can be solved by implementing any ETL solution which has the required connectors/drivers to connect to different heterogeneous database systems and pull the required data. Often situation demands thatContinue reading Database Link Oracle to Heterogeneous Database Systems SAP HANA