{"id":33,"date":"2016-02-22T10:25:46","date_gmt":"2016-02-22T10:25:46","guid":{"rendered":"http:\/\/gearmage.com\/blog\/?p=33"},"modified":"2026-02-05T22:52:03","modified_gmt":"2026-02-05T22:52:03","slug":"save-emails-and-attachments-to-a-database","status":"publish","type":"post","link":"https:\/\/gearmage.com\/blog\/save-emails-and-attachments-to-a-database\/","title":{"rendered":"Save emails and attachments to a database"},"content":{"rendered":"

Save emails and attachments to a database (SQL Server)<\/h1>\n

In this post, we will explore saving emails and attachments to a database server\u00a0like\u00a0SQL Server by setting up an ODBC data source and using a post download Action to save contents of the email and\/or attachments to a database.<\/p>\n

The program supports and works with\u00a0any compatible ODBC data source<\/strong>\u00a0such as MySQL<\/strong>, Oracle, PostgreSQL\u00a0<\/strong>and more.\u00a0This post only explores setting up to save the data in SQL Server but also has information on how to tweak it for other database types.<\/p>\n

An overview — emails to databases<\/h3>\n

The feature of saving emails to databases is just one of the features<\/em> available with the\u00a0Mail Attachment Downloader PRO Server<\/a>\u00a0version.<\/p>\n

Each rule can be setup to save emails to databases using either generated SQL (to one or more tables) or a custom SQL.<\/p>\n

You do not need to know SQL to save emails or attachments to a database. And if you do know SQL, it offers the flexibility and customizability to modify the SQL statements to suit your needs.<\/p>\n

You can even include\u00a0extracted data from emails or attachments<\/em>\u00a0using custom variables in your SQL statement and save them to a database!<\/p><\/blockquote>\n

Each rule has several phases — first, search and filter through emails or attachments, then extract data from emails or attachments, saving email bodies or attachments to a customizable file or folder format if needed and lastly post-process the emails or attachments by saving them to a database of your choice.
\n<\/a><\/p>\n

\"email<\/a><\/p>\n

Used by many Fortune 500 companies today to save emails and attachments to databases. \u00a0Runs 24×7 in the cloud or on-premise as a Windows Service.<\/em><\/p>\n

You get a versatile tool that provides flexibility in storing emails to databases in just the way you want to.<\/p>\n

\n

Step-by-step tutorial — emails to databases<\/h3>\n

Setting up a datasource<\/h4>\n
    \n
  1. Let’s start off by adding a new data source — \u00a0click on the Database<\/strong> tab -> Add ODBC source<\/strong> button\"Database<\/li>\n
  2. Provide a name for the source first. Then pick either the 32-bit ODBC driver or 62-bit ODBC driver\u00a0<\/strong>(depending on whether you installed the 32-bit or 64-bit version of Mail Attachment Downloader PRO Client or PRO Server<\/span>).In our case, the driver “SQL Server<\/strong>” from the drop down indicates the 32-bit driver. \u00a0Then enter the Connection string that specifies how to connect to the server:Server=<computer name>\\<SQL Server name>;Database=<DB name>;Trusted_Connection=yes;<\/small><\/code>\n

    The above connection string is specific to SQL Server that is using a trusted connection. To connect in any other way to SQL Server OR to another database like Oracle, you can find ODBC connection strings here (make sure you select ODBC connection string<\/strong> and not any other on the site)<\/a>.<\/p>\n

    An example of these filled in is shown below:
    \nServer=TESTPC\\GEARMAGE;Database=TestDB;Trusted_Connection=yes;
    \n<\/small><\/code>
    \n\"DBDetails2\"<\/li>\n

  3. Click Test Connection<\/strong> button to make sure this succeeds. Then click OK.<\/li>\n
  4. At this point a data source has been setup.<\/li>\n<\/ol>\n

    Rule configuration to save the email to a database<\/h4>\n
      \n
    1. Then\u00a0create a new rule or edit an existing rule from\u00a0the Global filters<\/strong>\u00a0tab.<\/li>\n
    2. Under Actions after save <\/strong>click Add action\u00a0<\/strong>and then choose Save to database<\/strong>. This will add an action under After saving file<\/strong> in the list to the left.
      \nNOTE:<\/strong> The screenshot below shows other actions as well, if you have other actions you can       chain or nest<\/a> the save to database action after those actions have taken place as shown below.<\/p>\n

      \"Save<\/li>\n

    3. Pick the Source<\/strong> as the one you provided in Step-2.<\/li>\n
    4. Specify\u00a0a new table name<\/strong> (or an existing one)\u00a0and then click “Create Table<\/strong>” if this is a new table and follow the prompts.\u00a0 At this point a new table schema would be created and the SQL would be automatically filled in based on the questions you answered.<\/li>\n
    5. Click “Test SQL<\/strong>” to test connectivity and table row creation, this will add a new row to the table to make sure everything is setup correctly.<\/li>\n
    6. Click the\u00a0Save\u00a0<\/strong>button to save the new rule with the Save to DB<\/strong> action.<\/li>\n
    7. Now you can click the\u00a0Connect And Download<\/strong>\u00a0button to test out\u00a0the ability to save to DB.<\/li>\n<\/ol>\n

      That’s it!<\/p>\n

      You have setup the program to automatically save emails and attachments to a database.<\/p>\n

      IMPORTANT CONSIDERATIONS<\/h3>\n
        \n
      1. Make sure you select either the\u00a032-bit ODBC driver\u00a0<\/strong>or the\u00a064-bit ODBC driver<\/strong>\u00a0in the dropdown depending on which installation of Mail Attachment Downloader PRO Client or PRO Server you installed (license email has links to both versions of the install). This is supported in all Windows versions including Windows 10. In some cases default installations may only install the 64-bit driver and you may need to manually download and install the 32-bit ODBC driver for your database. Please consult the database documentation and Google on how to do this.<\/li>\n
      2. Your specific connection string<\/strong>\u00a0can vary depending on the type of database (for example, Oracle has different connection strings than MySQL). A useful site to help you with the ODBC connection string is\u00a0https:\/\/www.connectionstrings.com<\/strong>.\u00a0<\/a>Make sure you only choose the\u00a0ODBC connection string <\/strong>in the site \u00a0<\/strong>for your\u00a0<\/strong>database type (like Oracle). You may need to play around with the different strings and test connections to find the one that works. If your connection string includes a Driver name, make sure it matches exactly (space for space) the one you have picked in the dropdown.<\/li>\n
      3. Depending on the type of DB you use, the automatic creation of table\/sql may fail. In that case, you might have to provision the schema for the table in the DB manually and then specify the SQL to insert records into the table in the program.<\/li>\n
      4. You can save the attachment content using the following variable in your SQL\n
        {RAW_CONTENT}<\/pre>\n<\/li>\n<\/ol>\n
        Further reading<\/h3>\n
        Some interesting how-to links and posts for further exploration:<\/p>\n