NetWeaver Help

User Tools

Site Tools

netweaver:tutorials:adding_data_sets

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

netweaver:tutorials:adding_data_sets [2020/10/04 16:12] – external edit 127.0.0.1netweaver:tutorials:adding_data_sets [2020/10/05 09:37] (current) – bjmiller
Line 1: Line 1:
 +====== Adding a database table ======
 +This procedure will add a database table to your knowledge base.  It assumes you are using a file-based database.  The method for system databases is very similar.
 +
 +===== =====
 +{{http://netweaver.rules-of-thumb.com/images/common_146.png?nolink }}Open the [[netweaver:windows:database_connection_setup|Database Connection Setup]]:
 +
 +{{ http://netweaver.rules-of-thumb.com/images/screens/dbconnsetup1.png?nolink&400 }}
 +
 +{{http://netweaver.rules-of-thumb.com/images/common_165.png?nolink }}Go to the "Data Sources" tab.
 +
 +{{http://netweaver.rules-of-thumb.com/images/common_199.png?nolink }}Open the [[netweaver:windows:database table selector]]
 +
 +{{http://netweaver.rules-of-thumb.com/images/common_1.png?nolink }}Assuming your file is a file-based database: Click the "File DBS" button to open a file dialog.
 +
 +{{http://netweaver.rules-of-thumb.com/images/common_blank.png?nolink }}Navigate to and select your database file.
 +
 +{{http://netweaver.rules-of-thumb.com/images/common_128.png?nolink }}If the database is secured enter your credentials to unlock it.
 +
 +{{http://netweaver.rules-of-thumb.com/images/common_132.png?nolink }}Click the accept button.
 +
 +{{http://netweaver.rules-of-thumb.com/images/common_155.png?nolink }}If you selected a database file with more than one table then select the table to add by either double clicking the table name or clicking on the table name and pressing then "Add" button.
 +  
 +
 +====== Linking the data to the knowledge base ======
 +This procedure links data from a database table to your knowledge base.
 +
 +  - {{http://netweaver.rules-of-thumb.com/images/common_146.png?nolink }}Go to the "Links to Data" tab.
 +  - For each data link:
 +    - Click in the "Table" cell and select the table from the dropdown list.
 +    - Click in the "Field" cell and select the field from the dropdown list.
 +
 +====== Shortcuts/Hints =======
 +  * If you are using only one database table for all of your data needs then you can set the table for all data links from the db menu using "Apply to all inputs ->" and selecting the table you want to use.  It will populate all the table cells with the selected table.
 +  * When you set the table for a data link NetWeaver will attempt to match the table's field to the name of the data link.  So if the names are pretty similar the field will be set automatically for you.
 +  * The dropdown list for fields puts any unused fields for the table at the top of the list then a blank entry to separate them from the used fields at the bottom of the dropdown list.