Your browser does not support JavaScript. This help page requires JavaScript to render correctly. Data Systems Access with Code Templates
Skip Headers
Previous
Previous 		 Next
Next

Data Systems Access with Code Templates

OWB achieves seamless management of JDBC-accessible data systems through its Code Template (CT) technology. Code Templates provide native heterogeneous connectivity to Oracle and JDBC-accessible data systems and disparate platforms. Code templates can be used as an alternative to Oracle Gateways as a means of accessing other databases. In addition to OWB being the best ETL solution for Oracle databases, with OWB you can move data that is located in non-Oracle systems into and out of your project quickly and easily. JDBC connectivity provides an alternative to Oracle Gateways as a means of accessing other databases.

Code Template technology in OWB also provides direct data movement among JDBC-accessible databases, without stopping in an Oracle database in between. For example, if you need to move data from DB/2 to SQL Server for some reason, then you can do so from OWB without moving the data through Oracle at all.


See Also:

Data Access and Movement in Oracle Warehouse Builder Sources and Targets Guide


Note:

When getting ready to generate code for a CT, you must have only the editor open for the CT on which you are focused. Otherwise, when you generate code for the CT, you will get conflicting results.