Bill Bailey wrote:
Hi,
I noticed on the list of features an item indicating that data
interoperability plug-ins are available to allow the use of an RDBMS
as a data source, but I’m having trouble locating the specifics (e.g.
which databases, what sort of integration, etc.) in the documentation.
Anyone have any pointers on where I can find more information on this?
http://directory.fedora.redhat.com/wiki/FAQ#Can_I_replace_Sleepycat_with_...
There are no plug-ins available. The plug-in architecture will allow
this, but someone must write some C code in order to be able to do this.
In particular, I’m struggling with whether to use a directory server
for user management or a database. If I store users in my LDAP
directory (e.g. username, password, name, address, phone, etc.), there
is still user data that I need to store in a database (e.g.
transaction data or other frequently modified data) … and I need to be
able to correlate the two. For example, for reporting I may need to
display both the basic user info and demographic information that is
so well suited for a directory alongside data that comes from a
database. This seems to me problematic since the data models and query
languages are different. And even if I could make the LDAP data look
like something I could query with SQL … and join with real RDBMS
tables … it would seem likely that performance might be less than great.
My thinking is that if I could get the LDAP server to use e.g. MySQL
under the covers for storage, but I could still get access (read-only)
to the underlying tables, I might be able to have the best of both
worlds (assuming the underlying table structure was amenable to being
joined to my tables without to many contortions). I’m guessing my
dilemma isn’t new … has anyone else struggled with this and, if so,
how did you resolve it? And have been satisfied with the solution you
selected?
Thanks for any input or comments.
Bill Bailey
------------------------------------------------------------------------
--
Fedora-directory-users mailing list
Fedora-directory-users(a)redhat.com
https://www.redhat.com/mailman/listinfo/fedora-directory-users