Byram Healthcare speeds processes and reduces downtime using ...
INTEGRATE 2014 Byram Healthcare speeds processes and reduces downtime using BizTalk Adapter for Eric Stott, Stott Creations Informix Jorge Gomez Paul Larsen Titanium Sponsors Platinum Sponsors Byram Healthcare Byram Healthcare National leader in disposable medical supply delivery since 1968
Works with over 300 managed care providers, Medicare and Medicaid http://www.byramhealthcare.com Mediq International provider of medical devices with 7100 employees in 14 countries Acquired Byram in 2008 http://www.mediq.com We promise that if the patient makes one phone call to us, well take care of everything, but that can be a challenge. Nick Piecora CIO, Byram Healthcare Customer call center order Call center representatives with nearreal-time processing
access to coverage info from healthcare payers Centers for Medicare and Medicaid Services (CMS) ZirMed third-party healthcare coverage verification provider Order processing and ERP based on IBM Informix Informix did not natively support web services or EDI Need to connect Informix to CMS and ZirMed In the medical insurance realm, theres no single system that provides an accurate and timely means to verify coverage and reimbursement rates for specific products. It can be a difficult system to work with. Nick Piecora CIO, Byram Healthcare Original solution using SQL Server Temp
SELECT INTO SQL table DELETE from temp table Push SQL Job UPDATE status INSERT INTO warehouse Temp Warehouse Splitter Orchestrati on Individual Request
Orchestrati on ZirMe d Warehouse CALL Informix procedure Custom Web Adapter Statu s Poll SQL Job BizTalk Server SQL Adapter
Temp BizTalk Server SQL Server SQL Server / Linked Server Informix OLE DB Provider Informi x Original solution used multiple steps BizTalk adapters for EDI Access CMS and ZirMed Custom two-step data pump for Informix BizTalk WCF Adapter for SQL Server
SQL Server stored procedures to provide logic and transactions SQL Server linked service to redirect SQL commands to Informix IBM OLE DB Provider for Informix connects over IBM Client for Informix IBM Informix Dynamic Server V11.70 for AIX running on POWER7 Informix stored procedures to input new orders and update status Increased volume causes Byram had recently experienced rapid growth problems Acquisitions and an organic growth rate of 30 percent per year have doubled the size of the business With the increasing transactional volume, performance of the verification processes degraded sharply As the number of records increased, the time required to process each record also increased
Byram was forced to freeze new requestssometimes for daysuntil the backlog had cleared Performance degradation created instability in the system, which was extremely difficult to troubleshoot because of the layered complexity Impact to the business during Call center representatives outages Unable to confirm customer eligibility over phone Routinely reassigned to calling insurance providers to manually verify coverage Customers Grew increasingly impatient
Byram was losing business as a result When we were only processing a few records and the data sets were small, it wasnt an issue. But as we grew in volume, the model became very inefficient; the two-tier solution we had created using SQL Server with IBM Informix OLE DB Provider and IBM Client as a data pump just couldnt scale to meet the volume of new business. Nick Piecora CIO, Byram Healthcare Original solution using SQL Server Temp SELECT INTO SQL table DELETE from temp table
Push SQL Job UPDATE status INSERT INTO warehouse Temp Warehouse Splitter Orchestrati on Individual Request Orchestrati on ZirMe d
Warehouse CALL Informix procedure Custom Web Adapter Statu s Poll SQL Job BizTalk Server SQL Adapter Temp BizTalk Server
SQL Server SQL Server / Linked Server Informix OLE DB Provider Informi x New solution with no intermediary steps Informix ZirMe d Warehouse Individual Request Orchestrati
on Custom Web Adapter Statu s BizTalk Adapter for Informix Temp BizTalk Server New solution required greater Byram turned to Stott Creations to design a new scalability solution
Requirements included greater scalability, higher performance, and improved quality Customer and partner asked Microsoft to deliver an adapter for Informix Microsoft initiated a Technology Adoption Program (TAP) Byram and Stott joined program as a rapid deployment site Stott developed a new BizTalk application to use the adapter Stott tested the application and adapter Stott deployed new solution into production New solution restored system performance Existing capability to verify insurance coverage and accept orders runs 10 times faster Original system compared to new system Old New
17300 Old New 1.87 Old New 5:26 10455 1:11 0.25 Requests (day)
Requests (second) Batch time (hours) New adapter improved IT Performance improvements are evidenced organization in the benchmarking of a daily batch process Previously taken nearly 5 hours to complete and now takes only a little more than an hour Business logic is more tightly coupled with BizTalk System can automatically verify that records were transmitted properly and resubmit any that failed Simplicity of the re-engineered solution has reduced downtime
Reducing burden on Byram IT staff responsible for troubleshooting and maintaining system The adapter works significantly better than the data pump. Where we had been seeing 10-second response times, were now seeing subsecond response times. All the work that had happened in SQL Server is now happening within the BizTalk environment. Nick Piecora CIO, Byram Healthcare The Microsoft BizTalk Adapter for Informix has renewed our commitment to BizTalk Server.
This is a solution that can meet our needs now and for the foreseeable future. Nick Piecora CIO, Byram Healthcare Accessing IBM Informix databases Excel Power Pivot SQL Sever (query processor) SQL Sever (Integration Services) OLE DB Service Components
Custom App ADO.NET Common Provider Model Send Port Solicit Response Send Port Receive Port BizTalk Adapter for Informix (HIS vNext)
OLE DB Provider for Informix (HIS 2013) ADO.NET Provider for Informix (HIS vNext) DRDA Client for Informix (HIS 2013) Managed DRDA Client for Informix (HIS vNext) Catalog Tables Stored Procedure s
Informix Relational Database Management System Informix DRDA Server DRDA over TCP/IP Microsoft Windows AIX, Linux, UNIX, Windows Demo BizTalk Adapter for Informix INTEGRAT E 2014
BizTalk Adapter for Informix Connectivity Informix IDS V11.7 and V12 XA transactions using MS DTC DRDA over TCP/IP using MS client Performance Bulk insert Resultset concurrent read Client connection pooling Data type encoding and decoding Source Receive Port SELECT SELECT (with cursor UPDATE or DELETE) CALL procedure Destination
Send Port INSERT, UPDATE, DELETE updategram CALL procedure Solicit-Response Send Port SELECT CALL procedure Custom SQL statement Connecting to existing IBM LOB systems SQL Server BizTalk Server Internet Information Services Host Integration Server SQL Database BizTalk Services
Service Bus Microsoft Azure CICS, IMS MQ, RACF DB2, Informix Host Files Azure SQL Data Sync Service Bus Relay IBM Protocols and Formats Standard Protocols and Formats Virtual Network and Express Route
TCP/IP and HRP/IP Microsoft Windows Server IBM z/OS and i5/OS, AIX, Linux, UNIX, Windows Demo Microservice for DB2 INTEGRAT E 2014 Host Integration Roadmap Microservices
CICS, IMS and i programs DB2 and Informix databases WebSphere MQ messages (using MS client) Power BI for Office DB2 and Informix databases (Power Query, Power Pivot) Host Integration Server vNext Informix databases (ADO.NET and BizTalk) Managed DRDA client for DB2 and Informix (ADO.NET) Takeaways Byram Healthcare Early access to industry-exclusive technology (BizTalk Adapter for Informix), which significantly improved the quality and performance of their application Stott Creations Expert guidance on BizTalk, Informix, and enterprise solutions with which
to develop a new application to replace existing IBM-based solution Microsoft Vital input and feedback with which to validate and improve technology, tools, documentation, samples and support More Information Stott Creations Working with customers on IBM integration, ESB, and other BizTalk solutions Contact Eric Stott, [email protected] Microsoft Corporation Accepting rapid deployment and evaluation sites into Technology Adoption Program Contact Paul Larsen, [email protected] Questions
INTEGRAT E 2014 Thank you INTEGRAT E 2014 2014 Microsoft Corporation. All rights reserved. Microsoft, Windows, and other product names are or may be registered trademarks and/or trademarks in the U.S. and/or other countries. The information herein is for informational purposes only and represents the current view of Microsoft Corporation as of the date of this presentation. Because Microsoft must respond to changing market conditions, it should not be interpreted to be a commitment on the part of Microsoft, and Microsoft cannot guarantee the accuracy of any information provided after the date of this presentation. MICROSOFT MAKES NO WARRANTIES, EXPRESS, IMPLIED OR STATUTORY, AS TO THE INFORMATION IN THIS PRESENTATION.
Quadrangle: Fairmont East. Location Info: Valley Falls State Park. Rock Formation(s): Pennsylvanian Conoquesnessing Sandstone (Pottsville) Strike/Dip (in degrees): Horizontal, but dip of crossbedding is about 20. Comments: View shows side and top of crossbedding in sandstone that is partly conglomeratic....
Give participants a moment to consider this question individually and then discuss it with a partner. Depending on the time you have available, you may or may not elect to have a brief whole group discussion. National Adult Education College...
Inca Empire (religion) Ancestor worship was a central part of Incan theology. ... terrace farming. 6. The Aztec use of the calendar and the Maya writing system both illustrate that pre-Columbian cultures in the Americas. traded extensively with Africa.
Its archive includes a large number of student productions from what are now significant Australian directors such as Philip Noyce, Gillian Armstrong and Jane Campion. It includes the audio-visual records of significant politicians, for example former Prime Ministers Harold Holt,...