How To Configure SQLSERVER or MYSQL OWB 11.2 JDBC Location to Access Tables with Huge Amount of Rows (Doc ID 1365904.1)

Last updated on MAY 09, 2017

Applies to:

Oracle Warehouse Builder - Version 11.2.0.1 and later
Information in this document applies to any platform.

Goal

In OWB 11.2, the Location URL is configured to use the JDBC URL properties default. 

This note explains how to configure the Location URL when accessing SQLServer/MySQL table with huge amount of rows.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms