
Hi Gerold, There are few ways to integrate your existing customer database with OTRS. The easiest way is to copy from Kernel/Config/Defaults.pm $Self->{CustomerUser} and $Self->{CustomerCompany} sections, to place them in Kernel/Config.pm and to modify them according to your needs. The drawback in this case is that you have to support different databases and is not possible to have real foreign keys. I personally think that foreign keys and their database native support is one of the most important features for relational databases. Another solution is to place data from both databases in a single database. If you use Postgresql this can be done very easy by using schemas. Schemas allow you to have different name spaces in a single database, thus having foreign keys and all of the extras. Different applications can be put into separate schemas so they cannot collide with the names of other objects. More about database schemas you can find here: http://www.postgresql.org/docs/8.3/static/ddl-schemas.html When you have more than one schema, your SQL statements have to use "Schema.Table" notation or you have to set the variable "search_path". More on this variable you can find here: http://www.postgresql.org/docs/8.3/static/ddl-schemas.html#DDL-SCHEMAS-PATH If you decide to use solutions with database schemas, you have to set the following in your Kernel/Config.pm: $Self->{'Database::Connect'} = 'SET search_path TO <your-otrs-schema-name>'. You still have to configure $Self->{CustomerUser} and $Self->{CustomerCompany} sections in Kernel/Config.pm In our case we hold customers data in few tables, so I decided to drop the tables customer_user and customer_company and to replace them with views over my tables, having the same column names as the original tables. In order to be able to update some fields from OTRS interface I created database rules. More about rules: http://www.postgresql.org/docs/8.3/static/rules-update.html I hope this will help. Best Regards, Atanas Karashenski