IntegrationSystemConfig
The IntegrationSystemConfig table contains the configuration data for each system. For Microsoft Great Plains, it contains the configuration nodes that are sent into the business objects that communicate with the Microsoft Great Plains SQL Server. For Microsoft CRM, it contains information used for connecting to Microsoft CRM through certain databases or SOAP.
The Microsoft CRM Integration Settings and Administration Tool is used to set many of these values. The rest are set during installation, and the contents are determined based on the configuration at installation.
If a new entity is created and it contains configuration data, it could be placed in this table.
| Column | Description |
| NodeID | A unique identifier for the record. |
| SystemID | The unique identifier from IntegrationSystemMaster.SystemID. |
| NodeName | A name that concisely describes the data. This is used as the XML node name when the XML data is generated to represent this configuration. |
| NodeDescription | A description of the data. |
| NodeType | A flag indicating whether this node is to be included when the XML data is generated.
Values: 0 – no 1 - yes |
| NodeDataType | The type of data stored in NodeValue. |
| NodeValue | The configuration value. |