Connect. Communicate. Collaborate. Securely.

Home » Kerio User Forums » Kerio Connect » How to access kerio databases from a sql databsase (I want to tie together kerio with some home-grown sql databases ... how?)
  •  
dlethe

Messages: 1
Karma: 0
Send a private message to this user
This is a pre-sales question to see if kerio makes sense for what I am trying to do.

FIrst, I like kerio feature set as I want a shared contact/collaboration system that plays well in an environment with Macs, Windows, and other *Nix's

My problem is that I am working with a school that has an extensive database for student records, activities, all the things that one would expect a school to keep track of.

I want to automate a way to do some EDI between the kerio contact database and the sql-based internal database.

Example, I add a student ID to a user-defined field in the kerio contact record for a parent, and if the parent's phone number changes, I want to be able to run some code (that needs to be written) that exports what has changed so the student database doesn't have to be manually updated with the new phone number or whatever else changes. (And opposite is true).

is there a product or mechanism that can drill down into kerio and do custom reports/queries / import expoort?

  •  
marook

Messages: 520

Karma: 3
Send a private message to this user
Hmm, not that way it's done - as I'm aware.

Kerio does two things:

1: Hook users up to an external LDAP (AD or OD) database.

2: Store flat files (indexed) with all the mails etc. in them.

So, I guess I would focus on making sure the students update their 'school record/account' in the ritgh system, and then Kerio will reflect that change in the Global Address List..

Hope it helps,

Regards,

Jakob Peterhänsel
Consultant - Humac A/S

Apple Certified Support Professional (ACSP)
Apple Certified Technical Coordinator (ACTC)
AppleSeed/CQF member since 1998
Kerio Messaging Partner
Previous Topic: how make the stroe files on shared san storage
Next Topic: Blacklist check for all "Received by" headers?
Goto Forum:
  


Disclaimer:
Kerio discussion forums are intended for open communication between forum members and may contain information and material posted by members which may be useful in learning about Kerio products. The discussion forums are not intended to provide technical support for any specific product. Any information implied or expressed in the discussion forums is that of the posting member. Kerio is in no way responsible for the information posted in the forums, or its accuracy. Kerio employees may participate in the discussions, but their postings do not represent an offical position of the company on any issues raised or discussed. Kerio reserves the right to monitor and maintain the forums to promote free and accurate exchange of information.

Current Time: Mon Nov 20 08:39:32 CET 2017

Total time taken to generate the page: 0.00383 seconds
.:: Contact :: Home ::.
Powered by: FUDforum 3.0.4.