Astera Solution and Results
Mann and his team selected Astera’s Centerprise Data Integrator because it fit Lodi’s requirements, allowing them to simply transfer data from one table to another with whatever database server they needed to connect to.
“While this is our first experience with an ETL tool, we were very thorough with our evaluations. Centerprise suits our needs perfectly. It has all the functionality we need, it is easy to use, keeps the data together so it can be centrally managed, and it is the most cost effective,” said Mann. “It is very important to get the functionality we need, and not pay for what we don’t need.”
The team also takes advantage of Centerprise’s built-in scheduler to automate transfer jobs, eliminating the need for the old manual process involving Access. “We are able to write transfer, save, and schedule it to launch whenever. We use the scheduling functionality a lot. We depend on Centerprise. We use it extensively and it has allowed us to share information internally and externally quickly and securely,” said Mann.
The city has been able to share information and connect with its customers more rapidly thanks to its ability to rapidly and securely share information with Centerprise. For example, Centerprise is used to create files from the databases that become source files for web pages, for both internal and external customers. This means that the public can look up business license information, as well as the city’s public utility accounts, and have their results delivered online.
Because the data on the database is housed internally, for obvious security reasons, sharing this data electronically previously would have been too risky as well as burdensome. With Centerprise, the data is easily exported automatically into another database platform from the core systems, and the data can then become source files, giving the public the information they want and need without exposing the core systems to security threats.
“Centerprise allows my team to better share information internally and provides the ability to make the call as to what information and services they can offer to the public, easily, rapidly, and securely,” said Mann.
And “rapidly” has been key. Centerprise gives the team the ability to write a transfer, save it, and schedule it to launch when it wants using the scheduling functionality.
“Centerprise meets our needs for rapid deployment. Now, we can have transfers done in a matter of minutes that would have previously taken us a day, or days.” Mann and his team have been so pleased with Centerprise and its functionality that they recently upgraded. “We saw the additional features and functionality and definitely envision using them as we progress. And because we use it so extensively, we want to ensure we stay current with the software,” said Mann.