O'Reilly logo

Oracle Warehouse Builder 11gR2: Getting Started 2011 by Bob Griesemer

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Connecting to SQL server using a JDBC database connection

A feature that the code templates bring to OWB is the ability now to make connections natively to other data sources. One of those connection options is the ability to make native connections to remote databases using Java Database Connectivity, or just JDBC for short.

Note

Code templates are a framework for using arbitrary APIs to connect to any number of alternative data sources. There is a knowledge module in ODI for making a connection to an Essbase database, which can be ported over to use in OWB, and some OWB users have even integrated PDF files into OWB using code templates.

By native connectivity, we mean being able to connect directly to the remote database without having to go through ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required