Database Shortcuts

When Database Shortcuts (DBS) is enabled on the Default Campaign Configuration page, you need to select a database shortcut in order to connect to a particular database on the Datasource tab of the Campaign edit area.  If there are no Database Shortcuts available, a dialog box will open explaining what you need to do to get access to one.

This is where an Admin user defines the sources to be used, and assigns the users or groups privileges to see the Database Shortcut.

Access Database

1. Click New

2. Enter the name for the Database Shortcuts

3. Select MS Access from the drop down menu

4. Click Browse

5. For MS Access you will browse to the database file on the local machine

6. Click Select

7. Check the box for each user or group assigned to the new Database Shortcuts

8. Click Save to save the string and return to the main Database Shortcuts page  
   

ODBC Connections

1. Click New

2. Enter the name for the Database Shortcuts

3. Select the type of database from the drop down menu (anything other than MS Access)

4. Select from the list of available System Datasource Names (DSN)

5. Enter the User ID and Password in the string if one is required, if not, leave blank

6. Click Select

7. Check the box for each user or group assigned to the new Database Shortcuts

8. Click Save to save the string and return to the main Database Shortcuts page  

OLE DB Connection

1. Click New

2. Enter the name for the Database Shortcuts

3. Select the type of database from the drop down menu

4. Enter the OLE DB Another type of connection string that is two layers above ODBC Open Data Base Connectivity. Allows for greater flexiblility and performance over ODBC. string into the Database Source field e.g. Provider=sqloledb;Data Source=201.201.201.1;Initial Catalog=DBName;User Id=username;Password=password;

5. Check the box for each user or group assigned to the new Database Shortcuts

6. Click Save to save the string and return to the main Database Shortcuts page

The new Database Shortcuts will be available in the Database Shortcuts drop down menu for assigned users and groups when connecting to a database.  Repeat for each connection string you need to make.

Related Topics

If you enable the Database Shortcuts after many database strings have already been created, you will see Database Shortcuts strings corresponding to the name of the campaign for which they were created.  You can continue to use those, or create new ones.