ODBC Dialog box in InfoSewer

The Open Database Connectivity (ODBC) module of InfoSewer allows the user to actively link to any external database and import that data into the current InfoSewerH20Map Sewersession. Likewise, the user can also update an external database with InfoSewerH20Map Sewer data.

To initiate the ODBC Exchange, from the InfoSewerH20Map SewerControl Center -> InfoSewerH20Map Sewer button -> Exchange menu, select ODBC Exchange and the following dialog box appears. To learn more about the ODBC Exchange procedure click here.

InfoSewerH20Map Sewer Data Fields Mapping

This is where a direct "one-to-one" link is established between the external database fields and the internal IInfoSewerH20Map Sewer 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 InfoSewer diameter database field, select the "Diam" field under the ODBC Data Fields box, select the Diameter field under the InfoSewerH20Map Sewer data fields and then click on the map button [>].

InfoSewerH20Map Sewer Data Fields Mapping

This is where a direct "one-to-one" link is established between the external database fields and the internal InfoSewer 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 InfoSewer diameter database field, select the "Diam" field under the ODBC Data Fields box, select the Diameter field under the InfoSewerH20Map Sewer data fields and then click on the map button [>].

Close

Close and exit the ODBC Exchange Manager

Mapping Options

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 InfoSewerH20Map Sewer field.

Remove Single Field - To use this icon, select one record from the InfoSewerH20Map Sewer 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 InfoSewerH20Map Sewer 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.

ODBC Data Fields

These are all the fields that will be added to the ODBC

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 InfoSewerH20Map Sewer database (theInfoSewerH20Map Sewer ID field).

ODBC Data Source

Use this to launch the ODBC Data Source dialog box. Click here to learn more about the ODBC exchange process.

ODBC Table

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.

Options

Select to either insert new records or update new records. When importing to a New InfoSewer 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.

Purge ODBC

This option only applies to ODBC links from InfoSewerH20Map Sewer to an external database file. If this box is checked, the entire external file will be purged prior to the ODBC export.

Update Direction

Select which direction the ODBC linkage is occurring. If you are exporting data from InfoSewerH20Map Sewer to the external database, select Internal (InfoSewerH20Map Sewer) --> ODBC. Likewise, if data is being imported intoInfoSewerH20Map Sewer, select ODBC --> Internal (InfoSewerH20Map Sewer).

ODBC Variables

Manholes

Wet Wells

Pipes

Pumps

ODBC Methodology

The Open Database Connectivity (ODBC) module of InfoSewerH20Map Sewer allows the user to actively link to any external database (Such as dBASE, Excel, ForPro, MQUIS (SQL server), MS Acess etc) and import that data into the current InfoSewerH20Map Sewer session. Likewise, the user can also update an external database with the InfoSewer data.

Methodology

Use the following procedure to use the InfoSewerH20Map Sewer ODBC data exchange platform.

• Launch the ODBC Exchange dialog box from the InfoSewer Control Center -> InfoSewer button -> Exchange menu.
• Choose the InfoSewerH20Map Sewer Data Source. These data sources correspond with the different InfoSewerH20Map Sewer tables.
• Choose the appropriate Update direction. In order to import data choose ODBC->InfoSewer and to export data out of the InfoSewer project choose InfoSewer ->ODBC.
• Click on the ODBC Data Source to specify the external data base that you want to link to. The ODBC data source is required in order for InfoSewer to use the correct driver when linking to the desired external data file. The data source also supplies InfoSewer with the directory path to the external files so that a link can be established. Click here to learn more about ODBC Data Sources.
• Once the Data Source has been established, choose the ODBC table and the ID mapping field (when importing into InfoSewerH20Map Sewerr)
• All the available fields (during the import process) will be listed under the ODBC Data fields section of the ODBC dialog box. Click on the appropriate field under the ODBC fields section and then select the corresponding InfoSewerH20Map Sewer field by clicking on it and then click on the mapping arrow > to map the two fields. Continue this process till all the desired ODBC fields have been successfully associated with the InfoSewerH20Map Sewer fields.
• Finally when all the fields have been mapped, choose the Options button to specify your Import or Export options and then click on Exchange to start the exchange process.