# Outlook Public Contacts

**URL:** <https://forum.inductiveautomation.com/t/outlook-public-contacts/2277>\
**Category:** Ignition\
**Created:** [October 19, 2010, 6:38pm UTC](https://forum.inductiveautomation.com/t/outlook-public-contacts/2277 "2010-10-19T18:38:03Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kfoldesi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kfoldesi/32/11327_2.png) [@Kfoldesi](https://forum.inductiveautomation.com/u/Kfoldesi)\
**Post date:** [October 19, 2010, 6:38pm UTC](https://forum.inductiveautomation.com/t/outlook-public-contacts/2277/1 "2010-10-19T18:38:03Z")

</div>

I would like to (select \* from OutlookPublicContacts). To get contact data that exsists already into my project. Is there a way to attach to that data?

---

<div class="post-metadata">

**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\
**Post date:** [October 20, 2010, 2:41am UTC](https://forum.inductiveautomation.com/t/outlook-public-contacts/2277/2 "2010-10-20T02:41:53Z")

</div>

I don’t think this question is really answerable, besides “yes”.

Ignition is extremely good at working with database tables, so there are a bunch of different parts of the system that this question might apply to. Why don’t you elaborate for us?

---

<div class="post-metadata">

**Author:** ![Kfoldesi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kfoldesi/32/11327_2.png) [@Kfoldesi](https://forum.inductiveautomation.com/u/Kfoldesi)\
**Post date:** [October 20, 2010, 12:24pm UTC](https://forum.inductiveautomation.com/t/outlook-public-contacts/2277/3 "2010-10-20T12:24:23Z")

</div>

OK,

Everything I can find goggling this topic talks about MAPI not JDBC. I have done some stuff moving data between Excel/Outlook/PowerPoint, but never to an outside application like Ignition. How do I setup a connection to the Outlook server to make queries on that data?

---

<div class="post-metadata">

**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\
**Post date:** [October 20, 2010, 3:32pm UTC](https://forum.inductiveautomation.com/t/outlook-public-contacts/2277/4 "2010-10-20T15:32:36Z")

</div>

I’ve never done that before. Does Outlook server support ODBC? If so you could use the JDBC-ODBC bridge driver

---

<div class="post-metadata">

**Author:** ![Kfoldesi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kfoldesi/32/11327_2.png) [@Kfoldesi](https://forum.inductiveautomation.com/u/Kfoldesi)\
**Post date:** [October 21, 2010, 11:20am UTC](https://forum.inductiveautomation.com/t/outlook-public-contacts/2277/5 "2010-10-21T11:20:59Z")

</div>

Well I did a search on that and yes, but very limited on what fields are available, and no info on what to put in the Connect URL or Extra Connection Properties of the Edit Database Connection screen in ignition.

//icsserver/exchange/ ???

integratedSecurity=true; ???

Not sure how to find out about connection properties I need.

---

<div class="post-metadata">

**Author:** ![Rockman1\_1](https://avatars.discourse-cdn.com/v4/letter/r/71e660/32.png) [@Rockman1\_1](https://forum.inductiveautomation.com/u/Rockman1_1)\
**Post date:** [October 21, 2010, 1:22pm UTC](https://forum.inductiveautomation.com/t/outlook-public-contacts/2277/6 "2010-10-21T13:22:45Z")

</div>

Not sure if they have anything listed that applies, but you might want to look here:

[http://www.connectionstrings.com/](http://www.connectionstrings.com/)