ODI - Reverse engineering Salesforce

About

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

<WRAP warning>In progress</note>

Prerequisites

  • Version 10.1.3.5.5

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:

  • Restart ODI (if no Agent: in local)
  • Restart the Agent

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” .


Powered by ComboStrap