Examples Overview
To help you understand how TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database operates, some sample projects are packaged with the installer.
After the plug-in is installed, the sample projects are available in the TIBCO_HOME\bw\palettes\adb\version_number\samples directory. You must import the sample projects to TIBCO Business Studio™. To see more about importing projects, see Importing a Sample Project.
You can also migrate projects created in TIBCO ActiveMatrix® Adapter for Database installed on TIBCO ActiveMatrix BusinessWorks™ 6.x to ActiveMatrix BusinessWorks™ Plug-in for Database installed on ActiveMatrix BusinessWorks™ 6.x. For more information about migrating such projects, see Migrating a Sample Project.
- Sample projects for the Data Event Poller Activity
- Parent - The Data Event Poller activity polls the change in a stage table in a specified time interval. The configuration allows you to generate the required trigger SQL script file to create stage table and triggers. The following sample projects are provided with the plug-in:
- ParentChild - The Data Event Poller activity polls the change in a stage table in a specified time interval by using the parent-child relationship specified by the user key. The configuration allows you to generate the required trigger SQL script file to create stage table and triggers. The following sample projects are provided with the plug-in:
- PublishByReference - The Data Event Poller activity polls the change in a stage table in a specified time interval. Only the key values of the changed event are stored in the stage table and data of other columns is retrieved through the table's join operation. The following sample projects are provided with the plug-in:
- Sample Projects for the Data Merger Activity
- Parent - The Data Merger activity performs the insert, update, and delete operations on the parent table. The configuration allows you to generate the required exception table SQL script file to create exception tables in the database. If an exception occurs while performing a database operation, the record is inserted in the created exception or opaque table. The following sample projects are provided with the plug-in:
- ParentChild - The Data Merger activity performs the insert, update, and delete operations on the parent-child table. The configuration allows you to generate the required exception table SQL script file to create exception tables in the database. If an exception occurs while performing a database operation on the child table, the record is inserted in the created child exception or opaque table. The following sample projects are provided with the plug-in:
- Sample Projects for the Data Requester Activity
- RR_mode - The Data Requester activity allows an application to submit one or more SQL statements and procedures to be processed. The plug-in processes the request and returns the results as a reply.
- RPC_SQLEXECUTE - The Data Requester activity with mode as RPC and operation as SQL_EXECUTE is used to configure the plug-in to act as a remote procedure call server on behalf of a client with a single SQL statement to be processed.
- RPC_SQLBATCHEXECUTE - The Data Requester activity with mode as RPC and operation as SQL_BATCHEXECUTE is used to configure the plug-in to act as a remote procedure call server on behalf of a client with a sequence of SQL statements to be processed.
- RR_callprocedure - The Data Requester activity allows an application to submit one or more procedures to be processed and is used to configure the plug-in to act as a remote procedure call server on behalf of a client.
- Custom_RPC - The Data Requester activity allows an application to submit one or more stored procedures, and functions to be processed and is used to configure the plug-in to act as a remote procedure call server on behalf of a client.
The following sample projects are provided with the plug-in: