External Database Dashboard

Dashboards are not limited to linking and displaying data from only the GoldMine database. Data that you have in other SQL databases can be linked to and used to display on a Dashboard. You can create a new Dashboard specifically for the data, or add parts to an existing Dashboard for the desired data.

NOTE: The SQL login must have “read” permissions on the database to display the results in the Dashboard.

For this example, we will create a Dashboard that displays the individual Product inventory levels for all products stored in an MSSQL database outside of GoldMine. To do this, we will create a new Dashboard with a Chart and Drop-down List, and then link it to an external SQL database.

Our sample database (Accounting) and table (Inventory) contains a list of products sorted by product type and product.

Product	Quantity	ProductLine
Nano	32	iPod
Touch	44	iPod
Droid	43	Phones
Super Mario	14	Games

You can use this database example as a reference when mapping the fields in your own database.

Following is a list for creating the new External Database A collection of data fields and related tables, storing information that facilitates access and retrieval. Dashboard.

■ Creating a New Dashboard

■ Adding a Label

■ Creating a New Data Source for the Chart

■ Adding a Chart

■ Adding a Drop-Down List

■ Adding an Event to the Drop-Down List