This Article Applies From:
DeMeter 2.1


Introduction

This article is intended to explain the purpose of DeMeter connectors, which connectors/data sources are available to the DeMeter software platform and how to add/manage them.


Contents

1  Definition

2  Compatible Connectors

3  Adding Connectors

3.1  Database Connectors

3.2  Controller Connectors

3.3  Pivotware Connectors

4  Managing Connectors


Definition  


A connector is any source device that the DeMeter Service(s) can use to dynamically generate data. The amount of data collected from each connector varies depending on version of software/version and connectors being used.


Compatible Connectors  


Group/TypeDevice/ConnectorImageOverall OK/NOK  Production Details  Alerts/Calls  Extra Notes/Comments
DatabaseCVI Net Web Database   Microsoft SQL Server Databases Only.
ControllersConnect - Industrial Smart Hub   
CVI3 Tool Controller   
PivotwareInfinity Client   


Adding Connectors  


Database Connectors  

To add a database connector, click on the "Add Connector" button.

After the properties have loaded, enter your Microsoft SQL Server details as well login credentials for the applicable database.

  • CVINet Name = The label name for this database connector.
  • Server address = The address of Microsoft SQL Server storing the CVI Net Web database.
  • Database name = The name of the CVI Net Web database being imported.
  • User name = SQL Authenticated User name that has access to the CVI Net Web database.
  • Password = SQL Authenticated User password that has access to the CVI Net Web database.

After having enter the database connector details, click "Test Connection" to verify that the connection information is usable. You'll see the following pop-up if the connection test was successful.

After having successfully connected to the database, click "Import Tightening Products" to import any active controllers found in the database as well as any tightening units that they have attached to them. You'll see the following pop-up stating the number of tightening products imported:

Click 'Save' in the top-right hand corner to apply this import to the currently open configuration.


Only controllers marked as "Allowed" in CVI Net Web database are imported by the DeMeter Configurator.


Controller Connectors  

To add a controller connector, click on the "Import from CVI Config" button.

Select a .db file that has been created by CVI Config and click "Open"

After having successfully selected a valid .db file, any active controllers found in the file with a valid DeMeter ID will be imported as well as any tightening units that they have attached to them. You'll see the following pop-up stating the number of tightening products imported

Click 'Save' in the top-right hand corner to apply this import to the currently open configuration.


To get a DeMeter ID in your controller and enable the import; activate DeMeter data collection in CVI CONFIG, deploy the configuration to the controller and then retrieve the ID by using the Controller  PC button.


Pivotware Connectors  

To add a Pivotware connector, click on the "Import Station(s) from a .fps file" button.

Select a .fps file that has been created by CVI Fusion and click "Open".

After having successfully selected a valid .fps file, any Infinity Client Stations found in the file will be imported. You'll see the following pop-up stating that stations successfully imported:

Click 'Save' in the top-right hand corner to apply this import to the currently open configuration.



Managing Connectors  


After connectors have been imported into the DeMeter Configuration, users can define if the connector should have DeMeter data collected or not by settings the "enable" status. 

By clicking on a connector directly, users can view their properties and make changes directly inside of the configurator without reimporting from the data source.

Users can change label names, connection details and reimport as needed.Users can change label names and enable/disable individual tightening unit data collection.User can change label names.


When users wish to retrieve alerts (by direct connection) and tightening results by CVI Net Web database data source for the same controller, you will see the same controller is imported more than once causing an unnecessary additional UV Cost. You can use the link button to merge two controller connectors together:

Before: 90 UVAfter: 70 UV