![]() This is supported in all Windows versions including Windows 10. Make sure you select either the 32-bit ODBC driver or the 64-bit ODBC driver in 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).You have setup the program to automatically save emails and attachments to a database. Now you can click the Connect And Download button to test out the ability to save to DB.Click the Save button to save the new rule with the Save to DB action.Click “ Test SQL” to test connectivity and table row creation, this will add a new row to the table to make sure everything is setup correctly.At this point a new table schema would be created and the SQL would be automatically filled in based on the questions you answered. Specify a new table name (or an existing one) and then click “ Create Table” if this is a new table and follow the prompts.Pick the Source as the one you provided in Step-2.NOTE: The screenshot below shows other actions as well, if you have other actions you can chain or nest the save to database action after those actions have taken place as shown below. This will add an action under After saving file in the list to the left. Under Actions after save click Add action and then choose Save to database.Then create a new rule or edit an existing rule from the Global filters tab.Rule configuration to save the email to a database At this point a data source has been setup.Click Test Connection button to make sure this succeeds.Server=TESTPC\GEARMAGE Database=TestDB Trusted_Connection=yes 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 and not any other on the site).Īn example of these filled in is shown below: The above connection string is specific to SQL Server that is using a trusted connection. Then enter the Connection string that specifies how to connect to the server: Server=\ Database= Trusted_Connection=yes Then pick either the 32-bit ODBC driver or 62-bit ODBC driver ( depending on whether you installed the 32-bit or 64-bit version of Mail Attachment Downloader PRO Client or PRO Server).In our case, the driver “ SQL Server” from the drop down indicates the 32-bit driver. 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 |