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.
- 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 inFor example:
Select
query.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.
- 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.