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"
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