The Open DataBase Connectivity (ODBC) module of InfoWater Pro allows the user to actively link to any external database and import that data into the current InfoWater Pro session. Likewise, the user 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 the Command Center tab on the bottom, navigate to the Exchange group, and click the ODBC Exchange.
InfoWater Data source
The internal InfoWater database table in which a linkage is to be made. Select one of the database tables on the list.
Select which direction the ODBC linkage is occurring. If you are exporting data from InfoWater to the external database, select Internal (InfoWater) --> ODBC. Likewise, if data is being imported into InfoWater, select ODBC --> Internal (InfoWater).
ODBC Data Source
Select from one of the tables present in the ODBC directory as specified from the DSN under the ODBC Data Source. Click here to learn more about 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 database (the InfoWater 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 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 diameter database field, select the "Diam" field under the ODBC Data Fields box, select the Diameter field under the InfoWater data fields and then click on the map button [>].
The display buttons allow the user 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 the Remove icon and the field is no longer mapped to the specified InfoWater field.
Remove Single Field - To use this icon, select one record from the InfoWater Data fields box, click 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 the user to quickly map a known external table with the internal InfoWater database.
Save - By using the save feature, the user 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.
This option only applies to ODBC links from InfoWater to an external database file. If this box is checked, the entire external file will be purged prior to the ODBC export.
Use this button to execute the ODBC linkage
Use this button to select to either insert new records or update new records. When importing to a New InfoWater 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.
Use this button to close and exit the ODBC Exchange Manager