Managing Schema
Use the Manage Schema dialog to compare the database schema in Infor CRM with your integration schema to ensure data integrity. You can compare data for various resources to determine if differences in string lengths exist between systems.
Tell me more about how Infor CRM manages schema differences...
MaxLength - If data is synchronized to Infor CRM that exceeds the MaxLength of a field, the entire row will be rejected.
FractionalDigits - If data is synchronized to Infor CRM that exceeds the number of decimal points, the value will be rounded to the maximum digits allowed after the decimal point. For example, if a currency field is defined as 17.4, then a value of 123.12348 is saved as 123.1235 and a value of 123.12343 is saved as 123.1234.
Open the Manage Schema dialog
- On the Integration Detail view Resources tab, click the Manage Schema
button.
Compare schema for resources
- In the Manage Schema dialog Filter By Resource box, select the resource type.
- Click Execute.
-
Review the differences in the grid.
Note any information that may cause data integrity issues. For example, an accounting system field may only accept three characters when the same field in Infor CRM accepts free text. - Repeat for all resource types.
- Click Close.
