Table of Contents

ODI - Reverse engineering Salesforce

About

Reverse engineering to retrieve the tables, views, system tables and columns from Salesforce.

In progress

Prerequisites

Steps

Import of the technologie

In topology, import the salesforce.com technologie if not present : TECH_Salesforce.com.xml

Drivers

From the Java Quick Start kit, extract the quickstart.jar and copy it in the driver location: 

Odi_Home\oracledi\drivers

AppExchange Data Loader

Download the Apex Data Loader

Creation of the data server

Enter only the user and the password. Quickstart is not a JDBC driver.

Support

ImportError: No module named sforce

The quickstart driver is not loaded:

To load the driver

UNKNOWN_EXCEPTION: Destination URL not reset

Patch 8636504 must be installed - Customized reverse-engineering using RKM Salesforce.com fails with the error “UNKNOWN_EXCEPTION: Destination URL not reset. The URL returned from login must be set in the SforceService” .