Create a new map with all or parts of the data mapped as sub topics.ġ.3.1 Related Data Once data from a database has been added to your map, users may have the ability to lookup related data from another table.įigure 2: Customers and Orders Tables Joined by CusotmerIDįor example, in the above illustration, you can see that the Customers and Orders table are joined by the CustomerID.īy establishing a relationship between the two tables, users that have selected a particular customer can lookup the customer’s orders because of the relationship. Users can: Individually add a specific row by dragging and dropping a database row into the map Create a new topic with all or parts of the data mapped as sub topics. Furthermore, after the data has been retrieved, users can find specific database rows by applying a text filter simply by entering key words into the Filter field.ġ.3 Map Data Once the user has retrieved that database data using MindManager, users can begin to add the database data to their map. By default, only the first two of columns of the table will be displayed, but the user can choose which columns to display. When the table is selected, MindManager 8 will retrieve and display the contents of the database table in the Results section of Database Linker task pane (pictured at right). *MySQL, Oracle, and DB2 database connections are available but not officially supported database types.ġ.2 Get Data Once a user establishes a connection to one of the supported databases, MindManager 8 users will be allowed to retrieve data from the database simply by selecting a table. MindManager 8 allows users to connect to the following data sources: Microsoft Access Marketing: Add previous campaign performance metrics stored in an Excel file to your next marketing campaign planning map.įigure 1: Table Data Represented as a Map Sales: Add order history to an Account Opportunity map. Human Resources: Construct an organization chart from personnel data stored in an HR database. There are an infinite number of reasons why a user might want to import structured data into a map, but here's a list of some potential uses: Sales: Lookup customer information from a customer database while building an Account Plan map. Database Linker Tutorial 1 Overview 1.1 Utility to Connect MindManager 8 to Data Sources MindManager 8 introduces the built-in ability to automatically map data contained in a database, allowing you to import structured data into your MindManager map.
0 kommentar(er)
