Their membership system had no way in. We built one.
The National Hydropower Association keeps its member records in a system that accepts no data from other software. Staff were typing event registrations into it by hand. We built one connector that links it to their event registration and newsletter tools, and does that entry for them.
At a glance
- Client
- National Hydropower Association
- Industry
- Trade association
- Engagement
- Custom integration, since 2022
- Systems
- Membership system, Cadmium, Rasa
The outcome
3
systems connected, one of which has no way to accept data from outside
4
separate syncs running, added one at a time since 2022
4x a day
new event registrations are picked up and entered
Every list was moved by hand.
NHA runs on three systems from three vendors: a membership system that holds every member and contact, Cadmium for event registration, and Rasa for its newsletter. The membership system is the master record, and it has no bulk upload.
Each Monday someone downloaded about 20 reports, merged them into one spreadsheet and uploaded it to the newsletter tool. When people registered for an event, staff downloaded the list and typed each person into the membership system. The vendor's own upload service was the only alternative, and it took three to seven business days.
It almost takes more time to prepare the list to upload than it does to just manually enter them.
One connector that works the screens like a person would.
Cadmium and Rasa both have an API, which is a supported way for software to exchange data, so the connector talks to them directly. The membership system has none. For that one, the connector signs in and uses the same screens a staff member would: it reads the reports, looks up each organization and contact, creates the ones that are missing, and registers them for the event. Data moves both ways, out of the membership system to the newsletter and into it from event registration.
NHA staff run it from their own admin screen, where they choose which reports feed the newsletter and upload any attendee spreadsheet to be registered.
Members to the newsletter
Every night, the current contact list goes from the membership system to Rasa. Live since 2022.
Registrations into membership
Event registrations from Cadmium. In use since 2025.
Unsubscribes kept in step
Contacts who become inactive are removed from the newsletter list. Added in 2026.
Exhibitors to their committee
Exhibitors from the expo system are added to the right committee. Added in 2026.
The sync has totally changed our workflow in an amazing way.
Staff check the exceptions, not every record.
The first newsletter sync loaded about 7,000 contacts. When the connector cannot match a person or an organization with confidence, it puts the record on a list for staff instead of forcing a match, so their time goes to the handful that need a decision.
Because the connector can register people from any spreadsheet, NHA also uses it for events that never touch the registration system. Each sync was added when the team found the next piece of manual entry worth removing.
Staff re-typing data because one system will not accept it?
Tell us which systems are involved, and we will tell you what connecting them would take.
A free 15-minute call. Prefer to write? Send a message.