MAILAB - Acquiring dataset from the MS SQL database

MAILAB - Acquiring dataset from the MS SQL database

Summary: this document describes how to connect to database in MAILAB AI and gain data from tables to Data Sets

This feature is available for version 1.04E and later 


Open Mialab (1)  and start the project (2)





Go to Data Set tab (1) and add new dataset (2)
Give the dataset a name and select DB as the source of the data (3)




Now it is necessary to set DB Connection (1)
Select type of DataBase Server. You can use MySQL, PostgreSQL, MS SQL Server (2)
Provide necessary setting - IP address of SQL Server, port number, DB name and SQL user (3)
Try to perform connection test (4)
If it is succeded you will see message (5)



Now, create query 



Generate sample query (1)
Change sample database name to some of the tables in your Database (2)
Run the query (3), if succeeded, you will se message (4) 
Then switch to  acquired data to see you dataset (5)









If you have DB Connection and Query configures, click NEXT



Check your data and click Complete



Now, you have a table with data downloaded from your database table. You can start training AI based on this data


    • Related Articles

    • Configure GOT2000 MES Interface function with MS SQL 2017

      This article will show You how to configure GOT2000 panel to log data to MS SQL 2017. Prepare before configuration - Install Microsoft SQL Server Express 2017 (called MS SQL Server). - Install Microsoft SQL Server Management Studio. - Install DB ...
    • RJ71EIP91 - Ethernet/IP connection with NZ2FT-EIP

      Artykuł opisuje połączenie modułu RJ71EIP91 (master ethernet/IP) z couplerem NZ2FT-EIP (slave ethernet/IP) za pomocą komunikacji Class1 i Class3/UCMM The article describes connection of RJ71EIP91 (master ethernet/IP) with coupler NZ2FT-EIP (slave ...
    • Iconics Suite - Melsoft connection with iQ-R [Iconics Suite connection]

      Detailed description how to configure connection between Iconics Suite SCADA and iQ-R PLC controller using Melsoft Connection Remember that your PC has to have the static IP address in the same subnet as PLC. iQ-R PLC default address is 192.168.3.39 ...
    • Iconics Suite - Filtering data with Database DataSource parameter

      This article shows you how to use Data Entry control and Database DataSource parameter to filter data in Table Control In attached files you can find GraphWorX64 display with sample solution. To make it work you have to use Iconics project package - ...
    • Connection between GOT 2000 and GT Designer3 (PC) over RCPU with RJ71EN

      This article describes connection between GOT 2000 and GT Designer3 over RCPU with RJ71EN Ten artykuł opisuje połączenie pomiędzy panelem GOT 2000 i oprogramowaniem GT Designer3 poprzez sterownik RCPU z modułem RJ71EN 1. PC -> RCPU -> RJ71EN -> GOT ...