Setting virtual tables
The virtual table query loads the records into DataMagic as a virtual table file and uses SQLite3 to create virtual tables based on the loaded data.
By storing the data in the form of virtual tables, you can use SQL functionality for more flexible and efficient data acquisition. This section describes the virtual table query functionality.
DataMagic uses SQLite3 for creating virtual tables. SQLite3 is a database management system just like MySQL or PostgreSQL, but SQLite3 is much lighter and installed to an application instead of operating as a server.
Figure 3.7 Conversion that uses virtual tables
This section describes settings of virtual tables.
If you want to store a file in a virtual table, specify the information related to the virtual table in the Virtual Table Settings screen, and then specify the virtual table query value in the Output Information Settings screen.
The Virtual Table Settings screen is displayed when you double-click the virtual table icon in the Data Processing Settings screen. The Output Information Settings screen is displayed when you click the Add Row button in the Output information pane in the Set Mapping Information screen.
Screen 3.7 Virtual Table Settings screen