Thank you for responding..
The external database is a separate postgreSQL server. I am using the
DB::Pg driver already for OTRS.
I really wish I could do away with exchange. This is one in many steps. We
were using public folders for ticket tracking.
>>datasource
schema in config.pm, in the "Map" array definition, within the
"CustomerUser
Stuff" section...<<
Our external Data is more in a Company format, so I would leave the User
specific stuff to the already configured ldap lookups to our active
directory and associate those users to the external db for Company data.
I do apologize I am poking into the unknown here with my limited knowledge
of how to format a schema and field mappings to connect the external
database. I would probably have a better understanding if I could get an
example of a schema and mapping of a Company in the Config.pm.
Linking to an exchange server public folder was just a thought but not realy
desired. Ill forego that idea.
Re: [otrs] External Company DB and Exchange Contacts
Mike Morris
Thu, 11 Sep 2008 11:19:49 -0700
It's hard to tell from your post if this will be obvioius to you or not...
but
the first
question is:
* Do you have a driver that allows perl access to your datasource (at an
acceptable performance level)??? I have no idea if this is the case for
Exchange or not... we became a Microsoft Free shop many years ago and I
know nothing of Exchange anymore. (We're also happier, more profitable
and more efficient, btw...)
* If the answer is yes, then it's mostly a matter of defining the
datasource
schema in config.pm, in the "Map" array definition, within the
"CustomerUser
Stuff" section...
I don't remember much more than that... hope it helps
On 11/09/08 10:55 AM, "Mik Rose" <[EMAIL PROTECTED]> wrote:
>
> Hi there list members,
>
> External/Separate Company DB's;
> After a fare amount of time poring over user posts in the mail list archives
> it appears that it is possible to reference Company information from our own
> database. What I think I need is an example of this being done. Is there
> anyone that could post an example of this being done.
>
> Exchange Contacts;
>
> Is it possible to devise a lookup and link in tickets to a contact on an
> Exchange Public folder?
>
> Regards,
>
> Mikola (Mik) Rose
> PowerSoft Development Corp.
> CIO, Information Technology / Support Services
> Customer Service: 1 (250) 642-0199
> Sales Dep.: 1 (888) 833-7697
> Support Dep.: 1 (250) 642-0295
> www.power-soft.com
Mikola (Mik) Rose
PowerSoft Development Corp.
CIO, Information Technology / Support Services
Customer Service: 1 (250) 642-0199
Sales Dep.: 1 (888) 833-7697
Support Dep.: 1 (250) 642-0295
www.power-soft.com
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
