Transports and Interfaces: Siebel eBusiness Application Integration Volume III > Using Siebel OLE DB Provider > Installing the Siebel OLE DB Provider >

About Primary and Foreign Key Relationships

Siebel OLE DB Provider supports Primary and Foreign Keys for creating links between Siebel business components in a Siebel business object. With Siebel OLE DB Provider, you will be able to determine the relationships between business objects. Different OLE DB consumers may use this feature in different ways. For example, Microsoft Access shows Primary and Foreign Keys in a tree pane. You can use this information to build queries that use relationships between business objects.

NOTE:  A Primary Key is a set of fields where there is more than one available key field that can establish a relationship, but only one of the keys is chosen by the DBA to be the Primary Key. A Foreign Key is a field whose values are keys in another relationship.

To enable primary and foreign key support

1. Access the Windows Registry and expand HKEY_CLASSES_ROOT.
2. Expand the key CLSID.
3. Expand and highlight the key {84C9F452-1ECC-11d3-9D36-0080C7AAC8A7}.

   The default value should be Siebel OLEDB Provider.

4. Highlight the key Parameters.
5. Right-click to select New > DWORD Value.
   1. Set the Name of the new value to EnablePkFk.
   2. Set the value in the Value Data field to 1.
6. Select File > Exit to close the Windows Registry and save your changes.