SOLICITATION NOTICE
99 -- Extract, Transform, Load (ETL) Tool
- Notice Date
- 10/19/2016
- Notice Type
- Presolicitation
- NAICS
- 511210
— Software Publishers
- Contracting Office
- Department of the Army, Army Contracting Command, ACC - NJ (W15QKN), BUILDING 10 PHIPPS RD, PICATINNY ARSENAL, New Jersey, 07806-5000, United States
- ZIP Code
- 07806-5000
- Solicitation Number
- W15QKN-17-Q-0004
- Point of Contact
- Evangelina C. Tillyros, Phone: 9737246545
- E-Mail Address
-
evangelina.c.tillyros.civ@mail.mil
(evangelina.c.tillyros.civ@mail.mil)
- Small Business Set-Aside
- N/A
- Description
- The U.S. Army Contracting Command - New Jersey (ACC-NJ) on behalf of Program Executive Office (PEO) Enterprise Information System (EIS) Product Lead Acquisition, Logistics, and Technology Enterprise Systems and Services (PL ALTESS) is conducting a Market Survey to identify potential sources for the supply and delivery of an Extract, Transform, Load (ETL) Tool. This ETL tool will support analytical databases hosted at PL ALTESS located at the Radford Army Ammunition Plant. These databases will be receiving data from over one-hundred sources ranging from ERP (Enterprise Resource Planning) to legacy systems that will be providing a multitude of records in different formats and structures. This environment requires a scalable ETL tool that can systematically and efficiently process this large volume of data on a regular basis. Respondents should provide information for an ETL Tool with the following capabilities: 1) Ability to pull data from over one-hundred sources, transform it into a standard format, and load it into ASA (FM&C)'s analytical databases at PL ALTESS. The size of the environment is between 50 and 100 terabytes. Tables involved in ETL operations and having data quality requirements can exceed over 100 million rows. Specifications of the server the software must run on are as follows: a. Environment: Developmental b. Server Manufacturer: HP Proliant DL 380 c. Quantity of Servers: 1 d. Type of Processors: Intel Xeon E5-2667v3 e. Quantity of Processors: 1 f. Quantity of Cores Per Processor: 8 g. Process Value Unit Score: 560 2) Key ETL Requirements include: a. Multi-Operation System, including Linux and Windows, support for server and client components b. Support for various source/destination types, including flat (character-delimited) files, XML and multi-DBMS (including Microsoft SQL and Oracle) c. Availability of native ERP connectors, including SAP and Oracle/PeopleSoft d. Massive scalability and parallelism to handle large files/tables/tens of Terabytes of data e. Cloud integration capability f. Support for Hadoop/big data integration with options to read/write data from/to Hadoop and run on a Hadoop cluster. g. Ability to operate in batch and real-time modes h. Support for multi-user development environment, minimum two (2) users i. Mapping source/destination using graphical user interface (GUI) designed for non-technical users j. GUI and reporting capability for data linage, including the ability to trace a transaction to the source k. Ability to capture and maintain business glossary l. Metadata repository, capture and query m. Native data quality/validation capabilities, including prebuilt functions. The immediate need is for basic data quality/validations (e.g., missing value) out of the box but have options for more complex rules (e.g., identifying duplicate records) via custom validations and/or additional modules. n. Native debugging and logging capabilities o. Exception reporting and handling p. Ability to add Check-points anywhere/ability to restart ETL jobs from point of failure q. Ability to backup and restore repository on regular basis (daily, weekly and monthly) r. Versioning support (ability keep track of changes between code versions and revert to earlier versions) s. Ability to import data models from modeling tools, including ErWin t. Ability to perform complex transformations and support for user defined transformations u. Scheduling and event-based execution v. Built-in workflow capability (ability to create discrete steps, dependencies/conditions and assign tasks to different individuals) w. Ability to monitor ETL process execution x. Encryption support (ability to work with encrypted data in source or target databases) y. Consumption-based licensing (annual/non-perpetual) z. Non-production licensing for Development/Test environments aa. On-premises solution (not cloud, licenses must be on-site) bb. End to end latency for processing ETL operations and data quality processing of up to a maximum of 24 hours 3) Technical Support: Potential Offerors must show evidence for their capability to offer technical support to the ETL. This should include diagnosis of system problem and continuous problem resolution by phone, email, or online assistance, providing both responsive and proactive support to allow for operational efficiency. Technical support would be required between the hours of 0730 to 1600 Monday through Friday. The North American Industry Classification (NAICS) Code for the effort is 511210, Software Publishers. The Government intends to fulfill this requirement through Full and Open Competition via a single award, Firm Fixed Price (FFP), purchase order to be awarded on a Lowest Price Technically Acceptable basis. Please note, THIS NOTICE DOES NOT CONSTITUE A REQUEST FOR QUOTE (RFQ). Responses to this announcement are not quotes/proposals and cannot be accepted by the Government to form a binding contract. This is not a guarantee of a future RFQ or an award. This notice should not be construed as a commitment of any kind by the U.S. Government. Any information provided to the Government in response to this notice will become ACC-NJ property and will not be returned. The Government will not reimburse contractors for any cost associated with responding to this announcement. It is anticipated that a solicitation will be issued on or about seven (7) calendar days from the date of this announcement on the Federal Business Opportunities (FedBizOpps) website; https://www.fbo.gov/. Quotes will be required within 15 calendar days from issuance of the solicitation. The Point of Contact for this action is Ms. Evangelina Tillyros, Contracting Officer, ACC-NJ-CC, Close Combat Center, Building 10, Phipps Rd. Picatinny Arsenal, NJ 07806-5000. evangelina.c.tillyros.civ@mail.mil. Telephone inquires will not be accepted.
- Web Link
-
FBO.gov Permalink
(https://www.fbo.gov/notices/ce9477722eeaba238586153e29e78817)
- Place of Performance
- Address: electronic delivery is required for this effort, United States
- Record
- SN04308355-W 20161021/161019234554-ce9477722eeaba238586153e29e78817 (fbodaily.com)
- Source
-
FedBizOpps Link to This Notice
(may not be valid after Archive Date)
| FSG Index | This Issue's Index | Today's FBO Daily Index Page |