DEPARTMENT: Information Technology
FILE TYPE: Consent Action
TITLE
title
Authorization To Execute Contract With SplashBI For Database Replication
end
PURPOSE/ACTION REQUESTED
Authorize the Deputy County Manager to execute a contract with SplashBI Enterprise Business Reporting and Analytics software for an additional three-year term.
SUMMARY
To allow for efficient integrations and long-term data warehouse capabilities, the Information Technology (IT) department contracts with SplashBI to replicate the database behind the County’s Enterprise Resource Planning (ERP) solution, Oracle Cloud ERP and Human Capital Management (HCM). This contract also includes access to a reporting tool with pre-built reports with access to the County’s ERP data. The current contract for these services expires on January 10, 2025. Without the replicated database that the SplashBI Data Pipeline software provides, twenty-two integrations needed for day-to-day transactional processing would need to be re-architected using Oracle provided Application Programming Interfaces (API’s) since they do not allow direct access to the database behind our ERP system. Furthermore, processes to pull data for reporting would not be possible due to performance limitations. Several Finance and Human Resources staff leverage the reporting tool and pre-built reports for their business purposes. County IT is recommending a new three-year contract with Splash BI for their Data Pipeline and Reporting solution to benefit from a set price SplashBI is offering, avoiding annual price increases.
SplashBI has provided County IT with a renewal quote for three years at a rate of $71,754.20 per year starting on January 10, 2025, going through January 9, 2028, for a total contract amount of $215,262.60.
RECOMMENDATION
recommendation
Staff recommends that the Board authorize the Deputy County Manager to execute a contract with SplashBI for three years at a rate of $71,754.20 per year for a total of $215,262.60.
end
EXPLANATION OF FISCAL/FTE IMPACTS
Sufficient funding is available in the Information Technology budget.
☐ None ☒ Current budget ☐ Other
☐ Amendment Requested ☐ New FTE(s) requested
RESOLUTION
body
WHEREAS, County IT has contracted with SplashBI for database replication and reporting supporting the County’s cloud-based Enterprise Resource Planning (ERP) and Human Capital Management (HCM) system, Oracle Cloud ERP/HCM; and
WHEREAS, the contract with SplashBI expires on January 10, 2025; and
WHEREAS, several integrations supporting day-to-day transactions rely on the database replica this software produces; and
WHEREAS, Finance and Human Resources staff use the reporting tool and pre-built reports included with this software; and
WHEREAS, County IT recommends executing a contract with SplashBI for three years to avoid annual price increases.
NOW, THEREFORE, BE IT RESOLVED, That the Dakota County Board of Commissioners hereby authorizes the Deputy County Manager to execute a contract with Splash BI Enterprise Data Pipeline and Business Reporting and Analytics software for three years at a rate of $71,754.20 per year for a total of $215,262.60, subject to approval by the County Attorney’s Office as to form.
end
PREVIOUS BOARD ACTION
23-018; 1/3/23
ATTACHMENTS
Attachment: None.
BOARD GOALS
☐ A Great Place to Live ☐ A Healthy Environment
☐ A Successful Place for Business and Jobs ☒ Excellence in Public Service
CONTACT
Department Head: Dan Cater
Author: Scott Jara