This dialog allows you to define a new link or edit properties of an existing link. Import links are required before data import can take place.
You can import data only into a target table which has a table definition (that is, a table which has a correct definition of a primary key, foreign keys, and reference tables). If you import data into more than one table, using the Module import method, all the tables in the target module must have a table definition.
If you select a target table which does not have a table definition or has an incorrect table definition, an appropriate message is displayed. In this case, you must either select another target table or modify the table definition.
Import method
Single table
Allows you to select a specific target table from the Name of module or table.
Module (multiple tables)
Allows you to select a specific module from the Name of module or table to be able to import data to all or specific tables associate with this module. The software displays the module tables in the Import Link window, after you select Apply and close the dialog.
Name of module or table
Depending on the import method selected, displays a list of Smart Instrumentation modules or tables.
The software only displays those tables that have table definitions for data import.
Source
These options allow you to define the import source.
Database type
Allows you to select a source Oracle version or ODBC.
Server name
Allows you to type the server name where the source Oracle database is located.
User name
Allows you to type the user name required to connect to the source Oracle database.
Password
Allows you to type the password required to connect to the source Oracle database.
Table
After connecting to the source Oracle database, allows you to select the appropriate source table from this select list.
Connect
Connects to the source Oracle database. After connecting to the required source database, the Table select list becomes available so that you can select the required source table.
Save as new link
Duplicates the current link, provided that you modified the current link name.
We recommend that you do not modify the import method when duplicating a link. This is because the source link properties are also duplicated and might be not applicable for a new link if you change the import method. For example, suppose your source import link properties include multi-tag spec options and the link is assigned to the Module (multiple tables) import method. If you change the import method to Single table, select a specification table, and save the link under a new name, the multi-tag spec option properties are applied to the new link as well. You cannot manually dissociate these properties from the duplicated link because the multi-tag spec options are disabled on the Link Properties dialog when the link is assigned to the Single table method.
View
Displays the source data for the selected file.