<< Click to Display Table of Contents >> Current:  Schedule Tasks > Task  Export into Database Task

Note: This feature is only supported by Z-Suite and Y-Vivid Show. This feature is not available in X-Suite and Y-Reporting.

Export to Database Task: Import data to the database on a regular basis according to certain conditions. The product's supported databases are MySQL, SQL Server, DB2, Oracle, Derby, PostgreSQL, Gbase8a, Hive, Hana, GaussDB 100 and GaussDB 200.

 

1. In the task area of the new job or new task interface, select the task type "Export into Database Task" as shown in the figure below.

 

2. Set the import type. "Data set" indicates that the imported type is a data set; "ML Experiment" means importing the data of the exported database node in the training experiment into the database. (Applicable to versions before 9.0, version 9.0 integrates this function into the new task Advanced Analysis Experiment)

 

3. When the import type is Data set, the user can select the desired data set in the existing data set, as shown in the following figure.

When the import type is a depth analysis experiment, the user can select the desired experiment in the existing experiment and select the Export to Database node to be imported into the database.This node needs to be added and connected in the experiment.

Note:

•If you need to run the experiment regularly and import it into the database, you need to save the nodes in the experiment as pending. Otherwise, the scheduled task export database will only execute the export node, and will not execute the node whose pre-stage status is successful.

•Database configuration information needs to be configured and saved in the experiment.

 

4.Set up a database connection. Select the required data source from the existing data source and enter the table name. The data will be exported to the specified table in the selected database. If the input table name does not exist in the database, a new table will be created in the database.

 

5. Set up the append. When the user selects append, the original data in the table still exists, and the result of the data set is directly inserted into the table. When the user does not check the append, the existing data in the table will be deleted before inserting the data set result into the table.

 

6.Click to add filter condition on the data set. Click "Edit" button to pop up the filter dialog box, click to increase the filter conditions, select the column you want to set the filter, as shown below. The data that satisfies the conditions is exported to the database.