Blackbaud to Azure SQL database 1.0.0

Elevate your data integration to new heights with this COZYROC gem which effortlessly transfers Blackbaud objects with your desired SQL Server tables for seamless data management and analysis.

This gem will require you to connect and expose your Azure SQL Database to the COZYROC Cloud for seamless data integration and management. To find out how to expose your Azure SQL database to COZYROC Cloud, please refer to KB Article Expose Azure SQL Database to COZYROC Cloud

Setup Guide

This gem will establish a connection between Blackbaud and the desired Azure SQL database instance. Once the connection is established, the gem will then pull the data from each Blackbaud object specified in the Mapping parameter and send each object data to its allocated table in the Azure SQL database.

When specifying values for the Mapping parameter, please follow the format: ObjectName:"Schema"."TableName". Here the ObjectName and Schema.TableName are separated by colon (:).

Note Check the list at the end of this page for available objects that can be used for Mapping parameter.

For example: Church | Action:"dbo"."tbl_churchAction"

Ensure that you provide the available object name for Blackbaud, and enclose the schema and table names in double quotes.

Note: This gem will assume that the destination tables are already created.

To run this gem and connect Blackbaud to the Azure SQL database instance, you need to configure the parameters that are mentioned below.

Blackbaud

• Token File Required. Select the Rest Token file from the drop-down list. Review the KB-Article mentioned here on how to generate the token file.
• Batch Size Required. The default is set to 200.
• Query Parameter Optional. A new line separates multiple query parameters.

Azure SQL Database

• Server Name Required. Specify the server name.
• Database Required. Specify the database name.
• Username Required. Specify the username.
• Password Required. Specify the password.

Mapping

• Mapping Required. This parameter accepts comma-separated values if you want to pull data from multiple Blackbaud objects and send each object data to its allocated table in the Azure SQL database, e.g. Church | Address:"dbo"."tbl_churchAddress" etc.

Available Blackbaud Objects: Financial | Interfund Set Financial | Media Type Financial | Product Financial | Credit Memo Financial | Invoice Financial | Purchase Order Financial | Receipt Financial | Transaction Code Financial | Vendor Church | Action Church | Address Church | Constituent Church | Constituent Code Church | Education Church | Email Address Church | Note Church | Online Presence Church | Phone Church | Relationship Church | Package Financial | Account Financial | Account Code Financial | Account Fund Financial | Budget Financial | Budget Scenario Financial | Cash management distribution set Financial | Grant Financial | Journal Entry Batch Financial | Period Summary Financial | Project Financial | Transaction Distribution Financial | Transaction Distribution Set Church | Gift Church | Opportunity School | Attendance School | Building School | Candidate School | Course School | Department School | Dorm School | User School | Master Schedule School | Schedule School | Schedule Set School | Section School | Special Day School | Sport School | Sports Level School | Team School | Term School | User Audit School | Meeting Financial | Unit Financial | Bank Account Event | Category Event Event | Participation Level NXT | Appeal NXT | Campaign NXT | Code Table NXT | Constituent NXT | Country NXT | Fund NXT | Phone Type