Zimbra ODBC Connection

[eatickets]

Hey all,

I'm trying to set up the ODBC connections in FileMaker Server 11 Advanced, but I can't find any information regarding using Zimbra's address book database as a MySQL data source. Is this possible?

I already searched the forums and could not find anything, so any help would be greatly appreciated. Please let me know if you need any other information from me.

[Krishopper]

Zimbra's address book isn't stored in a SQL database that you can access.

The GAL is stored in LDAP, and the individual users address books are stored within the mailstore, and indexed within the Lucene indexes. In short, there is no way to access that info through MySQL alone.

[eatickets]

Bummer. Thanks for the heads up though.

As a follow-up: can I set up an ODBC connection between Zimbra and FileMaker in any way? I essentially want the address book information in Zimbra and the user information in FileMaker to sync to each other. Any suggestions?