Connection-specific Details - discovery - 23.1

Spectrum Discovery Guide

Product type
Software
Portfolio
Verify
Product family
Spectrum
Product
Spectrum > Discovery
Version
23.1
Language
English
Product name
Spectrum Discovery
Title
Spectrum Discovery Guide
Topic type
Overview
Reference
How Do I
First publish date
2007
ft:lastEdition
2024-02-07
ft:lastPublication
2024-02-07T17:21:58.768552
Table properties, such as columns, primary keys, and foreign keys displayed in the Properties collapsible tab on the on the Edit Physical Model page are based on the type of source connection selected in the physical model. The detail for various connection types are given below.
Note: For the steps to view the Properties of tables, see Tabular View of Physical Model.
JDBC connection
Columns
Displays the name, data type, and size of each column. The section also displays whether a column is nullable and/or a primary key.
Primary Keys
Displays the primary key, primary key name, and key sequence.
Foreign Keys
Displays the foreign key column name, foreign key name, primary key catalog name, primary key table name, primary key column name, and primary key name.
Indexes
Displays the index name, column name, and whether the indexes are unique or non-unique. If an index is non-unique then the NU check box is displayed as checked otherwise it is displayed as unchecked.
Amazon DynamoDB connection
Columns
Displays the name and data type of each column. The section also displays whether a column can be updated, searched, and/or is a primary key.
Primary Keys
Displays the primary key and primary key name.
Amazon SimpleDB connection
Columns
Displays the column name and data type for the table you select.
Flat File connection
Columns
Displays the column name and data type for the table you select.
MS Dynamics 365 Online connection
Columns
Displays the column name and data type. The section also displays whether a column is nullable and/or a primary key.
Primary Keys
Displays the primary key and primary key name.
Foreign Keys
Displays the foreign key column name, foreign key name, and the reference table name.
Permissions
Indicates which functions can be performed on the selected physical model table. Currently, the functions create, read, write, and delete can be performed on an MS Dynamics 365 Online table.
Salesforce connection
Columns
Displays the name, data type, and size of each column. The section also displays whether a column is nullable and/or a primary key.
Primary Keys
Displays the primary key and primary key name.
Foreign Keys
Displays the foreign key column name, foreign key name, and the reference table name.