The data sources are the databases that contain the data:
- The origin data source is the database where the data to subset is extracted from.
- The destination data source is the database where the data subset is injected to.
The data sources are accessed and managed in the Data Sources view.
The users that performs the extraction must have the following user privileges on the extracted tables if they are not the owner of the objects.
|MySQL||USAGE and SELECT|
|MS SQL Server||READ or SELECT|
|DB2 for i||READ or SELECT|
|PostgreSQL||READ or SELECT|
Create a data source connection
Follow the subsequent steps to create a new data source connection.
Step 1 Open the Data Sources view from the Data Sources tab, then click the Add button.
Step 2 In the Add a new Data Source wizard, define the required properties of the new data source.
All fields are mandatory.
- Enter a unique Name for the new data source. This name must be unique.
- Database Type
Select a Database Type in the drop-down list.
DOT Extract supports the following databases:
- MS SQL Server,
- DB2 for i,
- URL / Login / Password
Enter the URL of the database, as well as the Login and Password to have access to it.
- Define the database Schema to use. The database schema represents the structure of the database.
[For DB2 for i] data sources with ARCAD, define the following specific properties.
For a DB2 for i data source, the following fields are optional. However, for the ARCAD instance library and Application fields, if one is filled, the other one must be completed too.
- ARCAD instance library
- Enter the name of the library used by your ARCAD instance.
- Enter the name of your ARCAD Application.
- Enter the ARCAD version of your application.
Step 3 Click ADD to create the set data source, or CANCEL to stop the process and close the wizard.
Result The new data source connection is created.
When the data source connection is created, DOT Extract accesses the database and creates the corresponding data model. The data source creation status is In Progress.
Once the data model is created, the status of the data source is Available. Click the Refresh button in case your data source is not displayed yet in the list, or to check its status at all times.
If DOT Extract cannot access the database or create a data model, the status is Failed. When this is the case, you can click the View log button to display the data source description and the details of the log, providing information about why the connection failed.
Edit a data source connection
When you edit the data source connection, the data model is calculated again by DOT Extract.
To edit a data source connection, click the View button to display the details of the data source, then click the Edit button.
The Edit page opens and enables you to edit the Data source Type, the URL, the Login or the Schema fields.Click the Save button to save the changes.
For more information about data models, refer to Data Models.
Delete a data source connection
To delete a data source connection, click the View button to view the details of the data source, then click the Delete button.
A confirmation dialog opens, click Delete to confirm, or Cancel to keep the data source.
Deleting a data source connection also deletes its data model. Once deleted, the data source and its data model cannot be accessed or recovered.