Download Campaign Enterprise Version 11 - Mass email marketing software

Connect To an Email List
Connect To A Database
Select the database type from the drop down menu:
• If you are using database shortcuts, simply pick the shortcut name from
the list for which you are approved.
• If you select a built-in list, select the particular table you want to use from
the drop down list.
• If you select access
• Click browse and find the pathway to your Access database. A
typical pathway may look like, C:\Documents and Settings\user\My
Documents\dbname.mdb.
• Click Select to return to the datasource tab
• If you select a different type of database, click browse and select the DSN
connection from the list of System DSNs.
When you successfully connect to the database you should now see options in
the Table/Query Name field. If you do not see anything, it does not necessarily
mean you are not connected. If your database has more than 300 tables and
queries you may have to type the name of the table you want. For example,
most Oracle databases can easily have 500 tables in them. Rather than wasting
resources pulling all of that information into Campaign Enterprise, the field
changes from a drop down, to a text field and you need to enter the name
yourself. A typical name for an Oracle table might be
OWNER.ORACLETBL.FIELDS. (Oracle likes the tables to be in all caps).
Once you have successfully selected the table, the Email address is populated
with the fields found in the selected table.
• Select the email address field. This is the field in your database
containing the email addresses.
• Select the unique ID. This step is optional for now, but is important for the
advanced features. If your email addresses are truly unique, you can use
the email address field here.
To ensure that you are connecting ok, click on the Preview button and examine
the table. You can look at the other fields from the additional drop down menus
and clicking the Refresh button. Click Return to get back to the data source tab.
The preview only shows the first 100 records in your database, but displays the
total number of records at the top of the page. If the number of records in your
table exceeds the limits of the evaluation, or the licensed edition of Campaign
Enterprise, you will see a warning message next to the total. Prior to sending,
you will need to filter your list to only send the authorized number.
90