Load Ingest Data
Results 1 to 3 of 3

Thread: CDC Solution Perspective - Implementation Guide, Stream Service

  1. #1
    David is offline Documentation
    Join Date
    Aug 2006
    Posts
    72
    Rep Power
    14

    CDC Solution Perspective - Implementation Guide, Stream Service

    The Stream Service configures the following:

    • Staging area
    • Filtering of changed columns
    • Auditing information



    Note: Null filtering is currently unsupported. Filtering empty values is supported. Space values are truncated and are handled as empty values.

    To configure the Stream Service:

    1. Click the Stream Service link.
      The Stream Service wizard opens.

      Note: This screen will only appear if you selected the inclusion of a staging area in your solution.
    2. Select Eliminate uncommitted changes to eliminate uncommitted changes from your CDC project.
    3. Select the use secured connection checkbox to configure the staging area to have a secured connection to the server. This is available only if you logged into the server using user name and password authentication.
    4. Set the event expiration time in hours.
    5. Under File Locations, click the Browse buttons to select the location of the changed files, and temporary staging files, if necessary.
    6. Click Next.
      Select the tables to use in the filtering process.
    7. Click the required tables in the left pane and move them to the right pane using the arrow keys.
    8. Click Next.
    9. Select the columns from which to receive changes.

      Note: Table headers will appear grouped together in a separate table at the beginning of the list. You can also request the receipt of changes in the headers’ columns.

      Any data changes in the columns selected will be recorded.
    10. Click Next.
      Indicate the types of changes you want to receive in the tables and which columns to display.
    11. Select the actions from which you want to receive change information. Your options are:

      • Update
      • Insert
      • Delete


      Note: These items are all selected by default.
    12. Under the Changed Columns Filter column, select the columns for which you want to receive notification of changes.

      Notes:
      • If you do not select them, you will receive notification of all changes.
      • If you select only one, you will receive change information only if the field selected undergoes a change.
      • If you select more than one, but not all, then you will receive change information only if any or all of the selected fields undergo a change

    13. To filter content from within a given column, under the Content Filter column, double-click the relevant column, and then once again on the ellipsis button that appears.
      The Content Filter screen is displayed.
    14. Select a filter type:

      • Select In for events to be returned where the relevant column value equals the values you specify (if a column is NULL, it is not captured).
      • Select Not In for events to be returned where the column value is not in the values you specify (if the column is NULL, it is captured).
      • Select Between for when the column value is between the two values you specify (if a column is NULL, it is not captured).

    15. Click Add in the lower-left corner of the Content Filter screen.

      Note: If you select more than one condition, you will receive the change information as long as one of the conditions is true.
    16. Depending on your selection, do one of the following:

      • If you selected In/Not In, continue with step17.
      • If you selected Between, continue with step 20
      .
    17. Click Add in the Add items to the list screen.
      Add Items (In or Not In)
    18. Enter a value for events to be returned where the relevant column value appears (or does not appear) in that value. To filter empty values (’’) for the Not In filter type, leave this filed blank.
    19. Repeat steps 17 and 18 as many times as necessary, and then proceed to step 22.
    20. Click Add in the Add items to list screen.
      The Add between values screen is displayed.
    21. Enter values for events to be returned where the column value is between the two values you specify.
    22. In the Content Filter screen, click Next.
    23. Select the required level of auditing when receiving changes. Your options are:

      • None: For no changes.
      • Summary: For an audit that includes the total number of recorded delivered, as well as system and error messages.
      • Headers: For an audit that includes the total number of records delivered, system and error messages, and the record headers for each captured record.
      • Detailed: For an audit that includes the total number of records delivered, system and error messages, the record headers for each captured record, and the content of the records.

    24. Click Finish.

    When you complete all the Implementation operations, a check mark is displayed next to every link. Click Done to return to the Project Guide so you can begin the Deployment activities
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  2. #2
    tborrome is offline Junior Member
    Join Date
    Jun 2009
    Posts
    1
    Rep Power
    0

    Setting up the Stream Service (Implementation Guide)

    Hi, I'm trying to setup CDC for SQL Server and have gone through all the steps in the doc (installation, setting up SQL Server replication, etc)

    When setting up the Stream Service, I seem to be missing steps 9 to 22 that's mentioned in this doc. After I select the table (Changed Data Capture Table Selection screen), I go to a screen labeled as "Column Selection" but the options that appear are the level of auditing (None, Summary, Headers, Detailed). I dont see the options indicated in the doc for selecting tables and column filters with the update, insert delete check boxes, etc. All I get is the attached screenshot. Am I missing something?

  3. #3
    Boaz Newman is offline Support
    Join Date
    Aug 2006
    Posts
    30
    Rep Power
    0
    There seems to be a problem in the documentation.
    The Attunity CDC for SQL Server does not support filtering of events and of columns.The process that you described is the correct one, the problem is in the documentation.
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •