Case Study: City of Lodi achieves secure, efficient, and cost-effective data integration with Astera Software's Centerprise Data Integrator

City of Lodi - Customer Case Study

The City of Lodi — the “Winegrape Capital of the World” — needed a secure, centralized way to integrate and share financial and planning data from disparate systems (IBM DB2, Oracle, MySQL, SQL Server and Access) with internal staff and the public. Manual scripting and an intermediate Access database had become cumbersome and risky, so the IS team sought an affordable, easy-to-use ETL solution that could automate transfers, support multiple database platforms, and be managed by multiple team members.

Lodi selected Astera’s Centerprise Data Integrator for its enterprise functionality, ease of use, and cost-effectiveness. Centerprise enabled automated, scheduled data transfers and safe exports to secondary systems used for web publishing, letting residents look up business licenses and utility accounts without exposing core systems. The city now performs transfers in minutes instead of days, has centralized data management, and continues to expand use of the platform while benefiting from responsive vendor support.

City of Lodi

Steve Mann

IS Manager