Hi,
I am trying to connect to financial edge system using MuleSoft and wanted to check anyone has experience with this integration.
I have come across connectors such as OAuth and SQL Select, but i am not entirely sure about configuration and pipeline.
Anyone has done something similar could please share some guidance?
@Arbaz Bamboowala this can be done with MuleSoft, but do not start with SQL Select unless you are using a third-party JDBC/ODBC layer such as CData.
For Financial Edge NXT, the cleaner approach is to use Blackbaud SKY API through MuleSoft’s HTTP Request connector.
You should:
- Create a Blackbaud SKY Developer app
- Enable the required Financial Edge NXT scopes
- Configure OAuth 2.0 authorization
- Store the access/refresh token securely in MuleSoft
- Call the required Financial Edge NXT API endpoints
- Transform the response in DataWeave
- Push the data to Salesforce, database, SFTP, or another target system
Blackbaud’s Financial Edge NXT API documentation is here:
https://developer.blackbaud.com/skyapi/products/fenxt
SKY API authorization uses OAuth 2.0:
https://developer.blackbaud.com/skyapi/docs/authorization
For API calls, you normally need both:
Authorization: Bearer <access_token>
Bb-Api-Subscription-Key: <subscription_key>
Blackbaud documents the subscription key header here:
https://developer.blackbaud.com/skyapi/docs/basics
On the MuleSoft side, use the HTTP Request connector with OAuth 2.0/token handling:
https://docs.mulesoft.com/http-connector/latest/http-authentication
A simple implementation pattern is:
Scheduler or API trigger -> get/refresh token -> call Financial Edge NXT endpoint -> handle pagination/errors -> transform response -> send to target system -> log request/response status
If the requirement is only reporting/querying Financial Edge data, then a CData/JDBC-style connector can work, but that becomes a vendor-driver approach, not a native Blackbaud API pattern. For operational integrations, SKY API through MuleSoft HTTP connector is the better architecture.