Postgres as CustomerBackend

Hi, I have successfully have the external mySQL DB of phprojekt (www.phprojekt.com) to OTRS for use as customer backend I wonder if the same is possible for the PostgreSQL DB? It is not needed for authentication, only Customer search e.g in PhoneView Thanks for your help. best regards, matthias

Hi Matthias, On Thu, Oct 30, 2003 at 11:29:50AM +0100, Matthias Krey wrote:
I have successfully have the external mySQL DB of phprojekt (www.phprojekt.com) to OTRS for use as customer backend
I wonder if the same is possible for the PostgreSQL DB? It is not needed for authentication, only Customer search e.g in PhoneView
Of course! .-) You can use a PostgreSQL, SAPDB, MSSQL, ODBC, ... you just need a perl DBI/DBD driver. The Kernel/Config.pm should look like this: [...] $Self->{CustomerUser} = { Module => 'Kernel::System::CustomerUser::DB', Params => { # if you want to use an external database, add the # required settings DSN => 'DBI:odbc:yourdsn', User => 'user', Password => 'pass', Table => 'customer_user', }, # customer uniq id CustomerKey => 'login', [...]
best regards, matthias
Martin -- Martin Edenhofer - <martin at edenhofer.de> - http://martin.edenhofer.de/ -- Old programmers never die. They just branch to a new address.
participants (2)
-
Martin Edenhofer
-
Matthias Krey