Let’s start off by adding a new data source - click on the Database tab -> Add ODBC source button.Step-by-step tutorial - emails to databases Setting up a datasource You get a versatile tool that provides flexibility in storing emails to databases in just the way you want to. Runs 24×7 in the cloud or on-premise as a Windows Service. Used by many Fortune 500 companies today to save emails and attachments to databases. You can even include extracted data from emails or attachments using custom variables in your SQL statement and save them to a database!Įach 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. And if you do know SQL, it offers the flexibility and customizability to modify the SQL statements to suit your needs. You do not need to know SQL to save emails or attachments to a database. The feature of saving emails to databases is just one of the features available with the Mail Attachment Downloader PRO Server version.Įach rule can be setup to save emails to databases using either generated SQL (to one or more tables) or a custom SQL. The program supports and works with any compatible ODBC data source such as MySQL, Oracle, PostgreSQL and more. This 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. In this post, we will explore saving emails and attachments to a database server like SQL 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. Save emails and attachments to a database (SQL Server)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |