Skip to content
Smart Data
Services
All services
Modern data platforms
Data strategy consultingData engineeringData governance and qualityPower BI and analytics on Fabric

Platforms we build on

Microsoft FabricDatabricksSnowflake
AI
AI-assisted modernizationAI on your dataAI developmentAI readiness workshop

Start here

AI Enablement GuideReadiness self-check
Applications
Application developmentLegacy modernizationERP and enterprise integrationAPIs and API security

ERP integration

SAP S/4HANA and ECC, NetSuite, Dynamics, Oracle, Epicor and others
How we work
Managed servicesScoped projectsStaff augmentationDirect placement

Where the work happens

Dayton, OhioSmart Data Global Center
Work
All case studiesNational distributor620+ known vulnerabilities eliminated across the customer portalsManaged servicesNuvei: Managed services for payments-to-ERP integrationsGoogleGoogle: A custom LMS for the internal sales team
Industries
HealthcareFinancial servicesInsuranceManufacturing and industrialRetail and distributionAll industries
Insights
BlogAI Enablement GuideEvents
Company
AboutCareersSmart Data Global CenterPartners
Talk to us about scope
info@smartdata.net(937) 886-9166

Pharmacy data moved into a shared care platform, tested by 5 people instead of 80

Smart Data built the near real-time data integration that let pharmacists share care plans with the whole patient care team, and an automated test process that cut the testing effort from 80 people to 5.

Built onSQL Server

  • 80 to 5

    people needed for the same testing, after automation

Industry
Healthcare
Engagement
Integration
A clinician in scrubs reviewing information on a tablet

A national retailer with in-store pharmacies and a patient case-management company partnered to improve pharmacy patient care. Together they put in place a Pharmacist Care Plan: one record of the patient's, pharmacist's and care team's concerns and goals for getting the most out of medications.

Making that work meant moving large volumes of pharmacy data into the case-management software quickly and accurately. SDS, a Smart Data company, was asked to design and test the integration.

The challenge

  • Pharmacists needed to exchange information in real time with the entire patient care team
  • Data had to come from several disparate retail pharmacy systems
  • Records needed multiple transformations from the source formats before loading
  • High volumes created complexity and performance pressure
  • Patient data had to stay protected under HIPAA throughout development and testing

The solution

A team of seven developers built and hardened the pipeline:

  • Automated ETL in SQL Server Integration Services (SSIS) pulls data from pharmacy system APIs, transforms it and loads it into the case-management software
  • Data from pharmacies and medical clinics is collected in near real time, so patients and prescribers can view their records
  • New processes for managing and testing SSIS packages
  • Test and development environments brought to parity with production, using sanitized data that protects HIPAA information while still reflecting real production scenarios
  • An automated testing process for the SSIS packages

The results

  • Near real-time pharmacy and clinic data available to the full patient care team

  • Testing accuracy and scale increased by an order of magnitude

  • 5 people able to do the testing that previously took 80

  • The test architecture was adopted by other organizations, raising their productivity too

Where this is going

We build data pipelines that move sensitive data between systems quickly and prove they work before production. If that is your situation, talk to us about scope.

Client

Industry

HealthcareRetail and distribution

Platform and technology

  • ETL & Data Pipelines
  • SSIS
  • SQL Server
  • Azure DevOps

Related services

Microsoft Fabric consultingData engineeringERP and enterprise integrationHealthcare

Working on something like this?

Talk to us about scope

The result

The same testing, done by 5 people instead of 80

Eighty people were needed for the testing before; five people do the same testing once the SSIS packages are tested automatically. The pipeline runs from pharmacy systems and clinics, through automated ETL in SSIS, into the case-management platform and on to one Pharmacist Care Plan per patient.

80 to 5

people needed for the same testing, once the SSIS packages were tested automatically

  1. Pharmacy systems and clinics
  2. Automated ETL in SSIS
  3. Case-management platform
  4. One Pharmacist Care Plan

Related case studies

All case studies

Working on something similar?

Tell us what you are building and what it has to connect to. Here is what happens after you reach out.

  1. A short call about the work

    What runs today, what needs to change and the date you are working toward.

  2. An engineer looks at what’s running

    Scope comes from your systems as they are, before anything is priced.

  3. You get a written proposal

    Covering scope, team, approach and price.

info@smartdata.net(937) 886-9166

Tell us what you are working on

We use your details only to reply.

Your privacy choices

Choose what this browser shares with us. The site works the same either way. Privacy policy