The Open DataBase Connectivity (ODBC) module of InfoWater Pro allows you to actively link to any external database and import that data into the current InfoWater Pro session. Likewise, you can also update an external database with InfoWater Pro model data.
To do any operation related to ODBC Exchange, go to the Model Explorer, click on Command Center tab on the bottom, navigate to the Exchange group, and click ODBC Exchange.
InfoWater Data source
The internal InfoWater Pro database table in which a linkage is to be made. Select one of the database tables on the list.
Update Direction
Select which direction the ODBC linkage is occurring. If you are exporting data from InfoWater Pro to the external database, select Internal (InfoWater) -- > ODBC. Likewise, if data is being imported into InfoWater Pro, select ODBC -- > Internal (InfoWater).
ODBC Data Source
Use this to launch the ODBC Data Souce dialog box.
ODBC Table
Select from one of the tables present in the ODBC directory as specified from the DSN under the ODBC Data Source.
ODBC ID Mapping Field
The unique field in the external database that accurately represents a one-to-one link between the external database and the selected InfoWater Pro database (the InfoWater Pro ID field).
ODBC Data Fields
These are all the fields that will be added to the ODBC.
InfoWater Data Fields Mapping
This is where a direct one-to-one link is established between the external database fields and the internal InfoWater Pro database fields. For example, the external database file may have a field named Diam that represents pipe diameter. To accurately map the Diam field to the internal InfoWater Pro diameter database field, select the Diam field from the ODBC Data Fields box, select the Diameter field from the InfoWater Pro data fields and then click on the map button [ >].
Mapping Options
The display buttons allow you to map, remove, and reset fields as well as save and open an import template.
-
Map Single Field - To use this icon, select one record from the left hand window, click on the
Remove icon and the field is no longer mapped to the specified InfoWater Pro field.
-
Remove Single Field - To use this icon, select one record from the InfoWater Pro Data fields box, click on the
Remove Single Field icon and the field is now "unmapped".
-
Reset - This icon will remove all mapped fields.
-
Load - This icon will open a previously saved field collection table. This is a time-saving feature that allows you to quickly map a known external table with the internal InfoWater Pro database.
-
Save - By using the save feature, you can store an ODBC template to a field collection folder. With a saved folder, a mapping template file can be recalled during any ODBC procedure.
Purge ODBC
This option only applies to ODBC links from InfoWater Pro to an external database file. If this box is checked, the entire external file will be purged prior to the ODBC export.
Exchange
Use this button to execute the ODBC linkage.
Options
Use this button to select to either insert new records or update new records. When importing to a New InfoWater Pro project choose to Insert New Records. When importing to an existing project choose either to add New Records or to Update Existing Records or both.
Close
Use this button to close and exit the ODBC Exchange Manager.