Connection-specific Details

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.

Apache Cassandra connection

Columns: Displays the column name and data type. 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.

Flat File connection

Columns: Displays the column name and data type for the table you select.

Marketo connection

Columns

Displays the column name and data type. The section also displays whether a column is a primary key, readable or updatable.

Primary Key

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. The functions Read, Insert, Update, Upsert and Delete can be performed on Marketo tables.

Filter Types

Indicates the column on which search is applicable. For example, id as Filter Type in Lead indicates Lead can be searched with id.

Note: Marketo does not support multiple Filter Types in Select query.

For example:

Valid Query:

Select * from Lead where id = 1234

Select * from Lead where email  = 'abc@txyz.com''

Invalid Query:

Select * from Lead where id = 1234 and email  = 'abc@txyz.com''

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.

NetSuite 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, and which of the functions create, read, and update can be performed on the column.
Primary Keys: Displays the primary key and primary key name.

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.

SAP NetWeaver 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.
Permissions: Indicates which functions can be performed on the selected physical model table. Currently, the functions create, write, and delete can be performed on an SAP NetWeaver table.

Splunk Connection

Columns: Displays the name and data type of each column. The section also displays whether a column can be updated, searched, and/or a primary key.
Primary Keys: Displays the primary key and primary key name.

SuccessFactors connection

Columns: Displays the name, data type, and size of each column. The section also indicates whether a column is nullable and/or a primary key, and which of the functions filter, insert, sort, update, upsert, and view can be performed on the column.
Primary Keys: Displays the primary key columns and the respective primary key name of which each is a part.
Foreign Keys: Displays the foreign key column name, foreign key name, and the reference table name.
Permissions: Indicates which of the functions insert, update, upsert, and delete can be performed on the selected physical model table.

SugarCRM connection

Columns: Displays the name, type and size of each column. It also shows whether a column is nullable and updatable.
Primary Keys: Displays the primary key names, column and key sequence.
Foreign Keys: Displays the foreign key column name, foreign key name, and the reference table name.

Siebel connection

Columns: Displays the name, type and size of each column. The section also displays whether a column is nullable and updatable.
Primary Keys: Displays the primary key names, column and key sequence.
Foreign Keys: Displays the foreign key column name, foreign key name, and the reference table name.