Announcement

Collapse
No announcement yet.

Inserting email into database

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Inserting email into database

    Hi There,

    I'm just wondering if I could automate the process of entering the email from my Exchange Server 2007 into a database (Oracle 10g through ODBC) because it would be beneficial if the incoming mail be inserted into the database rather than me have to copy paste manually field per field into my custom application.

    Even if the solution have to keep certain machine (VM) running Outlook on 24/7 just to get that email and inserting it to the database is also acceptable.
    Any help on this matter would be greatly appreciated.

    Thanks,

    Albert
    ________
    XL100
    Last edited by Albertwt; 21st January 2011, 11:15.

  • #2
    Re: Inserting email into database

    A guy in Microsoft forum give me an idea of implementing this:

    "
    Code:
    Exchange WebServices (http://msdn.microsoft.com/en-us/library/bb204119.aspx) by issuing FindItems and GetItems requests.
    To trigger the export you could either simply pull every x minutes or use Pull/Pushnotifications get notifications about new mails.
    "
    ________
    mac game
    Last edited by Albertwt; 21st January 2011, 11:15.

    Comment


    • #3
      Re: Inserting email into database

      Have a look at a 3rd party archiving product e.g. PolicyPatrol which will do something similar -- not sure about oracle, though
      Tom Jones
      MCT, MCSE (2000:Security & 2003), MCSA:Security & Messaging, MCDBA, MCDST, MCITP(EA, EMA, SA, EDA, ES, CS), MCTS, MCP, Sec+
      PhD, MSc, FIAP, MIITT
      IT Trainer / Consultant
      Ossian Ltd
      Scotland

      ** Remember to give credit where credit is due and leave reputation points where appropriate **

      Comment


      • #4
        Re: Inserting email into database

        Thanks Ossian

        I'll have alook at it, because this has been a long search process and so far no solution is found yet.

        Cheers,

        Albert
        ________
        iolite vaporizer
        Last edited by Albertwt; 21st January 2011, 11:17.

        Comment

        Working...
        X