Usage Models

The import of measurement data on local data carriers (hard disk, USB stick etc.) is started via the Batalyse Toolbar via Launch Batalyse. Then the selection of the folder and the measurement file follows.

Evaluation via a network/database/server setup

For evaluation via a network, your measuring instruments must be connected via a network and controlled by the work computer with Batalyse installation. The best way to make your measuring instruments network-compatible and configure them is to contact the respective distributor and your computer administrators.

Currently Batalyse only supports MySQL and MSSQL databases and Basytec test systems. Please contact us if you use measuring instruments of other manufacturers.

Please use the user manual of your device manufacturer. Batalyse works with MySQL and MSSQL databases.

The basic requirement is that you have installed the appropriate SQL drivers on your workstation with Batalyse installation (https://dev.mysql.com/downloads/connector/odbc/). If you haven't, please download and install this driver first.

Either start the ODBC Data Sources program from the Windows Administrator Tools or search for and run ODBC from the Start menu. The following input window appears:

Select “Add”. The following window appears. By installing the SQL driver, “MySQL ODBC Ansi Driver” should be listed. Select it and click “Finish”.

Now enter the connection data to the measurement server in the MySQL Connector / ODBC input mask. For TCP/IP Server enter the IP address or Host Name of your server. The entry “AE-T-3630-1802” shown above is only an example.

Then select the Database Import field in Origin from the File menu or directly as a function button.

The following SQL Editor window appears. Under File, select New.

In the Provider tab, select the driver “Microsoft OLE DB Provider for ODBC Drivers”. Enter the access data for your server in the Connection tab (same parameters as for the SQL Connector above).

After the input the SQL Editor connects to your server (see below). Save now under File - Save connection as an ODS object with your desired name.

To connect Batalyse to the network, select the Import from Database function key on the Batalyse Toolbar.

The following input mask appears. In Database connection settings file, select the ODS object you created previously. By selecting the checkbox Save as default and don't ask again you do not have to perform this procedure again. In the menu Database Type choose either a MySQL or MSSQL according to your settings. The optional Query Filter provides example methods to structure and filter the results before being displayed, E.g. Only show results younger than three months.

Batalyse now connects to your SQL Server and you see an overview of all stored measurements:

The most recent measurement is always listed above. A maximum of 10 measurements are displayed on your screen. By using the two black arrow keys to the left and right, further measurements can be displayed. Click on the header bar to sort the measurements by the selected column. The filters in the header help you to keep track. For example, measurements can only be displayed on a specific system if you are using several measuring stations.

Autonomous, fully automated measurement data evaluation via databases and servers

Our aim is to enable a user-independent, fully automatic data evaluation via Batalyse. For this purpose your measuring instruments must be connected to a network. The measurement data is recorded in one or more databases. Batalyse is installed on one or more servers and communicates directly with these databases. The evaluation of measurement data takes place automatically when the measurement is completed. For this purpose, Batalyse uses a database with stored measurement parameters. These must have been created specifically for each cell or test type once by a user. The users are informed when their test specimens have been evaluated and access the evaluated result diagrams in the database. An installation of Batalyse on the user computers is therefore no longer required.

At the Fraunhofer ICT in Pfinztal, Germany, a corresponding evaluation infrastructure will be set up in 2019 for demonstration purposes.