1 Reply Latest reply: May 11, 2012 5:02 AM by Igor.M RSS

    Using OWB with Teradata as target ?


      Is it possible with OWB 11gR2 to use Teradata as a source target ?
      Which licences are required in that case ?


      Edited by: SweAnderline on 2012-maj-11 11:09

      Edited by: SweAnderline on 2012-maj-11 11:10
        • 1. Re: Using OWB with Teradata as target ?

          7.5 Non-Oracle Database Connectivity
          To connect to non-Oracle databases, you need the JDBC driver corresponding to that database. Non-Oracle JDBC drivers are not shipped as part of Oracle Warehouse Builder software. You can obtain the JDBC drivers from the vendor and copy them to the OWB_HOME/owb/lib/ext folder.
          Table 1 lists the drivers that are required to connect to DB2, SQL Server, and Teradata. For other databases, consult your vendor.


          Oracle® Warehouse Builder
          Sources and Targets Guide
          11g Release 2 (11.2)

          Table 1–1 Sources and Targets Supported in Oracle Warehouse Builder 11g Release 2 (11.2)

          Supported Targets:
          Any database accessible through
          Oracle Database Heterogeneous
          Services, including but not limited
          to DB2, Informix, SQL Server,
          Sybase, and Teradata.