Dakota County Logo
File #: DC-1771    Version: 1
Type: Consent Action Status: Passed
File created: 12/23/2022 In control: Board of Commissioners
On agenda: 1/3/2023 Final action: 1/3/2023
Enactment date: 1/3/2023 Resolution #: 23-018
Title: Authorization To Purchase SplashBI Database Software For Oracle Cloud Enterprise Resource Planning And Human Capital Management
Sponsors: Information Technology
DEPARTMENT: Information Technology
FILE TYPE: Consent Action

TITLE
title
Authorization To Purchase SplashBI Database Software For Oracle Cloud Enterprise Resource Planning And Human Capital Management
end

PURPOSE/ACTION REQUESTED
Authorize the Information Technology (IT) Chief Information Officer (CIO) to purchase SplashBI Enterprise Business Reporting and Analytics software.

SUMMARY
The County's implementation of a new Enterprise Resource Planning (ERP) solution, Oracle Cloud ERP and Human Capital Management (HCM), creates new data needs for reporting and interfaces. With the data residing in the Cloud, IT staff do not have access to retrieve data directly from the database tables that hold the data for the new ERP system. Data from the new ERP system is needed in the County Data Warehouse to meet business reporting requirements and for use in the many interfaces between other business systems and the ERP system for daily transaction processing. Furthermore, Finance, Budget, Employee Relations, and Payroll staff have significant reporting needs as we go live with the new system.

SplashBI offers software that will allow for the replication of Oracle Cloud ERP data that IT staff can access directly to meet business needs of County departments. In addition, they offer a robust set of pre-written reports that staff can leverage as is, or extend to meet their needs with no assistance from IT. The software also provides added data views over and above what is delivered with our new ERP solution allowing for more logical creation of reports against an otherwise massive, very complex database behind the new system.

By Resolution No. 21-499 (October 19, 2021), Dakota County IT purchased software from SplashBI Enterprise Business Reporting and Analytics in 2021 to allow IT development staff to transition interfaces from the current ERP solution, OneSolution, to the new ERP system which will go live in January of 2023. The software purchased included the capability t...

Click here for full text