Connect to an Internet Web Database

JangoMail can pull the data from a web database in real-time and then send a personalized mass email to email addresses in the database. Additionally, JangoMail can synchronize data (unsubscribes/bounces/clicks/opens/forwards/and more) with your web database.

JangoMail supports a connection to any website/database platform. For ASP, ASP.Net, and PHP sites, JangoMail provides a script file for you to use. For all other platforms, you may write your own.

 

Sending to email addresses in your web database

  1. Determine your web/database platform type
    1. You must choose from one of the five options:
      1. ASP / Access
      2. ASP / SQL Server
      3. ASP / Other ODBC database
      4. PHP / MySQL
      5. ASP.Net / JSP / Custom
    2. If you don’t know your web/database platform, then consult with the web programmer in charge of your website.
    3. See this page for more information about using the ASP.Net script file.
  2. Place the script file on your web server
    1. Click Lists on the navigation ribbon.
    2. Click the Databases tab.
    3. Click the button to Create New Database.
    4. Choose Internet Web Database and select your webserver and database type. If your web/database platform isn’t listed, you can write your own script file.
    5. To retrieve your script file, click the link listed after You can now download the script file for your platform. The file is:
    6. FTP the file to your web server’s home directory.
  3. Create a connection profile
    1. Click the Configure this connection button.
    2. Fill out the fields provided to create a list from the connection.
    3. Click the Test button to confirm the connection.
    4. Click Save to save the list.
      Note: If data was successfully pulled from your database, you will be taken to the Messages screen. If there was an error, you will be taken to an Error screen showing you what your web server returned. If you are unable to diagnose your error, contact us for help.
  4. Compose / send personalized message
    1. If you are transferred to the Messages screen, there will be a green box at the top of the screen informing you how many records have been pulled from your database. JangoMail is now set to send an email to these members.
    2. Click the New Message icon. Or, if you are starting with an existing message (something composed earlier), select that message/campaign.
    3. For a new message, choose how you want to create a new message: new blank message, a template, a JangoMail template, or a template you uploaded via FTP.
    4. You can personalize all legal fields/values in a message, such as the subject, display name, and the message content.
    5. The blue area above the Subject field lists the fields pulled from your database so that you can paste them into your Subject / Message. The syntax for personalization is %%fieldname%%. For example, if one of the fields pulled from your database is FirstName, enter %%FirstName%% within the Subject/Message to personalize with this field. You can read more about personalization.
    6. When your campaign is ready for sending, click the Send button.

Note: You may re-select the same profile by clicking the Databases tab in the Lists section, locating your saved profile in the list, and then clicking the Connect to this Database icon. 

Note: If at any time after pulling the records from your database you navigate away from the Messages section by clicking on another main tab, the data you pulled will be lost, and you will have to start the process all over again.

 

Setting a Master Connection Profile

Now that you’ve set up at least one connection profile you can designate a connection profile to be the Master Connection Profile for your account. The Master Connection Profile is the profile whose connection information will be used during an offline operation involving your website’s database. Offline operations include:

  1. Using the API to call SendMassEmail, and specify a SQL query in the ToWebDatabase parameter.
  2. Using synchronization to have JangoMail synchronize your database by running a SQL query on recipient actions, like unsubscribes, bounces, clicks, and opens. (Go to Settings → Integrating JangoMail with Other Systems → Web DB Event Management.)
  3. Using mass email initiations to launch email campaign to a recipient list stored in your web database by using an external email client like Outlook or Thunderbird. (Go to Settings  Integrating JangoMail with Other Systems → Externally Launched Email Query.)

To set the Master Connection Profile go to Settings → Integrating JangoMail with Other Systems → Set Master Profile for Web DB.

 

Synchronizing JangoMail data with your web database

JangoMail can synchronize reporting data with your web database in real-time. Unsubscribe requests, bounces, email change-of-address requests, email opens, email clicks, forward-to-friend requests, and web page visits can all be synchronized with your web database via individual SQL queries that you specify. You can specify these SQL queries under Settings → Integrating JangoMail with Other Systems → Web DB Event Management.

By taking advantage of this feature, you can send targeted mass email campaigns to your email database based on a recipient’s past behavior. Meaning, for example, you can send to just those recipients that opened a particular email campaign or clicked a particular link in a particular campaign.

 

Security

If your web server is a publicly accessible web server on the Internet, you need not open any special ports for JangoMail to communicate with your database. JangoMail need only be able to connect to ports 80 and 443 on your web server. JangoMail does not communicate directly with your database server – it always uses your web server as an intermediary. Therefore it is not necessary to open any database ports on your firewall in order to use JangoMail. You may have to allow external access from JangoMail, and the IP to use for the allowed connection is 209.173.141.200.

 

For more information, check out these pages.
 
Have more questions? Submit a request
Powered by Zendesk