Creating a new technology
ODI comes pre-packaged to cover dozens of technologies. However, there are cases where you want to connect to a less common technology. In this recipe, we will look into how to create a new technology—at least one that is new to ODI. Technologies are defined in the Topology navigator, so all you need to do to get started is to make sure that this navigator has been selected.
Getting ready
What we will do here is create a technology that we will arbitrarily name, My New Database. Obviously, to reproduce the steps described in this recipe, you will need to have enough privileges in ODI to access the Topology navigator.
In this particular case we will reuse the Oracle technology only because we already have the JDBC drivers in place for that. However, the technique would be the same for any other database as long as you can install the JDBC drivers to connect to these databases. We will review this in detail after the following step-by-step instructions.
