Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Entity information tables (cdf_<entity>_info) contain the migration information for the entities you migrate to Microsoft CRM. There is one record in the entity information table for each record in the associated entity base table. When a record is inserted or deleted in an entity base table, a trigger automatically adds the associated record to or deletes the associated record from the entity information table to keep the data synchronized between the two tables.
If you want to track the connection between your data source and where the data ended up in Microsoft CRM, you can load each record of the entity information table with the source name, source entity name, and the source identifier both as a string and as an integer. The source strings are not migrated but they provide you with the ability to trace each record from Microsoft CRM back to your source system.
The CDF Migration Tool adds the destination GUID from Microsoft CRM in the DestinationID attribute in the entity information table when the record has been migrated successfully. The GUID data is useful for tracking what records have been migrated successfully—if the record does not have a GUID, it was not migrated. You can also use the GUID to find the record in Microsoft CRM.
The following table shows the attributes in the cdf_<entity>_info tables.
| cdf_<entity>_Info attribute | Description of attribute |
| <Entity>Id | Primary key for the table. |
| SourceSystemName | Name of the source system (for example, ACT, GoldMine). The migration tools do not use this attribute, but you can use it as a reference in case you later need to look up where data came from in your source system. |
| SourceEntityName | Name of the table in the source system where the data originates. It can be used to distinguish entities coming from different source systems or different databases of the same source system (for example, Contact_1). The migration tools do not use this attribute, but you can use it as a reference in case you later need to look up where data came from in your source system. |
| SourceIdStr | Identifier of the source object in the form of a string, (for example, AdvWks-3 for a source database that uses a combination of characters and numbers in the identifier attribute). The migration tools do not use this attribute, but you can use it as a reference in case you later need to look up where data came from in your source system. |
| SourceIdInt | Identifier of the source object in the form of an integer (for example, 3). The migration tools do not use this attribute, but you can use it as a reference in case you later need to look up where data came from in your source system. |
| DestinationSystemName | Name of the destination. The default value for this attribute is Microsoft CRM.
Important Do not change this value. |
| DestinationEntityName | The name of the Microsoft CRM entity to which this data is migrated. This attribute value is the name of the entity represented in the entity information table name (for example, in the cdf_account_info table, this attribute value is account).
Important Do not change this value. |
| DestinationId | The Microsoft CRM GUID. The CDF Migration Tool populates this attribute after the record has been migrated. You can use this attribute to track what records have been successfully migrated. |
| StatusCode | Status indicates the success or failure codes during the migration of this object. This attribute is used only by the CDF Migration Tool. Do not change it. |
| IsLinked | [Reserved for future use.] |