Can Datanamic Data Generator Connect to a Database to Use It As a Source of Data?Yes, you have the ability to connect to a database to use as a source of data to populate the target table. You can use this for example to generate data for the PRODUCT_PURCHASED column in the ORDERS table using the data available in the PRODUCT_ID column of the PRODUCTS table.
You can select a source table by selecting the Random value from DB table fill type in the Field settings pane. After selecting this fill type, the DB table and DB table column entry fields appear below the fill type field. Here you can select the table and the column/field containing the source data. Note that the external table you refer to must be part of the database you want to populate.