A
Adarsh Atikukke
Hello everyone,
I have a strange need and am trying to figure out what (if any) technology
can help me with this. Any input will be very helpful and greatly appreciated.
One of my clients has multiple offices located all over the country. The
way everything exists right now is that all of these offices have information
about their contacts in a very distributed environment, some on the local
servers at each branch office, some in the main office, some in a database on
AS/400, etc. One of the requirements is that queries be performed against
these contacts to obtain specific information about them, and therefore we
would like to have ALL of the contact information in one central database.
This in itself is not the problem. The problem is that this central database
needs to be the source for the "contacts" in Outlook, i.e., Exchange (2003)
needs to derive the contact information from this central database.
This may be an Exchange issue as much as it is an Access issue. I would
like to know if there is some way of bridging Access with Exchange to have
Exchange obtain the contacts from the Access Database (or for that matter
another database, say DB2). I am looking for some kind of lead as to what
technology (APIs, programs, etc.) will help me with this situation. We are
open to (and we will need to) coding an enterprise application that would
drive the integration, however, we are clueless as to how technology will
allow me to get Exchange talking to Access.
I am given to understand that Lotus Domino does allow you to do some kind
of integration/synchronization with DB2 with regards to the contacts, etc.
However, I would hate to believe that the only way to go about this thing is
to migrate to Domino - do I really need to migrate away from Microsoft to
achieve this? That's a little tough to believe...
Suggestions please...
Thank you.
Sincerely,
Adarsh
I have a strange need and am trying to figure out what (if any) technology
can help me with this. Any input will be very helpful and greatly appreciated.
One of my clients has multiple offices located all over the country. The
way everything exists right now is that all of these offices have information
about their contacts in a very distributed environment, some on the local
servers at each branch office, some in the main office, some in a database on
AS/400, etc. One of the requirements is that queries be performed against
these contacts to obtain specific information about them, and therefore we
would like to have ALL of the contact information in one central database.
This in itself is not the problem. The problem is that this central database
needs to be the source for the "contacts" in Outlook, i.e., Exchange (2003)
needs to derive the contact information from this central database.
This may be an Exchange issue as much as it is an Access issue. I would
like to know if there is some way of bridging Access with Exchange to have
Exchange obtain the contacts from the Access Database (or for that matter
another database, say DB2). I am looking for some kind of lead as to what
technology (APIs, programs, etc.) will help me with this situation. We are
open to (and we will need to) coding an enterprise application that would
drive the integration, however, we are clueless as to how technology will
allow me to get Exchange talking to Access.
I am given to understand that Lotus Domino does allow you to do some kind
of integration/synchronization with DB2 with regards to the contacts, etc.
However, I would hate to believe that the only way to go about this thing is
to migrate to Domino - do I really need to migrate away from Microsoft to
achieve this? That's a little tough to believe...
Suggestions please...
Thank you.
Sincerely,
Adarsh