The injection process recreates the data subset in the chosen destination data source. The injection results is the log of the injection process.
Injections are accessed and managed in the Injections view.
The users that perform the injection must have the following user privileges on the target database tables, if they are not the owner of the objects.
|MySQL||USAGE, SELECT, INSERT or UPDATE|
|MS SQL Server||SELECT, INSERT, UPDATE or ALTER|
|Oracle||SELECT, INSERT, UPDATE or ALTER|
|DB2 for i||SELECT, INSERT or UPDATE|
|PostgreSQL||The user must be the owner of the table.
Required by the ALTER TABLE for referential constraints.
Create an injection
Follow the subsequent steps to create a new injection.
Step 1 Click on the Injections tab to open the Injection view, then click the Add button.
Step 2 Define the main properties required for the new injection.
- Enter a unique Name for the new injection.
- Extraction Result
- Select an Extraction Result in the drop-down list.
Step 3 Define the Target Data Sources required for the injection.
- Data Source
- Select a Data Source in the drop-down list. You can select multiple destinations in the list to create multiple injections. To do so, click on the Add button to confirm the selected data source and to be able to define another, if necessary. To remove a data source, click the Delete button.
In case of multiple injections, the data is injected successively into the selected destinations and not simultaneously.
Multiple injections are exclusively possible on databases with the same type and structure as the source database used for the extraction.
Step 4 Click DONE to validate the injection and close the dialog.
Result The new injection is created and appears in the list of injections.
To edit an injection, click the View button to view the details of the injection project, then click the Edit button. The Edit page opens and enables you to edit the Name, the Extraction Result and the target data source(s).
Make sure you click the Add button when you select an additional data source for injection, to save it and being able to add another one. Click the Delete button to remove an existing data source.
To execute an injection, click the Inject button. A dialog opens to confirm that the injection is launched. You can track the status and the results of the injection in the Injection Results view.
For more information about the Injection Results, refer to Injection results.
To copy an existing injection project, click the Duplicate button. Edit the name of the injection to copy to avoid having duplicates in the list, then click Done.
Delete an injection
To delete an injection result, click the View button to open the Edit page of the injection, then click the Delete button.
A confirmation dialog opens, click Delete to confirm, or Cancel to keep the injection.
Deleted injections cannot be accessed or recovered.