Database Connectivity

One of JangoMail's unique features is the ability to connect to a variety of database platforms in real-time. JangoMail can either "talk" to your database and pull out information as necessary to send out a mass email or if you are a programmer, you can use our Application Programming Interface (API) to interact with JangoMail from an external application.

 

Using JangoMail's database connectivity features, you will not have to maintain your data in more than one place. You can continue to maintain your data in your own database, and JangoMail will "talk" to it as necessary.

Connecting Directly to a Database From JangoMail


JangoMail can connect in real-time to the following databases:


  • Any ODBC compliant database
  • Microsoft Access
  • Microsoft Excel
  • Microsoft SQL Server
  • Goldmine
  • dBase Files and Applications using dBase (like QuickFill and ServantKeeper)

 

There are two ways JangoMail can connect to a database:

 

1) Connecting to a LAN database
2) Connecting to an Internet web site database

 

Both of these options are available under the "Extract from my database" tab once you login to JangoMail. To decide which of the two methods you should use, consider the following factors:

 

If your database is on your own computer or on your LAN, then it is best to use method 1: Over your Local Area Network (LAN).

 

If your database is connected to your web site, then it is best to use the Internet database connection. How do you know if your database is connected to your web site? If your web site has a form on it that a user fills out, and then that user's information gets stored in a database, then your database is connected to your web site.

Interacting with JangoMail via the API and Web Service


The JangoMail Application Programming Interface (API) is a web service that allows you to control your JangoMail account programatically across the Internet. Calls to the API can be made in non-XML or XML formats via HTTP POST, HTTP GET, or an SOAP calls. JangoMail uses the SOAP and WSDL standards so a developer can program in his or her favorite environment - such as Java, Perl, or Visual Studio .NET.


3) Learn about interacting with JangoMail via the API.