SSIS Components for Blackbaud Raisers Edge NXT

Build 21.0.7930

Using the Destination Component

After Establishing a Connection to the data source, add the CData BlackBaud Raiser's Edge NXT destination component to the workflow to load data into BlackBaud Raiser's Edge NXT.

Writing to BlackBaud Raiser's Edge NXT in a Data Flow

Follow the steps below to connect to BlackBaud Raiser's Edge NXT and update data.

  1. In the SSIS Toolbox, drag the CData BlackBaud Raiser's Edge NXT destination component into the Data Flow Task.
  2. Connect the output of a source component to the CData BlackBaud Raiser's Edge NXT destination component.
  3. Double-click the CData BlackBaud Raiser's Edge NXT destination component. The CData BlackBaud Raiser's Edge NXT Destination Editor dialog will display.
  4. In the Connection Managers menu, select an available CData BlackBaud Raiser's Edge NXT connection manager, or create a new instance if one is not already available.
  5. In the "Use a Table" option, select the table to update.
  6. Select the data manipulation action. See below for more information on each action.
  7. On the Mappings tab, configure the mappings from source to destination. By default, outputs from the source component will automatically be mapped with the same name as the columns in the table you selected. You can further update these selections.

Note: Read-only columns will not be visible among the destination columns since they cannot be written to.

Command Execution

When you execute the data flow, the component will execute one of the following operations to update the destination table.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930