Selecting a Database Table

After you have connected to a data source, you can choose to import fields from a specific table or view. From the Data tab of the Database dialog box, you can either enter the name of a table in the Table Name field or click Select to open the Select Table/View dialog box which lists the available tables and views.

Show table owner. Select if a data source requires that the owner of a table must be specified before you can access the table. Deselect this option for data sources that do not have this requirement.

Note: SAS and Oracle databases usually require you to show the table owner.

Tables/Views. Select the table or view to import.

Show. Lists the columns in the data source to which you are currently connected. Click one of the following options to customize your view of the available tables:

• Click User Tables to view ordinary database tables created by database users.
• Click System Tables to view database tables owned by the system (for example, tables that provide information about the database, such as details of indexes). This option can be used to view the tabs used in Excel databases. (Note that a separate Excel source node is also available. See the topic Excel Source Node for more information. )
• Click Views to view virtual tables based on a query involving one or more ordinary tables.
• Click Synonyms to view synonyms created in the database for any existing tables.

Name/Owner filters. These fields allow you to filter the list of displayed tables by name or owner. For example, type SYS to list only tables with that owner. For wildcard searches, an underscore (_) can be used to represent any single character and a percent sign (%) can represent any sequence of zero or more characters.

Set As Default. Saves the current settings as the default for the current user. These settings will be restored in the future when a user opens a new table selector dialog box for the same data source name and user login only.