BIML Product Description.pdf

PRODUCT DESCRIPTION (PD)

DEPARTMENT OF VETERANS AFFAIRS

Electronic Health Record Modernization Integration Office (EHRM-IO)

DMM Software Licenses & Renewals – BimlStudio

Date: January 24, 2024

VA-24-AP-1142

PD Version Number: 1.0

TAC Number: VA-24-AP-1142

Contents

1.0 PRODUCT REQUIREMENTS

2.0 NOTICE OF THE FEDERAL ACCESSIBILITY LAW AFFECTING ALL

INFORMATION AND COMMUNICATION TECHNOLOGY (ICT)

PROCUREMENTS (SECTION 508)

2.1 SECTION 508 – INFORMATION AND COMMUNICATION TECHNOLOGY

(ICT) STANDARDS

2.2 COMPATABILITY WITH ASSISTIVE TECHNOLOGY

2.3 ACCEPTANCE AND ACCEPTANCE TESTING

3.0 SHIPMENT OF HARDWARE OR EQUIPMENT

4.0 GENERAL REQUIREMENTS

4.1 VA TECHNICAL REFERENCE MODEL

1.0 PRODUCT REQUIREMENTS

The Department of Veterans Affairs (VA) Electronic Health Record Modernization Integration Office (EHRM-IO) has a requirement for three (3) brand name Varigence BimlStudio integrated development environment (IDE) software subscriptions and associated maintenance support. Business Intelligence Markup Language (BIML) is a markup language that enables users to automatically create SQL (Structured Query Language) Server Integration Services (SSIS) packages. The EHRM-IO Data Migration and Management (DMM) team uses BIML to programmatically generate the Extract, Transform, and Load (ETL) packages required to load data to the on premises SQL Server instances used to process the data coming back into the VA data ecosystem from Oracle Health Millennium. The team could develop these packages manually at a rate of 1-3 per day, but BIML allows the team to create scripts that programmatically generate hundreds of ETL packages in a few minutes. In versions of Microsoft SQL Server prior to SQL Server 2022, BIML was supported as a free add-in in Visual Studio.

However, the EHRM-IO systems are being upgraded to SQL Server 2022. In order to continue using BIML with SQL Server 2022, the Government must purchase the BimlStudio IDE software.

The maintenance support provided with the software subscription includes bug fixes, upgrades, and customer support. The period of performance will be three years from date of award.

2.0 NOTICE OF THE FEDERAL ACCESSIBILITY LAW AFFECTING ALL

INFORMATION AND COMMUNICATION TECHNOLOGY (ICT)

PROCUREMENTS (SECTION 508)

On January 18, 2017, the Architectural and Transportation Barriers Compliance Board (Access Board) revised and updated, in a single rulemaking, standards for electronic and information technology developed, procured, maintained, or used by Federal agencies covered by Section 508 of the Rehabilitation Act of 1973, as well as our guidelines for telecommunications equipment and customer premises equipment covered by Section 255 of the Communications Act of 1934. The revisions and updates to the Section 508-based standards and Section 255-based guidelines are intended to ensure that information and communication technology (ICT) covered by the respective statutes is accessible to and usable by individuals with disabilities.

2.1 SECTION 508 – INFORMATION AND COMMUNICATION TECHNOLOGY (ICT)

STANDARDS

The Section 508 standards established by the Access Board are incorporated into, and made part of all VA orders, solicitations and purchase orders developed to procure ICT.

These standards are found in their entirety at: https://www.access-board.gov/guidelines-and-standards/communications-and-it/about-the-ict-refresh/final-rule/text-of-the-standards-and-guidelines. A printed copy of the standards will be supplied upon request.

Federal agencies must comply with the updated Section 508 Standards beginning on January 18, 2018. The Final Rule as published in the Federal Register is available from the Access Board: https://www.access-board.gov/guidelines-and-standards/communications-and-it/about-the-ict-refresh/final-rule.

The Contractor shall comply with “508 Chapter 2: Scoping Requirements” for all electronic ICT and content delivered under this contract. Specifically, as appropriate for the technology and its functionality, the Contractor shall comply with the technical standards marked here:

E205 Electronic Content – (Accessibility Standard -WCAG 2.0 Level A and AA Guidelines)

E204 Functional Performance Criteria E206 Hardware Requirements E207 Software Requirements E208 Support Documentation and Services Requirements

2.2 COMPATABILITY WITH ASSISTIVE TECHNOLOGY

The standards do not require installation of specific accessibility-related software or attachment of an assistive technology device. Section 508 requires that ICT be compatible with such software and devices so that ICT can be accessible to and usable by individuals using assistive technology, including but not limited to screen readers, screen magnifiers, and speech recognition software.

2.3 ACCEPTANCE AND ACCEPTANCE TESTING

Deliverables resulting from this solicitation will be accepted based in part on satisfaction of the Section 508 Chapter 2: Scoping Requirements standards identified above.

The Government reserves the right to test for Section 508 Compliance before delivery.

The Contractor shall be able to demonstrate Section 508 Compliance upon delivery.

3.0 SHIPMENT OF HARDWARE OR EQUIPMENT

Inspection: Destination Acceptance: Destination Free on Board (FOB): Destination

Ship To and Mark For: ALL DELIVERY SHALL BE ELECTRONIC DELIVERY OF

SOFTWARE AND SOFTWARE LICENSES TO:

Primary Alternate Name: Augie Turano Name: Tom Huneke Address: Address:

Voice: 412-241-0217 Voice: 770-778-1108 Email: Augie.turano@va.gov Email: thomas.huneke@va.gov

4.0 GENERAL REQUIREMENTS

4.1 VA TECHNICAL REFERENCE MODEL

The Contractor shall support the VA enterprise management framework. In association with the framework, the Contractor shall comply with OIT Technical Reference Model (VA TRM). The VA TRM is one component within the overall Enterprise Architecture (EA) that establishes a common vocabulary and structure for describing the information technology used to develop, operate, and maintain enterprise applications. Moreover, the VA TRM, which includes the Standards Profile and Product List, serves as a technology roadmap and tool for supporting OIT. Architecture & Engineering Services (AES) has overall responsibility for the VA TRM.

Notes to the Contracting Officer

POINTS OF CONTACT

VA Program Manager:

Name: Augie Turano Address:

Voice: 412-241-0217 Email: Augie.Turano@va.gov

Contracting Officer’s Representative:

Name: Starlyn Reed Address:

Voice: 202-910-7491 Email: Starlyn.Reed@va.gov Contracting Officer:

Name: Stefanie Applegate Address:

Voice: 848-377-5198 Email: stefanie.applegate@va.gov Contract Specialist:

Name: Nicholas Fry Address:

Voice: 848-377-5182 Email: nicholas.fry2@va.gov