We are working on batch integration with Oracle eBusiness Suite. Basically, we just want orders/sales history captured in Oracle to be available (view only) in Salesforce.com.

Right now, we're planning to build a custom object in Salesforce.com, pull a nightly extract from Oracle which will feed into the custom object, and then create customer ID's in Salesforce.com accounts that can be used to create a "related list" view of our Oracle information in Salesforce.com.  We will write a bit of sForce code to import the Oracle extract each evening into SF.com.

What are your thoughts on this approach?

One issue we are going to have is with customer ID's. In Oracle, there will clearly be multiple copies of some customer records with different IDs. Has anyone developed a best practice for resolving this situation? Is it better to dynamically create our own ID (based on zip code / address), use the existing customer ID from Oracle (with the understanding that this will not fully link in all necessary data), or is there another approach that we're missing here?

Thanks for any words of wisdom.

Hi,

We would like to deliver a dependant picklist for a client - and would prefer not to wait until this becomes available as an option in the standard Salesforce.com functionality.  Does anyone have an example of the integration code that needs to be developed for this purpose (preferably in VB.NET or C#.NET).

Many thanks for any help that can be offered.

Amber

We are working on batch integration with Oracle eBusiness Suite. Basically, we just want orders/sales history captured in Oracle to be available (view only) in Salesforce.com.

Right now, we're planning to build a custom object in Salesforce.com, pull a nightly extract from Oracle which will feed into the custom object, and then create customer ID's in Salesforce.com accounts that can be used to create a "related list" view of our Oracle information in Salesforce.com.  We will write a bit of sForce code to import the Oracle extract each evening into SF.com.

What are your thoughts on this approach?

One issue we are going to have is with customer ID's. In Oracle, there will clearly be multiple copies of some customer records with different IDs. Has anyone developed a best practice for resolving this situation? Is it better to dynamically create our own ID (based on zip code / address), use the existing customer ID from Oracle (with the understanding that this will not fully link in all necessary data), or is there another approach that we're missing here?

Thanks for any words of wisdom.