ibaAnalyzer-DB
Integración de datos de procesos básicos en la gestión de la producción y la calidad
ibaAnalyzer-DB, la interfaz de bases de datos de ibaAnalyzer, permite seguir agregando la longitud de los datos medidos o el tiempo relacionado y grabarlos en bases en datos junto con los valores característicos calculados.
ibaAnalyzer-DB de un vistazo
![Integration of basic process data - ibaAnalyzer-DB](/fileadmin/img/software/iba-analyzer/integration-of-basic-process-data-ibaAnalyzer-DB-monitor.jpg)
- Extracción de bases de datos mediante proveedor de DB ODB/OLE
- Cálculo y extracción transparentes y comprensibles de datos sobre calidad y valores característicos (KPI) a partir de los datos sin procesar de alta resolución en las bases de datos
- Uso de ibaAnalyzer e ibaAnalyzer-Reportgenerator en función de las consultas en la base de datos
- Respuesta de preguntas relacionadas con los procesos mediante análisis de las bases de datos
- Desglose flexible en datos sin procesar
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 and loaded into a database with ibaAnalyzer-DB.
Before data is loaded into the database, it can be fully „pre“-processed with the well-known analysis func tions 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.
text information
Standard interface for databases
ibaAnalyzer uses the standard ADO NET connectors for communication with the databases. Based on this concept, ibaAnalyzer can work with many different data bases, such as, for example:
![](/fileadmin/img/logos/connectivity/access.png)
![](/fileadmin/_processed_/7/3/csm_ibmdb2_90c6be457d.png)
![](/fileadmin/_processed_/e/0/csm_mariadb_be0b598bc7.png)
![](/fileadmin/_processed_/b/8/csm_mysql_8c56cf4937.png)
![](/fileadmin/_processed_/8/d/csm_oracle_f3e83c79bf.png)
![](/fileadmin/_processed_/f/9/csm_postgresql_867d838767.png)
![](/fileadmin/_processed_/b/1/csm_sqllite_e03f26c35f.png)
![](/fileadmin/_processed_/6/b/csm_sqlserver_45321c8189.png)
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 uses completed measurement files as a source, analysis and extraction can be automated in a very process-oriented way. Using the postpprocessing 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.
Product Features
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 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 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
Data read from databases can be viewed and analyzed in the usual way with ibaAnalyzer. 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.
Measured data and quality data
With iba applications such as ibaPDA, ibaQDR or ibaLogic, data from automated production plants and technical processes can be acquired flexibly and stored in a measurement file. Data is generally recorded with a high time resolution in order to provide information as detailed as possible.
Automatic table creation
The database in use can be located on the same system as ibaAnalyzer or on a server in the network. The connection between ibaAnalyzer and the database has to be configured once; the tables will then be created automatically by ibaAnalyzer at the click of a button.
Licensing
Extracting into databases can be used interactively with ibaAnalyzer without license.
This software is one of many useful add-ons of ibaAnalyzer
ibaAnalyzer se caracteriza por sus amplias funciones de análisis y evaluación. La aplicación ofrece un funcionamiento intuitivo, junto con un variado alcance de funciones. La licencia para editar archivos de medición generados con el sistema iba es gratuita.
Success Stories
Póngase en contacto con su distribuidor local.
Order no. | Name | Description |
---|---|---|
33.010.000 | ibaAnalyzer | Offline analysis tool* |
33.010.003 | ibaAnalyzer-DB-Read | Offline analysis: read data from SQL databases |
33.010.008 | ibaAnalyzer-DB-Read-5 | Offline analysis: read data from SQL databases, 5 users |
33.010.410 | ibaAnalyzer-InSpectra+ | Offline vibration analysis: trend and output of InSpectra results in ibaAnalyzer |
33.010.411 | ibaAnalyzer-InCycle+ | Offline analysis of cyclic processes: trend and output of InCycle results in ibaAnalyzer |
33.010.445 | ibaAnalyzer-E-Dat | Offline analysis for external data formats |
33.010456 | ibaAnalyzer-Add-On-TDMS-Extract | Offline data extraction from an original DAT file into a TDMS format (free of charge) |
* Software is licensed free of charge for analyzing measurement data generated with the iba system.