A1: BellaDati is built on Java EE, using PostgreSQL as reporting database.
A2: You can follow the most common configurations, but we recommend to create request for recommended configuration in our tracking system . We will need details which data sources you plan to use and often imports will run, as well as the number of users and data records in your BellaDati installation.
A3: BellaDati can run on any server that runs on Java 7 or 8. Application servers GlassFish, Jetty and Apache Tomcat have been proved to work with BellaDati.
A4: PostgreSQL is second fastest database right behind Oracle, and is the largest open source database engine worldwide, which includes biggest user community and hundreds of various useful extensions. On request, BellaDati can be modified to use Oracle or Miscrosoft SQL as reporting database.
A5: No, Oracle or Miscrosoft SQL can be also used as back-end database. In this case, customer will need to pay additional license fee for it.
A6: BellaDati can be installed on Windows and Linux/Unix servers.
A8: Transformation scripts syntax resembles the Groovy and Java syntax. It is designed to be readable and effective but not strict. Users familiar with scripting and programming should know, that some of the common features (like loops) are absent because of security and performance reasons.
A9: We recommend to use our technical documentation and follow steps described in these topics:
A10: There are 3 options how to integrate ESP8266 with BellaDati:
Data can be collected using BellaDati IoT Collector using ESP devices e.g. ESP8266 (WiFi chip) - https://en.wikipedia.org/wiki/ESP8266, using ESP device is the cheap solution.
As below, all machinery or equipment are connected to PLCs/RTUs which in turn is connected to SCADA HOST (vis HMI interface). SCADA systems are widely used in manufacturing, telecom, building management. Most of the time, SCADA Host will store this machine data into a Historian or DB . If it is a standard (ODBC compliant) Database, BellaDati connects to database and extract data for visualization, data mining, predictions or prescriptions. Depending on environment and implementation, if data has to extracted direct from PLC/RTU then we use our extension that allows to configure new connector. This is the same for Smart Building where BMS will have SCADA SYSTEM to monitor temperature, electric power, humidity, lighting condition etc.
Processing PDF and Microsoft Office documents (Word, Excel, Powerpoint) is possible in BellaDati ML Studio. BellaDati provides libraries iText, PDFBox and POI, which allow to read these file file formats. In case of XLSX, DOCX etc, it is possible to process them like XML files as well. Once the extraction model is defined (e.g. extracting text areas from PDF), it is possible to map the data on the attributes and indicators inside BellaDati data set and import desired records.