Skip to main content

ibaAnalyzer-DB

Intégration des données de base des processus dans la gestion de la production et de la qualité

ibaAnalyzer-DB, l’interface de bases de données pour ibaAnalyzer, permet d’approfondir l’agrégation des données en fonction de leur longueur ou de l’heure et de les stocker dans les bases de données avec les indicateurs calculés.

Coup d'œil sur ibaAnalyzer-DB



  • Extraction de bases de données via le fournisseur ODBC/OLE
  • Calcul et extraction transparents et compréhensibles de données de qualité et de KPI à partir de données brutes haute résolution vers des bases de données
  • Utilisation d’ibaAnalyzer et ibaAnalyzer-Reportgenerator en fonction des requêtes des bases de données
  • Réponse aux questions relatives aux processus par le biais d’une analyse des bases de données
  • Navigation souple parmi les données brutes

Calculation of Quality Data

With the iba system, production and quality data can be generated directly from data recorded with high resolution taking into account the above-mentioned requirements. For this purpose, high-resolution data must first be prepared appropriately with ibaAnalyzer, then aggregated with ibaAnalyzer-DB and afterwards loaded into a database.

Before data is loaded into the database, it can be fully „pre“-processed with the well-known analysis functions of ibaAnalyzer. In this process, existing analysis specifications can be used to extract a variety of data into the database, such as, for example:

measured signals

derived and calculated signals
(virtual signals)

statistic values,
such as maxima, minima, averages, standard deviations

characteristics calculated related to the product,
such as violations of limits, product blocking note, customer IDs, length calculations (e.g. undercoating length, prime piece length), etc.

Standard interface for databases

ibaAnalyzer-DB uses the standard interfaces OLE DB and ODBC for communication with the databases. Based on this concept, ibaAnalyzer can work with many different databases, such as, for example:

Points forts des produits

Layer Model is broken

The classic layer model of communication in production automation is consciously broken through in order to be able to offer the following advantages:

  • versatile connectivity
  • fast data acquisition
  • data pre-processing right after generation
  • calculation of KPIs direct at the source
  • source of KPI data is known and traceable
  • drill down to raw data possible
  • flexibility in case of changes - if different or more data have to be extracted into the database, only the configuration but not the communication interfaces between the individual levels need to be adapted.
Automated Data Extraction

Although ibaAnalyzer-DB uses completed measurement files as a source, analysis and extraction can be automated in a very process-oriented way. Using the post-processing function in ibaPDA or ibaLogic, the analysis can be started immediately after a measurement file has been created. Additional utilities, such as ibaDatCoordinator or batch files, are available for more sophisticated solutions.

Caractéristiques du produit

Loading data into database – scalable extraction

The user can define any number of archiving profiles for extraction in order to reduce the data volume to a small but informative amount. Each measured signal can be individually assigned to an archiving profile.

Topology – from local to plant-wide analyses

When using ibaAnalyzer-DB with a local database, e.g. quality data of a plant can be analyzed, traced and managed clearly. MSSQL Express or MS Access databases are often used for such systems.

Database query

The standard query wizard of ibaAnalyzer-DB assists the user during database query or in searching for specific data using different criteria. Queries can be saved for later use and managed with ibaAnalyzer.

Database analysis

The read data can be viewed and analyzed in used way with ibaAnalyzer-DB. It is particularly interesting to note that analyses can also be carried out directly on the basis of the prepared characteristic values of the database.

This software is one of many useful add-ons of ibaAnalyzer

ibaAnalyzer se distingue par ses nombreuses fonctionnalités d’analyse et d’évaluation. L’application offre un fonctionnement intuitif et de nombreuses fonctions complexes. La licence nécessaire pour modifier les fichiers de mesure générés avec le système iba est gratuit.

En savoir plus

Extensions pour ibaAnalyzer

Le système ibaAnalyzer peut être étendu de manière modulaire par une multitude d’add-ons utiles avec des fonctions supplémentaires

ibaAnalyzer-InSpectra

Detailed offline Vibration Analysis

ibaDat­Coordinator

Traitement automatique des données mesurées

ibaAnalyzer-Report­generator

Génération automatique de rapports

Parlez à un expert

Remplissez le formulaire et nous vous contacterons immédiatement.

Données personnelles

En choisissant un pays, ma demande sera transmise à la branche nationale d'iba AG responsable des ventes et du support.

Ressources

Anglais, .pdf, 4.9 MB

Veuillez contacter votre partenaire commercial local.

Order no.NameDescription
33.010.000ibaAnalyzer-V7Offline analysis package for iba measurement files
33.010.001ibaAnalyzer-V7-DB*Offline analysis and data generation for SQL or ODBC databases
33.010.004ibaAnalyzer-V7-DB-Multiuser*Multiuser license for 5 users
33.010.002ibaAnalyzer-V7-File-Extract*Offline data extraction from an original dat file into a new file (new format)
33.010.410ibaAnalyzer-InSpectra*Offline vibration analysis (add-on for ibaAnalyzer)
33.010.445ibaAnalyzer-E-Dat*Offline analysis for external data formats
34.000.100ibaLicenseService-V2if more than one license is used per dongle (free of charge)

* Licensing of products marked with an asterisk (*) can be done by a local dongle; or by ibaLicenseService-V2 if more than one license is used or several users need the licenses.