- Index

< Previous |  | Next >

# Database Change Data Capture Input Adapter Sample

## About This Sample

This sample demonstrates the use of the Database Change Data Capture Input Adapter for Oracle and SQL Server databases.

## Initial Setup

1. Scripts are provided for Windows to configure your database for change data capture. If using SQL Server, modify `setup-cdc-sql-server.sql` with your site-specific database credentials. Run `setup-cdc-oracle.sql` or `setup-cdc-sql-server.sql` to configure CDC for your Oracle or SQL Server database, respectively. In addition to configuring change data capture, these scripts above create a database table, `Customers`, for which change activity is captured.

2. Add the JAR file containing the JDBC driver for your database — `ojdbc6.jar` or `sqljdbc4.jar` — to your Maven repository and or add the dependency to the project's pom file.

## Importing This Sample into StreamBase Studio

In StreamBase Studio, import this sample with the following steps:

- From the top-level menu, click File → Load StreamBase Sample.

- Enter to `cha` narrow the list of options.

- Select change-data-capture sample from the Native Database Connectivity Adapters category.

- Click OK.

StreamBase Studio creates a project for the sample.

## Running This Sample in StreamBase Studio

1. In the Project Explorer view, open the sample you just loaded.

   If you see red marks on a project folder, wait a moment for the project to load its features.

   If the red marks do not resolve themselves after a minute, select the project, right-click, and select Maven → Update Project from the context menu.

2. Open the `src/main/eventflow/`packageName`` folder.

3. Open the `change-data-capture-oracle.sbapp` or `change-data-capture-sql-server.sbapp` file to open the sample application for Oracle or SQL Server, respectively.

4. Select the adapter icon to open the Properties view for the adapter.

5. Select the Adapter Settings tab and note that the populated values match those configured through the scripts above.

6. Click the Run button. This opens the SB Test/Debug perspective and the application.

7. In the Studio's Output Streams view, observe tuples emitted on the adapter's `Status` output port indicating it has connected to the database and enabled CDC.

8. Using a tool such as sqldeveloper or SQLPlus for Oracle or SQL Server Management Studio or sqlcmd for SQL Server, modify the contents of the Customers table by inserting, updating, and deleting records. If using Oracle, commit the changes to ensure the redo log gets written promptly.

9. In Studio's Output Streams view, observe tuples emitted on the Capture output port indicating changes have been made to the `Customer` table.

10. When done, press F9 or click the Terminate EventFlow Fragment button.

## Sample Location

When you load the sample into StreamBase Studio, Studio copies the sample project's files to your Studio workspace, which is normally part of your home directory, with full access rights.

### Important

Load this sample in StreamBase Studio, and thereafter use the Studio workspace copy of the sample to run and test it, even when running from the command prompt.

Using the workspace copy of the sample avoids permission problems. The default workspace location for this sample is:

    studio-workspace/sample_change-data-capture

See Default Installation Directories for the default location of `studio-workspace` on your system.