This new process not only satisfies the auditors, but it also suits the data warehouse team as well.
Because Brian built the Celigo integrations so that they connect to specific saved searches, the EDW team can pull the necessary data using unique columns, headings, etc., for each request, ensuring they receive the information the way they need it and in a format that they can use without having to spend time manipulating it. Brian has also found that if the EDW team needs any changes to the integration, he can quickly and easily make updates himself. “The data warehouse team is so happy with the turnaround time for changes to the integration,” said Brian, “What used to take six months, I can now do myself in a day or two. It’s so easy to use.” When he first started the project, Brian spoke with a Celigo technical rep a couple of times, but after that, he has been able to figure out how to build, maintain and update the integrations on his own.
Brian enjoys several other Celigo benefits as well. “Celigo is very stable,” said Brian. “We run these extracts and data transfers consistently – nearly every day, and we haven’t had any problems at all. I’m so pleased with Celigo and integrator.io.”
Brian also likes that he can manage the Celigo integrations using his cell phone. “I can manage the Celigo integration from almost anywhere,” said Brian. “If there’s a failure in an extract, I can just log on to Celigo with my cell phone and kick that integration off. And, once the issue is resolved, I can restart it from my phone. This is a big benefit for us.”