Multiple Information Sources for Single Customer Record

[adupre01]

Our current setup uses LDAP to authenticate Customers and Agents. Currently in LDAP we have first and last name, username, password, and email. In a different database (Oracle) we have office location, employee ID, telephone and other info.

My question is; is it possible for OTRS to use multiple data sources but maintain a single record for each individual customer?

From what I've read in the manual and the very little I know about databases I would think that it doesn't work this way. That, if we have multiple data sources, then each entry in both databases will end up being an individual customer in OTRS causing duplicates with incomplete records?

Am I making sense?

[CSL]

There is the possability to use a different, external database for ALL customer information, but not part of it. You need to have all customer information in the same database, whether you use the default one or an external one.

I think your best bet here is to import the data from the external database into the default one. This is the 'customer_user' table within the OTRS database. I'm not sure of the details of how you could do this, but it will probably involve exporting the data from Oracle into an SQL file, and then editing it to match the names of the tables and columns in the OTRS database, before running it to import. I think I found a script someone had written to do this a while ago, but can't remember where. Searching for one on google may turn up some useful results.

[adupre01]

Thanks, that is kind of what I thought. I will google around for importing.

[crythias]

Did you mean this? viewtopic.php?f=62&t=12410