Marketo Connector Guide > Working with Custom Objects and Custom Attributes in Marketo > Creating Schema File
  

Creating Schema File

You need to create schema file to define each Custom Object added in ‘Marketo.tbl’ file. Schema file helps you to configure each Custom Object parameters. The file schema file name must be same as the value mentioned TABLE_NAME Field of Marketo.tbl file.
Example schema file name, Responder.SCH.
The schema file needs to be created in specific format as shown in the figure below.
Create schema file using the following table definitions.
Header Name
Allowable Value
Remarks
ISKEY
Y, Any Character
If ‘Y’ is entered then Key Field is active. Define Key field, when you want to add 'Upsert' operation for Custom Object.
ISNULLABLE
Y, Any Character
By entering ‘Y’, the field is defined as mandatory or non-nullable in Informatica Cloud DSS Task.
ISFILTERABLE
Y, Any Character
If ‘Y’ is entered the field is displayed in the data filters tab for the selected Custom Object.
DATATYPE
Integer, string, date, Boolean,
long, float
Any data type mentioned in the ‘Allowable Value’ is supported in the schema file. Any other custom data type is considered as String.
PRECISION
Valid Number
Set the precision required using this field. Note: Precision for string data type is variable, while for other data types it is constant.
SCALE
Valid Number
The scale value should always be same as precision value.
FLD_DISPLAY_NAME
Characters A to Z/ a to z. Special character Underscore.
The field name that will visible in Informatica Cloud UI. Alphabets (both Caps and small) are allowed. Only underscore ’_’ special character is allowed.
FLD_NAME
Any MS Latin1 Characters
This name is used for RPC call to the Webservice Endpoint. (can be called as technical name)
FLD_DESCRIPTION
-
Field description
Y-Yes N-No