For this upcoming release of InfoWater Pro 2.5, you can access live data adapter (LDA)function from the InfoWater Pro ribbon - Project section.
To configure your database with LDA:
- If you are new to Live Data Adapter, you will need to configure a real time database (choose from SQL server, ClearSCADA, or PI) in the following dialog box.
- Click on the Live Data Adapter
button to configure your database in the LDA Connection dialog box.
- Enter your Connection name in the Name field.
- Enter a Description (optional) in the Description field.
- Select the Server Type (choose SQL server, ClearSCADA, or PI) in the Server Type field.
- Select your Connection Provider from the drop-down box in the Connection Provider field.
- Enter your Server Address (i.e., IP address, your server name, or your alias) in the Server Address field.
- Enter your User Name and Password in the User Name and Password fields.
- Enter a Database for SQL server. Note: The Database field does not need to have an entry in the case of ClearSCADA and PI server types.
- Click OK.
- Next the Sensor List dialog box appears.
- You will need to manually add new mappings to this sensor list.
- Click on the Add Sensor button to add a new mapping between the sensor and element to this sensor list.
- You will see a new LDA Sensor dialog box (see below). Note: If you do not have a valid database connection, then you will not be able view this dialog box.
- Enter the following Sensor fields to create a new mapping to the list:
- Select a sensor type from the drop-down menu (choose from Flow, Pressure, Volume, Head, and Velocity).
- Enter your Sensor ID in the Sensor ID field.
- Enter your Description (optional) in the Description field.
- You do not need to enter a Connection in the Connection field. It is automatically chosen for you.
- Select your Sensor Table from the drop-down box in the Sensor Table field.
- Enter your date in the Date field.
- Enter your Time in the Time field (optional).
- Select your Channel from the drop-down menu in the Channel field.
- Select your unit for your sensor data from the drop-down box in the Unit field.
- Select your tag (choose from the tags in the drop-down menu) in the Tag field.
- Enter your tag value in the Tag Value field. It is your Sensor ID. Be sure to include quotation marks.
- Enter your Where Clause (a SQL statement) in your Where Clause field.
- Enter your Value factor in the Value Factor field.
- Enter your Value offset in the Value Offset field.
- Enter your Element Type in the Element Type field.
- Click on the arrow button to choose an element on the map or you can manually type the element's in the field.
- Once you are done, click OK to view your new sensor mapping that you added to your Sensor List.