Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeArchived Discus...Archived Discus...Developing Under Previous Versions of .NETDeveloping Under Previous Versions of .NETASP.Net 2.0ASP.Net 2.0Integrating with Siebel 7.8 / OracleIntegrating with Siebel 7.8 / Oracle
Previous
 
Next
New Post
10/27/2006 4:38 AM
 
I have a UK client with 150,000 customer records in Siebel, but they want to use the DNN application we have developed, and they want to use the customer records from the Siebel/Oracle database.

Possible?  Any thoughts.


If it is possible there is a project that I will need to resource to build the integration.
 
New Post
10/27/2006 5:17 AM
 

there are various approaches possible for integration depending on concrete ncessicities of the integration:

  • A custom membership provider for DotNetNuke ca be used, so DNN directly reads account information from Siebel
  • Another approach would be to replicate necessary user information after each change from Siebel to DNN
  • possible techniques for data exchange include direct database access, common business objects and web services

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
10/27/2006 5:47 AM
 
Sebastian

I saw the options were
 1. replicating data..   unacceptable from the clients perspective
 2. access the Customer/Member data in Oracle directly (bypassing Siebel)
 3. using Siebel API to get and put Customer/Member data

Option 1. unacceptable.. so
Option 2.  Using AcuityDB ?  If so, where does the other DNN data live (Forum, Events, Library).  In SQL or create other dables in Oracle...
Option 3.  What would we use to drive the Siebel API?  A custom module?

Preferred approach is Option 2.  AcuityDB seems to be a proven & tested approach.

Key points. 
- We have extended the standard member data adding a number of extra fields (all of which are currently exist in Siebel)
- We are using 3rd party modules for Member Groups

We are at the early scoping / feasibility stage of the work.  If we build the integration, whatever the approach, the client will pay for the work.  But I need to say it is even possible before they investigate using our application further.


 
New Post
10/27/2006 10:33 AM
 

I have a bit of experience with integrating Siebel (though not with DNN) and a bit of experience building and integrating DNN apps.

The first question you need to answer is are you looking for real time integration or batch integration with Siebel.

If you want real time integration you'll probably need to build a custom membership provider. That custom provider will integrate in one of 2 ways. You can either use Siebel Integration Objects which are EAI xml messages sent back and forth. This is Siebels most recommended way but also requires the most Siebel configuration and expertise. The other way to build this is to do all reading through Siebels base database tables and all writing through Siebels business object layer using DotNet and COM interop. You could do all reading and writing through the Business Object layer but in my experience that can be very slow. This is why I prefer to read directly from the database and write through the object layer. What you cannot do is write directly to the database. Siebel does not support base table updates and you will invalidate Siebel support if you build applications that do that.

If you can get away with batch updating Siebel has something called EIM which allows you to load data into staging tables for importing and exporting data. You could write stored procedures to import/export on these EIM tables on a nightly basis. The batch update requires a bit less effort involved in the integration.

 
New Post
10/27/2006 12:28 PM
 
Lee

Another approach would be to keep with SQL as the DNN database and build an sychronisation app whcih runs nightly, bearing in mind the memberhip data is unlikely to be very volatile - name, address, work history, qualifications, personal stuff.

One approach is then to use SQL Server Replication.  Question is, would this invalidate Siebel support, and would this be easier than using EIM.  I assume all the contact details are in one table in boith Siebel (Oracle) and DNN (SQL)?

I think that the client wants to move forward, so I can sense a dev project in here :-))

TIA for the support.
 
Previous
 
Next
HomeHomeArchived Discus...Archived Discus...Developing Under Previous Versions of .NETDeveloping Under Previous Versions of .NETASP.Net 2.0ASP.Net 2.0Integrating with Siebel 7.8 / OracleIntegrating with Siebel 7.8 / Oracle


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out