Adding the Inventory Data Source
To add the inventory data source
1. Right-click the sources folder
2. Select New Data Source.
3. Scroll down, select PostgreSQL 9.1 as the data source adapter, and click Next.
4. Type values for the fields shown in the table.
Field Name | Tutorial Value | Description |
Name | ds_inventory | Type a unique name for the data source. When the process of adding this data source is complete, the name ds_inventory will be displayed in the resource tree. ds_inventory is the TDV representation of the underlying inventory data source. |
Host | localhost | Type the name or IP address of the machine where TDV Server is installed. If the server is installed on your local machine, you can type the machine name or the term localhost. |
Port | 9408 | Type the port number. Use 9408 for the tutorial to access the server that is shipped with the TDV software. If you use an external server, the default port might be different. |
Database Name | inventory | TDV Server uses this entry to locate the underlying data source orders. |
Login | tutorial | These entries are the username and password to access the underlying data source. |
Password | tutorial |
5. Click Create & Introspect.
6. Expand tutorial.
7. Select the following tables:
— inventorytransactions
— products
— purchaseorders
— suppliers
These tables contain the information about product inventory transactions, purchase order details, and supplier contact information.
8. Click Next.
9. Click Finish.
10. Click OK.
A folder named ds_inventory now appears under sources in the resource tree.
If you do not see the newly added data source in the resource tree, right-click the Desktop node, select Refresh, and look for it in sources.
11. Expand Shared > sources > tutorial > ds_inventory. Each node within ds_inventory represents a table you selected. Expand each node to see the columns in that table.
All of these tables and columns are available for your modeling in TDV.
12. If you want to view the schema of this data source, follow the steps described for viewing the orders data source schema in
Viewing the Data Source Schema.