This window is used to configure the connections between data links in the knowledge base and data in databases.

Quick Start

  1. Open the Database Connection Setup utility.
  2. Move to the “Data Sources” tab
  3. Add the database tables containing your data.
  4. Move to the “Links to Data” tab.
  5. Set the “Table” cell for each topic by using the cell's dropdown menu. Hint: if you are using only one table you can set them all at once from the “db” menu in the toolbar.
  6. Set the “Field” cell for each topic using the cell's dropdown menu. Only the fields for the above set table will be available. The dropdown list will have all unused fields at the top followed by a list of all fields for the table.

Closing this window DOES NOT close the database connections and the window can be reopened at any time.

If you have multiple tables you will probably also want to set up some database table joins so that the tables move synchronously.

Also see: adding data sets tutorial

Main Toolbar

  • Open a saved configuration.
  • Save the current configuration.
  • Breaks the linkages. Removes all existing connections to all databases.
  • Database table menu:
    • Add database tables to the list. Opens the database table selector to locate and identify database tables to be used.
    • Add another database table join.
    • Create New… Creates a new, empty database table with columns to match the topics in the knowledge base. A table of relationships between the columns and topics is also created.
    • Apply to all inputs. This is a sub menu of available database tables. Choosing a table from this list will link that table to all topics.
    • Create data links from unlinked fields - creates new data links, one for each database field that is not connected to an existing data link.
    • List of tables. Appended to the database table menu is a list of available tables. Choosing one of these items will link that table to the currently selected topic.
  • Process the tables. This generates new tables with output values.

Data Sources Tab

On the data sources tab lists you specify the database tables and table joins.

Database Tables

Database tables store data in a two dimensional array (a grid) where the columns (aka fields or attributes) represent the topics and the rows (aka records) represent sets of related values.

  • Add db tables to the list. Opens the database table selector.
  • Set the identity column for the selected table. The values from this column are used when identifying the row in the table.
  • Set a hint for the database table. The hint can be used to augment the description of the table.
  • Set a hyperlink for the database table.
  • View the selected table. Opens a table browser for the selected table. (double-clicking the table also performs this task)
  • Remove the selected table. (This does NOT delete the actual table. It only removes it and its linkages in NetWeaver.

Database Table Joins

A database table join links two database tables together so that their records move in unison. A join has a “master” table and a “slave” table. The master table controls the slave table. As you move from row to row in the master table the slave table(s) will also move in a coordinated fashion. More info...

  • Add another database table join. Opens the database table join editor
  • Edit the selected join.
  • Delete the selected join. (Deleting the join does NOT delete any data or tables. It only removes the relationship between the two tables.)

Links to Data Tab

On the links to data tab you configure how each data link gets its data.

To set a link: click in the topic's “Table” cell to get a dropdown menu of available tables and select the table (or use “apply to all inputs” from the database menu ). Then do the same in the “Field” cell.

Note about linking database tables: When a database table is linked to a topic NetWeaver will attempt to pick the field in the table that best matches the topic's name.

Global values are constant regardless of current row(s) in the table(s). The value can be set by editing the value in the “Value” cell.

Topic List Columns

Column Description
Topic The topic. Linked topics are colored black whereas unlinked topics are colored red.
Value The current value for the topic.
Table The database table used to provide data to the topic.
Field The database table column (field) used to provide data to the topic.
Scale by Scaling factor for numeric database data. This can be used to convert between different systems of units from the database to the knowledge base. For example, if the database units are inches but the knowledge base calls for centimeters the “Scale by” factor should be 2.54 (1in = 2.54 cm).
netweaver/windows/database_connection_setup.txt · Last modified: 2010/05/13 10:49 by bjmiller
 
Recent changes RSS feed Donate Powered by PHP Valid XHTML 1.0 Valid CSS Driven by DokuWiki