Schemas

A Schema is an object that defines data. This includes metadata qualities like data type, field length, decimal places, and EDI message ID. It also includes descriptions of fields, cells, or elements, such as order number, unit price, etc.

Clarify uses the Schema object to determine how a document should be read or written.

There are different types of Schemas:
  • Database Schema: Clarify populates the Schema with the tables and columns specified in a Data Source, and reads the database's metadata to create the table and column properties.

  • EDI Schema: You choose a message ID (ex. 850 purchase order), and Clarify populates the Schema with all segments and elements. You can then customize as needed. Clarify supports X12, EDIFACT, and TRADACOMS standards.

  • Flat File Schema: If you have a sample flat file, Clarify determines whether it's fixed-length or delimited. It then reads the data and allows you to create field headings (ex. first name) and specify data types (ex. string). Or you can create a Schema from scratch, detailing each field one at a time.

  • JSON Schema: JSON is a text format that facilitates structured data interchange between all programming languages. JSON is a syntax of braces, brackets, colons, and commas that is useful in profiles, applications, and additional contexts. Clarify gives you options to build a Schema manually, or to import or paste content directly from a JSON document.

  • Oracle Schema: Clarify uses your Oracle e-Commerce Gateway file to create a Schema.

  • SAP Schema: Clarify uses your SAP IDoc definition file to create a Schema.

  • Spreadsheet Schema: A Schema wizard helps you to create a Schema based on a sample spreadsheet, and then guides you through the process of selecting cells, creating headings (ex. first name), and specifying data types (such as String, Number, Boolean, or DateTime). The sample spreadsheet, stored as a template file, can be reused to build and maintain multiple Spreadsheet Schemas. You can also create a Schema from scratch, detailing each cell one at a time. Another option is to use an existing spreadsheet Schema to easily create a new one.

  • XML Schema: This Schema (xml.objSchema) handles complex XML data structures using an XML Schema Definition (XSD). The Clarify XML Schema wizard helps you build binding files that can be used repeatedly to create and define XML Schemas.

  • Connector Schema: This specialized Schema (NetSuite/Salesforce.ObjSchema) also handles complex data structures from XML, and is generated by Clarify as part of its Cloud Connector support for Salesforce and NetSuite applications. The Connector Schema is read-only. Use the Cloud Connector Wizard to create this Schema type.

Business Use

Each transformation requires two Schemas: one for the source document and one for the target document. Without a Schema, Clarify would not know how to format the data when creating a file.

For example, if your data is housed in flat files and you want to send an EDI message to your trading partner, you would create a Flat File Schema tailored to your source document and an EDI Schema specifying the target message you are sending to your trading partner.

How the Object Works

A Schema is referenced in a Ruleset. When you are creating a Ruleset, Clarify asks for the source and target Schema types, and you specify the specific Schemas for each. Then you use the pieces of the blueprint (fields, cells, elements, etc.) in the Schemas as input and output for rules within the Ruleset.

For example, if you create a move Rule, you can assign a Flat File field called Date in the Schema as input for a Date cell in a Spreadsheet Schema. During transformation, Clarify uses that Rule to move the actual date data from your flat file's field into a newly-created spreadsheet file's cell.
Note: Clarify can automatically create a Transformation Settings object when you create a Flat File Schema with delimited data. See related help on Transformation Settings for more information.

Process Summary

To use Schemas, you must:
  • Create two Schemas, one that corresponds with the source file type and one that corresponds with the target file type. It is ideal to use sample data to create a Schema if using flat files, spreadsheets, or XML.
  • Define or customize each Schema, if necessary.
  • Create a Ruleset and assign the Schemas.