Blackbaud Raiser's Edge NXT connector for Amazon AppFlow - Amazon AppFlow

Blackbaud Raiser's Edge NXT connector for Amazon AppFlow

Blackbaud Raiser's Edge NXT is a customer relationship management (CRM) software as a service (SaaS) solution for nonprofit organizations. If you’re a Blackbaud Raiser's Edge NXT user, your account contains data on prospects, analytics, gift management, and more. You can use Amazon AppFlow to transfer data from Blackbaud Raiser's Edge NXT to certain AWS services or other supported applications.

Amazon AppFlow support for Blackbaud Raiser's Edge NXT

Amazon AppFlow supports Blackbaud Raiser's Edge NXT as follows.

Supported as a data source?

Yes. You can use Amazon AppFlow to transfer data from Blackbaud Raiser's Edge NXT.

Supported as a data destination?

No. You can't use Amazon AppFlow to transfer data to Blackbaud Raiser's Edge NXT.

Before you begin

To use Amazon AppFlow to transfer data from Blackbaud Raiser's Edge NXT to supported destinations, you must meet these requirements:

  • You have an account with Blackbaud Raiser's Edge NXT that contains the data that you want to transfer. For more information about the Blackbaud Raiser's Edge NXT data objects that Amazon AppFlow supports, see Supported objects.

  • In your Blackbaud SKY Developer account, you've created a SKY developer app for Amazon AppFlow. The app provides the client credentials that Amazon AppFlow uses to access your data securely when it makes authenticated calls to your account. You can use default settings for the Grant type, the authorization tokens URL, and the authorization code URL, or use your own. For information about how to create a developer app, see Applications in the SKY API documentation.

  • In the setting for Scopes, you've defined access to Blackbaud data with the option Full data access.

  • You've configured the app with one or more redirect URLs for Amazon AppFlow.

    Redirect URLs have the following format:

    https://region.console.aws.amazon.com/appflow/oauth

    In this URL, region is the code for the AWS Region where you use Amazon AppFlow to transfer data from Blackbaud Raiser's Edge NXT. For example, the code for the US East (N. Virginia) Region is us-east-1. For that Region, the URL is the following:

    https://us-east-1.console.aws.amazon.com/appflow/oauth

    For the AWS Regions that Amazon AppFlow supports, and their codes, see Amazon AppFlow endpoints and quotas in the AWS General Reference.

Note the client ID, client secret, and subscription key from the settings for your app. You provide these values to Amazon AppFlow when you create your connection.

Connecting Amazon AppFlow to your Blackbaud Raiser's Edge NXT account

To connect Amazon AppFlow to your Blackbaud Raiser's Edge NXT account, provide details from your SKY developer app so that Amazon AppFlow can access your data. If you haven't yet configured your Blackbaud Raiser's Edge NXT account for Amazon AppFlow integration, see Before you begin.

To connect to Blackbaud Raiser's Edge NXT
  1. Sign in to the AWS Management Console and open the Amazon AppFlow console at https://console.aws.amazon.com/appflow/.

  2. In the navigation pane on the left, choose Connections.

  3. On the Manage connections page, for Connectors, choose Blackbaud Raiser's Edge NXT.

  4. Choose Create connection.

  5. In the Connect to Blackbaud Raiser's Edge NXT window, enter the following information:

    • Connection name — Enter a name for your connection.

    • Client ID — The client ID in your Blackbaud Raiser's Edge NXT project.

    • Client secret — The client secret in your Blackbaud Raiser's Edge NXT project.

    • Subscription key — The subscription key in your Blackbaud Raiser's Edge NXT project.

  6. Optionally, under Data encryption, choose Customize encryption settings (advanced) if you want to encrypt your data with a customer managed key in the AWS Key Management Service (AWS KMS).

    By default, Amazon AppFlow encrypts your data with a KMS key that AWS creates, uses, and manages for you. Choose this option if you want to encrypt your data with your own KMS key instead.

    Amazon AppFlow always encrypts your data during transit and at rest. For more information, see Data protection in Amazon AppFlow.

    If you want to use a KMS key from the current AWS account, select this key under Choose an AWS KMS key. If you want to use a KMS key from a different AWS account, enter the Amazon Resource Name (ARN) for that key.

  7. Choose Connect.

  8. In the window that appears, sign in to your Blackbaud Raiser's Edge NXT account, and grant access to Amazon AppFlow.

On the Manage connections page, your new connection appears in the Connections table. When you create a flow that uses Blackbaud Raiser's Edge NXT as the data source, you can select this connection.

Transferring data from Blackbaud Raiser's Edge NXT with a flow

To transfer data from Blackbaud Raiser's Edge NXT, create an Amazon AppFlow flow, and choose Blackbaud Raiser's Edge NXT as the data source. For the steps to create a flow, see Creating flows in Amazon AppFlow.

When you configure the flow, choose the data object that you want to transfer. For the objects that Amazon AppFlow supports for Blackbaud Raiser's Edge NXT, see Supported objects.

Also, choose the destination where you want to transfer the data object that you selected. For more information about how to configure your destination, see Supported destinations.

Supported destinations

When you create a flow that uses Blackbaud Raiser's Edge NXT as the data source, you can set the destination to any of the following connectors:

Supported objects

When you create a flow that uses Blackbaud Raiser's Edge NXT as the data source, you can transfer any of the following data objects to supported destinations:

Object

Field

Data type

Supported filters

Action

Category

String

Completed

Boolean

Completed Date

DateTime

Computed Status

String

EQUAL_TO

Constituent ID

String

Date

DateTime

Date Added

DateTime

EQUAL_TO

Date Modified

DateTime

Description

String

End Time

String

Fundraisers

List

ID

String

Last Modified

DateTime

EQUAL_TO

List ID

String

EQUAL_TO

Location

String

Opportunity ID

String

Outcome

String

Priority

String

Start Time

String

Status

String

Status Code

String

EQUAL_TO

Summary

String

Type

String

Address

Address Lines

String

City

String

Constituent ID

String

EQUAL_TO

Country

String

County

String

Date Added

DateTime

EQUAL_TO

Date Modified

DateTime

Do Not Mail

Boolean

End

DateTime

Formatted Address

String

ID

String

Inactive

Boolean

Include Inactive

Boolean

EQUAL_TO

Last Modified

DateTime

EQUAL_TO

Postal Code

String

Preferred

Boolean

Seasonal End

Struct

Seasonal Start

Struct

Start

DateTime

State

String

Type

String

Appeal

Category

String

Date Added

DateTime

EQUAL_TO

Date Modified

DateTime

Description

String

End Date

DateTime

Goal

Struct

ID

String

Inactive

Boolean

Include Inactive

Boolean

EQUAL_TO

Last Modified

DateTime

EQUAL_TO

Lookup ID

String

Start Date

DateTime

Campaign

Category

String

Date Added

DateTime

EQUAL_TO

Date Modified

DateTime

Description

String

End Date

DateTime

Goal

Struct

ID

String

Inactive

Boolean

Include Inactive

Boolean

EQUAL_TO

Last Modified

DateTime

EQUAL_TO

Lookup ID

String

Start Date

DateTime

Constituent

Address

Struct

Age

Integer

Birthdate

Struct

Constituent Code

String

EQUAL_TO

Constituent ID

String

EQUAL_TO

Custom Field Category

String

EQUAL_TO

Date Added

DateTime

EQUAL_TO

Date Modified

DateTime

Deceased

Boolean

Email

Struct

First

String

Former Name

String

Fundraiser Status

String

EQUAL_TO

Gender

String

Gives Anonymously

Boolean

ID

String

Inactive

Boolean

Include Deceased

Boolean

EQUAL_TO

Include Inactive

Boolean

EQUAL_TO

Last

String

Last Modified

DateTime

EQUAL_TO

List ID

String

EQUAL_TO

Lookup ID

String

Marital Status

String

Middle

String

Name

String

Online Presence

Struct

Phone

Struct

Postal Code

String

EQUAL_TO

Preferred Name

String

Spouse

Struct

Suffix

String

Suffix 2

String

Title

String

Title 2

String

Type

String

Custom Field

Category

String

EQUAL_TO

Comment

String

Date

DateTime

Date Added

DateTime

EQUAL_TO

Date Modified

DateTime

Gift ID

Integer

EQUAL_TO

ID

String

Last Modified

DateTime

EQUAL_TO

Parent ID

String

Type

String

Value

String

EQUAL_TO

Education

Campus

String

Class Of Degree

String

Constituent ID

String

Date Added

DateTime

EQUAL_TO

Date Entered

Struct

Date Graduated

Struct

Date Left

Struct

Date Modified

DateTime

Degree

String

Faculty

String

GPA

Double

ID

String

Known Name

String

Last Modified

DateTime

EQUAL_TO

Majors

List

Minors

List

Primary

Boolean

Registration Number

String

School

String

Social Organization

String

Status

String

String

String

Subject Of Study

String

Type

String

class Of

String

Email Address

Address

String

Constituent ID

String

EQUAL_TO

Date Added

DateTime

EQUAL_TO

Date Modified

DateTime

Do Not Email

Boolean

ID

String

Inactive

Boolean

Include Inactive

Boolean

EQUAL_TO

Last Modified

DateTime

EQUAL_TO

Primary

Boolean

Type

String

Event

Attended Count

Integer

Attending Count

Integer

Capacity

Integer

Category

Struct

Date Added

DateTime

EQUAL_TO

Date Modified

DateTime

End Date

Date

End Time

String

Event Category

String

EQUAL_TO

Event ID

String

EQUAL_TO

Goal

Double

ID

String

Inactive

Boolean

Include Inactive

Boolean

EQUAL_TO

Invited Count

Integer

Last Modified

DateTime

EQUAL_TO

Lookup ID

String

EQUAL_TO

Name

String

EQUAL_TO

Percent Of Goal

Integer

Revenue

Double

Start Date

Date

Start Date From

Date

EQUAL_TO

Start Date To

DateTime

EQUAL_TO

Start Time

String

Event Participant

Attended

Boolean

Attended Filter

Boolean

EQUAL_TO

Class Of

String

Contact ID

String

Date Added

DateTime

EQUAL_TO

Date Modified

DateTime

Do Not Call

Boolean

Do Not Email

Boolean

Donations

Double

Email

String

Email Eligible Filter

Boolean

EQUAL_TO

Fees Paid Filter

Boolean

EQUAL_TO

First Name

String

Former Name

String

Guests

Struct

Host

Struct

ID

String

Invitation Status

String

EQUAL_TO

Is Constituent

Boolean

Is Constituent Filter

Boolean

EQUAL_TO

Last Modified

DateTime

EQUAL_TO

Last Name

String

Lookup ID

String

Memberships

Struct

Middle Name

String

Name

String

EQUAL_TO

Name Tag

String

Online Data Health

String

EQUAL_TO

Participant Option ID

String

EQUAL_TO

Participant Options

Struct

Participation Level

String

EQUAL_TO

Participation Level

Struct

Phone

String

Phone Call Eligible Filter

Boolean

EQUAL_TO

Preferred Name

String

RSVP Date

Struct

RSVP Status

String

EQUAL_TO

Registration Form

Struct

Registration Form IDs

String

EQUAL_TO

Registration Form Include Type

String

EQUAL_TO

Revenue

Double

Seat

String

Suffix

String

Summary Note

String

Title

String

Total Paid

Double

Total Registration Fees

Double

Fund

Category

String

Date Added

DateTime

EQUAL_TO

Date Modified

DateTime

Description

String

End Date

DateTime

Fund ID

Integer

EQUAL_TO

Goal

Struct

ID

String

Inactive

Boolean

Include Inactive

Boolean

EQUAL_TO

Last Modified

DateTime

EQUAL_TO

Lookup ID

String

Start Date

DateTime

Type

String

Fundraiser Assignment

Amount

Struct

Appeal ID

String

Campaign ID

String

Constituent ID

String

EQUAL_TO

End

DateTime

Fund ID

String

Fundraiser ID

String

ID

String

Include Inactive

Boolean

EQUAL_TO

Start

DateTime

Type

String

Gift

Acknowledgement Status

String

EQUAL_TO

Acknowledgements

List

Amount

Struct

Appeal ID

String

EQUAL_TO

Balance

Struct

Batch Number

String

Campaign ID

String

EQUAL_TO

Constituency

String

Constituent ID

String

EQUAL_TO

Date

DateTime

Date Added

DateTime

EQUAL_TO

Date Modified

DateTime

End Gift Amount

Double

EQUAL_TO

End Gift Date

DateTime

EQUAL_TO

Fund ID

String

EQUAL_TO

Fundraisers

List

Gift Splits

List

Gift Status

String

Gift Type

String

EQUAL_TO

ID

String

Is Anonymous

Boolean

Last Modified

DateTime

EQUAL_TO

Linked Gifts

List

List ID

String

EQUAL_TO

Lookup ID

String

Origin

String

Payments

List

Post Date

DateTime

Post Status

String

EQUAL_TO

Receipt Status

String

EQUAL_TO

Receipts

List

Reference

String

Soft Credits

List

Start Gift Amount

Double

EQUAL_TO

Start Gift Date

DateTime

EQUAL_TO

Subtype

String

Type

String

Gift Batch

Actual Amount

Double

Added By

String

Approved

Boolean

EQUAL_TO

Batch Description

String

Batch Number

String

EQUAL_TO

Created By

String

Created On

DateTime

Date Added

DateTime

Has Exceptions

Boolean

EQUAL_TO

ID

String

Is Approved

Boolean

Number Of Gifts

Integer

Search Text

String

EQUAL_TO

Membership

Category

String

Constituent ID

String

Date Added

DateTime

EQUAL_TO

Date Modified

DateTime

Dues

Struct

Expires

DateTime

ID

String

Joined

DateTime

Last Modified

DateTime

EQUAL_TO

Members

List

Program

String

Standing

String

Subcategory

String

Note

Constituent ID

String

Date

Struct

Date Added

DateTime

EQUAL_TO

Date Modified

DateTime

ID

String

Last Modified

DateTime

EQUAL_TO

Summary

String

Text

String

Type

String

Online Presence

Address

String

Constituent ID

String

EQUAL_TO

Date Added

DateTime

EQUAL_TO

Date Modified

DateTime

ID

String

Inactive

Boolean

Include Inactive

Boolean

EQUAL_TO

Last Modified

DateTime

EQUAL_TO

Primary

Boolean

Type

String

Opportunity

Ask Amount

Struct

Ask Date

DateTime

Campaign ID

String

Constituent ID

String

EQUAL_TO

Date Added

DateTime

EQUAL_TO

Date Modified

DateTime

Deadline

DateTime

Expected Amount

Struct

Expected Date

DateTime

Fund ID

String

Funded Amount

Struct

Funded Date

DateTime

Fundraisers

List

ID

String

Inactive

Boolean

Include Inactive

Boolean

EQUAL_TO

Last Modified

DateTime

EQUAL_TO

Linked Gifts

List

List ID

String

EQUAL_TO

Name

String

Purpose

String

Status

String

Package

Appeal ID

String

EQUAL_TO

Category

String

Date Added

DateTime

EQUAL_TO

Date Modified

DateTime

Default Gift Aamount

Struct

Description

String

End

DateTime

Goal

Struct

ID

String

Inactive

Boolean

Include Inactive

Boolean

EQUAL_TO

Last Modified

DateTime

EQUAL_TO

Lookup ID

String

Notes

String

Recipient Count

Integer

Start

DateTime

Phone

Constituent ID

String

EQUAL_TO

Date Added

DateTime

Date Modified

DateTime

Do Not Call

Boolean

ID

String

Inactive

Boolean

Number

String

Primary

Boolean

Type

String

Relationship

Comment

String

Constituent ID

String

Date Added

DateTime

EQUAL_TO

Date Modified

DateTime

End

Struct

ID

String

Is Constituent Head Of Household

Boolean

Is Organization Contact

Boolean

Is Primary Business

Boolean

Is Spouse

Boolean

Is Spouse Head Of Household

Boolean

Last Modified

DateTime

EQUAL_TO

Name

String

Organization Contact Type

String

Position

String

Reciprocal Relationship ID

String

Reciprocal Type

String

Relation ID

String

Start

Struct

Type

String