OTG or Oracle Transparent Gateway is a tool used to communicate with non-Oracle products (may be other databases like DB2) and technologies. Using OTG, we can access data in remote DB2 using Oracle's PL/SQL syntax. OTG has DRDA gateway which connects with DB2. If you want to connect to other databases like Sybase n all, you can use other gateways.
To use a gateway, we need to first install it( quite obvious). After installation, we need to configure it which is a tedious task even if we try to do it by reading manuals.( I've been working on it for 3 days, still no progress).
Well, thats all i know about it but I will surely write about the configuration in my next post. So wish me luck :).
No comments:
Post a Comment