The database write function is available as a Database Write process in TS Quality. The Database Write process allows you to link the output of the process or project to a database table, so you can directly return the results to the database without using any other ETL tools.
Warning: This functionality is designed
to support interest in writing to staging environments in production
processes or temp tables in test environments. The Database Write
process will overwrite the database table and will not append or
update the data. The attributes in the table that are not selected for
mapping will be blanked out. We recommend the database write operation
always be performed in a staging area and not directly in the original
tables.
|
Use the following steps to configure and run the Database Write process:
Add a Database Write process
To add a Database Write process
Specify the Database Write process options
To specify the Database Write process options
Map the output attributes
To map the output attributes
When the database settings are validated, you are ready to map the attributes from the input to your database table.
Specify the output settings
To specify the output settings
These settings are all optional.
Run the Database Write process
To run the Database Write process
Before running the process, always run it in test mode first and preview the results. When you click the Preview button, the process runs only in the Control Center and does not access the database, so you can safely preview the results as if the database had been accessed.
- Select the Option tab.
- Make sure that the Run in test mode option is selected.
- Click Preview to see the results from the test mode. You can also run the process or double-click the output entity (the database icon).
- When you are satisfied with the results in the preview, clear the Run in test mode option and click Finish to save the change.
- Run the process. The output will be written to the database.
Export a project with the Database Write process
To export a project with the Database Write process
- From the Navigation or Project View, right-click the project and select Export. The Export Project Options window opens.
-
Specify the options as you would for a regular batch export or project
definition. See Exporting a
Project to a Batch Script or Exporting a Project
Definition.
- (Optional) If you want to load data from the database at the beginning of the batch processing, select the Include database source data with export option and select Include Database Read for <table_name>. See Reading Data from Database for a Batch Script for more information.
- Click Export.