Using Virtual Business Components To Implement Custom Queries (Doc ID 476857.1)

Last updated on APRIL 18, 2025

Applies to:

Siebel System Software - Version 7.5.1 SIA [15028] and later
Generic (Platform Independent)
Area(s):Siebel EAI
Release(s):V7 (Enterprise)

Database(s):All Supported Databases
App Server OS(s):All Supported Platforms
Latest release tested against:V7 (Enterprise)
Keywords:VBC, Query, Custom, Custom Query, Virtual BC, GROUP BY

This document was previously published as Siebel Technical Note 399.

Purpose

Notice:

Virtual Business Components(VBC) are normally used to access external databases. This document describes how to use VBCs to access Siebel database and implement certain functionality that cannot otherwise be implemented using "standard" configuration through manipulation of Siebel Tools objects.

Be aware that accessing Siebel database directly, using SQL statements is not supported. In this document, Siebel database is accessed through supported methods described on Siebel Object Interfaces Reference Guide.

In certain occasions, Siebel configurators need to implement complex requirements that cannot be accomplished using the standard techniques : Manipulation of object properties in Siebel Tools, or adding functionality to objects using scripting.

One of such requirements is the implementation of custom queries that require the use of certain special clauses like GROUP BY. Since accessing the Siebel database directly through SQL instructions is not supported, all data manipulation needs to be done at business component level, using the methods that Siebel provides.

Virtual Business Components are implemented using a business service. The records returned are determined by the logic of the business service. This flexibility allows for the implementation of complex queries, as this document will show.