Boehringer Ingelheim loob ühtse usaldusväärse andmeallika, et muuta operatiivsed ebatõhusused oma ülemaailmsete teadusmeeskondade jaoks suureks kasuks

Väljakutse

Research teams face a hidden productivity drain that is easy to overlook and hard to quantify until someone does the math. Boehringer Ingelheim already ran two global IDBS lab informatics platform installations for non-GxP users and GxP users, yet the formulations workflow connecting the In Vivo planning and Formulations teams remained disconnected and dependent on a fragmented chain of spreadsheets, SharePoint and manual copy-paste between systems.​

Scientists transcribed data between Excel, SharePoint and the E-WorkBook lab informatics systems. Every handoff created a new risk of error. No single source of truth existed. Multiple spreadsheet versions lived across separate drives with no clear authority, and manual re-keying of data contributed to transcription errors and wasted time for rework and revalidation.​

Critical connections between compound databases, clinical planning systems and E-WorkBook did not exist. Scientists were spending 2 to 3 hours per experiment on data logistics alone — time that should have been spent on science.​

The key business needs:​

  1. Eliminate manual data transcription between disconnected systems and remove copy-paste errors​
  2. Create a single source of truth for formulation data accessible to all teams in real time​
  3. Increase scientist efficiency and return time to science​

Lahendus

Working side-by-side with IDBS experts, the Boehringer Ingelheim team co-designed a unified, API-driven workflow around three IDBS components already in place — then found creative new ways to deploy them together to accelerate idea to impact.​

  • IDBS E-WorkBook with Advance became the scientific core. It centralized experiment capture and validation, enforced structured templates to keep every experiment consistent and delivered real-time data aligned to Boehringer Ingelheim standards.​
  • The E-WorkBook Inventory module was deployed in a non-conventional way — not to track physical samples, but as a formulation request repository. Formulation requests were treated as inventory items for structured, low-click retrieval. Data flowed directly into experiments via the existing E-WorkBook integration, with zero context switching and no additional training required for scientists.​
  • The REST API and A2 Data Manager completed the architecture. They replaced manual copy-paste with secure, governed API endpoints that fetched compound and formulation parameters in real time, automated calculations, issued warnings for unsafe values and created a scalable foundation ready for future ML and data lake integrations.

The chosen solution met the company’s core business needs. Key benefits included dynamic data handling, real-time highlighting of data errors at the point of capture and audit-by-exception capabilities. Specifically: ​

  • E-WorkBook structured templates standardized every experiment across sites and eliminated undated and unversioned spreadsheet chaos​
  • The E-WorkBook Inventory module, used unconventionally as a request repository, provided structured retrieval with minimal clicks and zero context switching​
  • The IDBS REST API enabled single-click data retrieval across previously disconnected systems​
  • Automatic warnings trapped errors at the point of entry rather than after experiments had already run​

Tulemus

Since launching in January 2025, structured and guided digital execution has replaced the fully manual process. Scientists now initiate experiments in E-WorkBook. Compound metadata is fetched automatically, inventory data is pulled and verified, formulations are calculated without manual input and warnings are issued in real time — all running in a validated, FAIR-ready workflow that compresses the time from idea to impact.​

Digitization freed time for science and the availability of real-time, contextualized data enabled trend analysis across experiments and assays for faster turnaround from capture to decision. The same reusable API infrastructure now serves as the foundation for every future integration project across the organization.​

In total this saved 6,000+ researcher hours, returning ~3 hours per experiment to researchers to spend on more science.​

“Science time is very expensive. They should not be spending time copying and pasting.”

Brad Feilmeier, Sr. Principal Business Analyst, Lab Informatics Group, Boehringer Ingelheim

Metric improved​Result​
Formulation experiments completed​2,000+​
Time saved per experiment​~3 hours​
Experiments processed per month​118+​
Scientists directly impacted​~70​
Total researcher hours saved​6,000+​
Copy-paste errors since launch​≈ 0​
Systems consolidated into one flow​4 → 1​
New integration types created​4​

IDBS erinevus

IDBS erinevus​

IDBS closely partnered with the customer at every stage. For Boehringer Ingelheim, that partnership included:​

  • Co-design and creative problem-solving: Using the E-WorkBook Inventory module as a formulation request repository, solving a real workflow problem without the need to build a separate database​
  • Built with end users: The template UI was co-designed with scientists — not handed to them — which drove near-instant adoption with minimal training at go-live​
  • Hands-on API enablement: Supporting API credentialing, account provisioning and novel SQL connections to ensure a solid integration architecture from the start​
  • Reusable infrastructure: The API code was designed to be modular from the outset so other teams across Boehringer Ingelheim can adopt the same integrations for new use cases​
  • Long-term partnership: The solution continues to evolve, with IDBS supporting plans to integrate the Request Module, expand to data mining and ML and connect structured data to the enterprise data lake as part of a broader connected ecosystem. Boehringer Ingelheim will also make the transition to IDBS Polar, the next-generation evolution of E-WorkBook.​

1. Edetabel, mida mõõdetakse Turukapital, I kvartal 2024.  

*Data on file at IDBS, accurate as of September 2026.

**IDBS Polar annab samasuguse või suurema kasu kui IDBS E-WorkBook samasuguse rakendamise puhul, lisaväärtust pakuvad täiustatud analüütika, AI/ML ja aruandlus.

Kas soovite rääkida spetsialistiga kasu kohta IDBS tarkvara võib teie organisatsioonile tuua? 

Võtke meiega ühendust