Knowledgebase
Syncing to a destination ODBC data source
Category:ODBC
Last Updated:2011-08-18
Download PDF version
ODBC Connection Information
System DSN - Select a DSN (Data Source Name) from the available list of DSNs. If you do not yet have a DSN for your odbc source, refer to the Configuring ODBC topic for information on how to create a System DSN.
ID - If your DSN references a password protected database, enter the necessary Login ID.
Password - Password for Login ID specified above.
Destination Table Information
Table Name - Specify the name of the database table to write to.
Index Field - Specify the name of the table's index field.
Note: If objects already exist in your destination database, this index field is used to identify matching entries between source and destination. The destination attribute to compare against is the one mapped to your Index field in your Custom Map file. (i.e. YourIndexField=^SourceAttribute^)
Important Notes about your Destination Database
- The Destination Database must exist and the table to write to must also exist and have all columns defined.
- (UnitySync does not create the database, table or columns.)
- Custom Mapping is required. See the Custom Attribute Mapping Topic for details on creating a custom mapfile. Also see the Custom Mapping: ODBC/Oracle topic for details specific to an ODBC destination.
- It is highly recommended that this index field be configured in the destination database as
"Duplicates Allowed = No" otherwise, duplicate source data may result in duplicate database entries. Also, UnitySync Recovery Procedure will not process successfully unless "Duplicates Allowed = No"
- When syncing to a database via an ODBC destination, if your destination index attribute is not Modifiable, be sure to add the following attribute to the connection's Raw Config. This allows the sync to create objects and set the destination Index attribute on the initial ADD, but will not attempt to write that attribute on subsequent Modifies.
no-mod-attribs=IndexAttributeName