Government Contract | California
California Recreational Fisheries Survey Data Warehouse Enhancement

Bid Information

Bid Alert No: 00002454555

Bid Title: California Recreational Fisheries Survey Data Warehouse Enhancement

Agency Bid No. Title: CMAS-DTD-IT2020-008

Received Date: 01/01/2021

Close Date: 01/18/2021

Purchase Type: Term: 03/01/2021 - 06/30/2021 - Option to Renew

Estimated Amount: $84,000

Delivery Point: Not Stated, California

Delivery Date: Not Stated

Special Notices: Questions Due By 01/08/2021 03:00 PM, Bidder Preregistration


Specifications include, but are not limited to: Data WarehouseDesign and Development:The CRFS Data Warehouse is based on,but separate from,production CRFSData. It is organized for speed of reporting and updated on a regular basis as new information flows into the production system.This system may be enhanced through modeling of production datato design and deploy additional data warehouse tables.Database: The content of the CRFS Data Warehouseis driven by a database that contains information from production CRFSdata. This structure may be enhanced and extended to include new production dataafter the Design and Development phase. This may include but is not limited to T-SQL standalone scripts, Stored Database Procedures and Stored Database Functions.Microsoft SQL Server Integration Services (SSIS):The CRFSData Warehouse may be enhanced to provide intermittent SSIS Jobs which update or enhance CRFS Data Warehouse content.Analysis Services Tabular Model:The Microsoft SQL Server Analysis Services Tabular model maybe enhanced to provide added value when accessing the underlying Data Warehouse Database tables.Extract, Transform, and Load Non-Production Data: CDFW has a long history of collecting data, and much of that data is not currently in production. The CRFSData Warehouse may be enhanced through the processing, modeling, and loading of historical data.

Bid Related Documents

Download Document

Product Codes: 91871, 90921

Agency Information

Issuing Agency: State of California - Department of Fish and Wildlife

State: California

Agency Type: State and Local

Contact: Nichole Gutierrez

Phone: 916-323-1438




FREE Market Analysis

Get a FREE 90-Day Market Analysis and see the bids you’ve been missing