Results 1 to 4 of 4

Thread: Attunity CDC - Capturing before Image

  1. #1
    SURYA.BHATTACHARYYA is offline Junior Member
    Join Date
    Jul 2011
    Location
    USA
    Posts
    6
    Rep Power
    0

    Default Attunity CDC - Capturing before Image

    We recently bought ORACLE CDC for SSIS. I have few questions regarding setup.

    1. In case of update, how to set up CDC to capture the before image too?
    2. Is there a way to find out only the changed columns? Example: A table has 10 columns, but only 2 of them went through updates. Is this info captured in anywhere?

    Thanks

    Surya

  2. #2
    JeffInFlorida's Avatar
    JeffInFlorida is offline US Technical Team
    Join Date
    Oct 2006
    Posts
    90
    Rep Power
    8

    Default Getting Before Image

    In order to have the CDC solution capture the before image follow these steps:

    1) From the management console click on the 'Open local log folder...' link.
    2) Move up one directory and run the Support.bat file.
    3) Type NAV_UTIL EXPORT MACHINE M.XML
    4) Type NOTEPAD M.XML and search for getBeforeImage and change the value to 'true', then save the file.
    5) Type NAV_UTIL IMPORT SYS M.XML
    6) From the Management Console, stop and start the solution.

    You will now get the before images in the staging area that SSIS is reading.

    You will have to come up with your own method to compare the BEFOREIMAGE and the UPDATE rows to determine what columns have changed.

    NOTE: The SSIS Change Destination component does not process these records and will report them as an error so you must filter those or use your own component to update the target data store.
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  3. #3
    Join Date
    Sep 2006
    Posts
    228
    Rep Power
    10

    Default

    Capturing the before-image is supported by the underlying technology but was not introduced as a supported use case and hence it is not available in the configuration wizard.

    As JeffInFlorida mentioned, when turning on the before-image capture, you must filter out the before-image rows as the SSIS Change Destination component does not know how to handle before-image records.

    Still, an important correction to the process suggested by JeffInFlorida is needed - the suggested process is ephemeral (short lived). The moment you re-run the wizard or re-apply the solution configuration, the change would be reversed. Another issue is that the 'getBeforeImage' attribute to be changed would not always exist in the exported file.

    The correct way to enable before-image capture (with the noted reservation) is as follows:

    1. Before starting, make sure that the solution is stopped, is not open in Visual Studio or in the management console.
    2. In the CDC project folder, locate the CDC\AIS\machines folder
    3. Under that folder there may be one or more 'machine' folders (depending on the source database type) and under one of them there is a bindings\CDC_SERVICE folder
    4. Edit the binding.bnd file (an XML document) in the CDC_SERVICE folder (e.g. with Notepad).
    5. Locate a <config> element within an <adapter> element.
    6. Add to the config element the attribute getBeforeImage='true' (or change its value to 'true' if it is already there but 'false')
    7. Save the binding file
    8. Open the management console for the Attunity {some database} CDC for SSIS, locate the relevant solution and switch to the General tab of the CDC Configuration pane. There press Apply Configuration and the solution will be permanently switched to the new mode.

    /d
    By Dror Harari

    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

  4. #4
    SURYA.BHATTACHARYYA is offline Junior Member
    Join Date
    Jul 2011
    Location
    USA
    Posts
    6
    Rep Power
    0

    Default

    Thanks to both of you. Both works and as was mentioned, the first setting was short lived when the configuration wizard was run again.

    I will take care of these before image records.

    Thanks
    Surya Bhattacharyya

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257