Transports and Interfaces: Siebel Enterprise Application Integration > Using Siebel OLE DB Provider > Connecting Siebel Data Using OLE DB Consumers >

Creating and Modifying Siebel OLE DB Rowsets

This section covers creating and modifying Siebel OLE DB rowsets.

The Siebel OLE DB Rowset object is exposed as a Siebel integration object in Siebel Tools. You create the OLE DB integration object using the OLE DB Rowset wizard.

To create the Siebel OLE DB Rowset object in Siebel Tools

1. Start Siebel Tools.
2. Lock the project from which you will be creating the OLE DB rowset.
3. Choose File > New Object to display the New Object Wizards dialog box.
   1. Select the EAI tab.
   2. Select the OLE DB Rowset icon and click OK.
4. Select the items from the drop-down lists to define your rowset as follows:
   1. Choose the locked project from which you will be creating the OLE DB rowset.
   2. Choose the Siebel business object that represents the data you want as the basis of your OLE DB rowset.

      The wizard displays the business components that are used by this business object.

   3. Choose the business component you want to use to populate your OLE DB rowset with data.

      The system automatically generates a unique name for your OLE DB rowset by concatenating the business object name and the business component name and adding a unique number (starting with 1), such as Account_Contact_1. You can change this name as needed.

      NOTE:  Siebel Tools limits this field to a maximum of 75 characters. If the combination of the business object and the business component names is more than 75 characters, the name will be truncated, starting from the right. Again, you can change this name as needed. It is recommended that you use the following: Business Object_Business Component_Unique Identifier.

   4. Choose the Visibility Type for the rowset.

      NOTE:  You can limit the data users are allowed to see based on their Siebel-defined responsibility and visibility privileges. Visibility levels can be set for each rowset.

5. Click Next to select the fields you want to include in your OLE DB table. You can select one or more fields by using the following standard techniques:
   • To select a single field, click on a field name, then click the right arrow button to move the field name to the scrolling field on the right.
   • To select multiple fields, click on a field name, hold down the Ctrl key on your keyboard and click on another field name.

     Repeat this process to select any number of field names. Alternatively, you can click on a field name, then hold down the Shift key on your keyboard and click on another field name farther down the list. This selects all the field names between and including your two selections.

6. Rearrange the order of the field names, if necessary, by clicking the up and down arrow buttons to move a selected field name in one direction or another.

   NOTE:  Rearranging the field names at this point in the process can make it easier to view the data in a more meaningful order when you access the OLE DB table from another application.

7. Click Next.

   The OLE DB Wizard displays the OLE DB Rowset. This page allows you to review and confirm your selections.

   • To change one or more of your selections, click Back to return to the previous page of the wizard.
8. If you are satisfied with your choices, click Finish.

   The OLE DB wizard creates the OLE DB integration object.

9. Recompile the .srf file.

   Siebel OLE DB Provider retrieves integration object information from the .srf file.

   • Select Tools > Compile (or press F7).

     You can now access the Siebel OLE DB integration object using any external OLE DB-enabled applications.

     NOTE:  Integration objects are created slightly differently by the OLE DB Rowset wizard than by any other integration object wizard. In other chapters of this guide, you read that integration objects provide the interface between external data objects and the Siebel property set format. The OLE DB Provider integration objects you create convert data between Siebel Business Object Interfaces and OLE DB rowsets.

To modify a Siebel OLE DB rowset object in Siebel Tools

1. Lock the project from which the OLE DB rowset was originally created.
2. Access the list of integration objects and highlight the OLE DB rowset you want on the Integration Objects list.
3. Right-click on the OLE DB rowset you want to modify.
4. Select Edit OLE DB Rowset from the pop-up menu.

   The Edit OLE DB Rowset wizard appears, displaying the details on the rowset. This first page is read only, but it can be changed using visibility rules.

5. Click Next and select the fields you want to include in your OLE DB table and deselect others that you want to remove.
6. Rearrange the order of the field names, if necessary, by clicking on the up and down arrow buttons.
7. Click Next to get to the finish page to review and confirm your selections.
   • To change one or more of your selections, click Back to return to the previous page of the wizard.
8. If you are satisfied with your choices, click Finish.

   The OLE DB wizard modifies and saves the OLE DB integration object.

9. Recompile the .srf file.

   Siebel OLE DB Provider retrieves the integration object information from the .srf file.

   You can now access the Siebel OLE DB integration object using any external OLE DB-enabled applications.