Legislation Details

File #: DC-3383    Version: 1
Type: Consent Action Status: Passed
File created: 4/25/2024 In control: Board of Commissioners
On agenda: 5/21/2024 Final action: 5/21/2024
Enactment date: 5/21/2024 Resolution #: 24-264
Title: Authorization To Amend Contract With SplashBI For Database Replication
Sponsors: Information Technology

DEPARTMENT: Information Technology

FILE TYPE: Consent Action

 

TITLE

title

Authorization To Amend Contract With SplashBI For Database Replication

end

 

PURPOSE/ACTION REQUESTED

Authorize the Enterprise Finance and Information Services Director to amend the existing contract with SplashBI Enterprise Business Reporting and Analytics software to account for a change in architecture.

 

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). Upon renewal of this contract in 2023, the IT department worked with the vendor to move the replication database from the cloud to the Dakota County data center, which will save the County money and allow for more efficient integrations and reporting going forward. The savings will come with reduced cloud hosting costs for the replicated database. During the implementation, a technical requirement was identified leading to a decision to keep a part of the new solution in the cloud verses the data center. This change moves the server where the controlling software is hosted and adds full support for that server from SplashBI, increasing the current contracted amount by $20,000 from $99,310 to $119,310. 

 

RECOMMENDATION

recommendation

Staff recommends that the Board authorize the Enterprise Finance and Information Services Director to amend the contract with SplashBI to account for a change to the original solution, increasing the contract amount by $20,000 from $99,310 to $119,310.

end

 

EXPLANATION OF FISCAL/FTE IMPACTS

The cost of the proposed amendment is $20,000. Sufficient funding has been authorized in the 2024 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, upon contract renewal with SplashBI, County IT is moving the replicated database from the cloud to the Dakota County data center; and

 

WHEREAS, County IT requested a change to the on-premise database solution due to a technical requirement found during implementation keeping one server hosted in the cloud under continued support by SplashBI; and

 

WHEREAS, the hosting services and support will cost an additional $20,000 to the current one-year agreement.

 

NOW, THEREFORE, BE IT RESOLVED, That the Dakota County Board of Commissioners hereby authorizes the Enterprise Finance and Information Services Director to amend the contract with Splash BI Enterprise Business Reporting & Analytics software to revise the architecture of the database replication, in the amount of $20,000, subject to approval by the County Attorney’s Office as to form.

end

 

PREVIOUS BOARD ACTION

23-018; 1/3/2023

 

ATTACHMENTS

Attachment: None

 

BOARD GOALS

   ☐ A Great Place to Live                                          ☐ A Healthy Environment     

   ☐ A Successful Place for Business and Jobs         ☒ Excellence in Public Service

 

PUBLIC ENGAGEMENT LEVEL

  ☐ Inform and Listen                ☐ Discuss                               ☐ Involve                               ☒ N/A

 

CONTACT

Department Head: Dan Cater

Author: Scott Jara