将联系人从SQL Server导入/同步到Outlook [英] Import/Sync Contacts from SQL Server to Outlook

问题描述

基本上，我有一个SQL Server(2008)数据库，其中包含联系方式(除其他外)，并且希望提供在Outlook中查看这些联系方式的功能.至少必须支持Outlook 2003. Outlook客户端已连接到Exchange，因此也可以在Exchange中使用联系人(然后可以通过Outlook查看).

Essentially I have a SQL Server (2008) database that contains contact information (among other things), and would like to provide the ability to view these contacts in Outlook. Outlook 2003 must be supported at minimum. The Outlook clients are connected to Exchange, so having the contacts available in Exchange (and then viewable via Outlook) would work as well.

从数据库到Outlook/Exchange的同步或导入将是单向的，因此Outlook/Exchange中的联系人可以是只读的(或在导入期间可以放弃更改).

The sync or import would be one-way, from the database to Outlook/Exchange, so the contacts in Outlook/Exchange could be read-only (or changes could be discarded during import).

我认为最好的情况是Outlook/Exchange实时从数据库中读取数据，因此，如果对数据库进行了更改，则在访问它们后立即可以看到它们.但是，如果这不可能(我怀疑不是)，则用户可以单击按钮，同步可以定期发生，也可以在Outlook启动时发生.

I think best case would be that Outlook/Exchange reads from the database in real time, so that if changes are made to the database they are immediately visible when they are accessed. However, if this is not possible (I suspect it's not), the user could either click a button, the sync could happen periodically, or it could happen on Outlook start-up.

不一定要寻找完整的解决方案，仅是考虑采用的方法以及带有基本代码示例的所有资源.

Not necessarily looking for a complete solution, just thoughts on an approach to take, and any resources with basic code samples.

推荐答案

您可以使用多种技术:

• Exchange 2010 Web服务.使用您最喜欢的SOAP/XML工具包(如WCF)来操纵交换对象，包括联系人.有关代码示例，请参见使用联系人.
• Exchange 2003/2007协作数据对象(COM)，请参见在Exchange存储中创建联系人或为此 2007
• Exchange 2003/2007的WebDAV(HTTP请求)，请参见为 2007

• Exchange 2010 Web Services. Use your favourite SOAP/XML toolkit (like WCF) to manipulate exchange objects, including Contacts. See Working with Contacts for code samples.
• Exchange 2003/2007 Collaboration Data Objects (COM), see an example on Creating a Contact in the Exchange Store or this for 2007
• WebDAV (HTTP requests) for Exchange 2003/2007 see Creating a Contact in the Exchange Store (WebDAV) or this for 2007

此外，Office对象模型和Outlook还具有客户端技术，但是这些技术会将联系人添加到单个Outlook通讯簿中，而不是添加到中央交换存储中(即，整个组织都无法使用).

In addition there are client technologies around the Office object model and Outlook, but those would add contacts to individual Outlook address books, not to the central exchange store (ie. not available to the entire org).

这篇关于将联系人从SQL Server导入/同步到Outlook的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！